rternier's Q&A profile

• Visual Studio 2008 (Pre-release) wcf or wse3.0

  I have a simple but deciding query. I need to implement web service security(message level). Should i use WCF or WSE3.0 for this.Which one is latest. Also is the release version of WCF out.If yes, its version number please. Regards we do have pre-defined binding WSFederationHttpBinding that provides the way in WCF for WS-Federation protocol. click on http://msdn2.microsoft.com/en-us/library/system.servicemodel.wsfederationhttpbinding.aspx for more info WCF also have a concept of federated security which might be of your intrest too regards Nishith Pathak MVP-Connected System Developer Http://DotNetPathak.Blogspot.com ...Show All

• Architecture Synchronizing Legacy DB and Application DB

  Hi All, We are developing a solution which requires consulting some information on legacy systems. There is also a requirement to keep the system available even if the legacy systems are out. We are thinking about replicating the information on our application DB as a contingency (it is acceptable if the data we have to use does not change often). My questions are: Have anyone used a different solution for a simmilar requirement If not, what would be the best way to do this 1) Implement a windows service that update our DB copy from time to time (the problem here is that our application is running on a cluster, so we need to control the concurrency between the services running on each cluster machine) 2) Use som ...Show All

• SQL Server How to export SQL data to Excel SpreadSheet using SQL Query?

  Hi Im using this query to select ,calculate and format data like Refer here for more understanding:- Select DateAdd(Hour, DateDiff(Hour, 0, RowDateTime), 0) As RowDateTime, Avg(Meter1) As Meter1, Avg(Meter2) As Meter2, Avg(Meter3) As Meter3 From TableName Group By DateAdd(Hour, DateDiff(Hour, 0, RowDateTime), 0) I want the output of the query to be written in the excel Sheet. Your help will be highly appreciated. Derek Comingore - RSC wrote: use SQL Server Integration Services (SSIS) Hi, Thanks for the reply but im using Visual Studio Express and it doesn't have (SSIS). Any Ideas ...Show All

• Visual Studio Team System Ordered Test Becomes Non-Runnable After Closing VS IDE

  A valid and runnable Ordered Test becomes invalid and Non-Runnable after closing the VS IDE and then re-opening it. The “Non-runnable Error” is: “Cannot find the test 'XXXXXXX' with storage 'bin\debug\YYYYYY.dll'.” The only way we've been able to correct this problem is by removing the Unit Test (that VS thinks is invalid) from all of the Ordered Tests and then immediately adding it back. This solves the problem until you close the IDE again. But manually modifying every Ordered Test in our project every time the IDE is loaded is not a usable workaround for our team. Is there a fix or workaround that is permanent   Thanks, -Matt It's neither #1 or #2, or at least we ...Show All

• Visual Studio 2008 (Pre-release) FlowDocument text leading

  Hello, any of you know how to change the leading (space between lines) of the text of a paragraph in a FlowDocument. Thanks a lot !!! Hello I just found the way to solve my problem. I share with you what to do: < Paragraph FontFamily = " TheSans Num " FontSize = " 14 " LineStackingStrategy = " BlockLineHeight " LineHeight = " 15 " > The key is to assign BlockLineHeight to the LineStackingStrategy property and than select the LineHeight value that we want. Thanks a lot people !! ...Show All

• SQL Server Transactional Replication - Undistributed commands

  Hello, I have a publisher set up to transactionally replicate just one table which has about 19000 rows. The snapshot agent finished and everything was OK the first day. Now (day 2) the replication monitor estimates that latency to the subscriber = 10 hours and undistributed commands>600,000 and growing each minute. How could this be when data is only inserted into this table and it has <20,000 records Please advise...thanks! I don't see any errors other than those caused by occasional "network not found" errors. Permissions, etc haven't changed (this is one of several tables being replicated and the rest of them work fine when I delete the publication for this one table). The problem ...Show All

• SQL Server Retrieve value within a data flow

  hi, I am doing a data flow to insert data into a dimension table(A) and master surrogate key table(B). Master surrogate key table(B) will be inserted prior to dimension table(A). My dimension table(A)'s key is depend on the last key in master surrogate key table(B). The data flow started from a flat file and checking if the key found in dimension table. If not found, insert a record into B. Then generate the new record to A with max id from B. My question is how to retrieve the max id in master surrogate key table(B) in a data flow and use it as an input to my dimension table ...Show All

• Software Development for Windows Vista How IEUser.exe and IExplore.exe communicates each other

  I am migrating a software that was running in IE (in XP, Win2k, ... but not in Vista). What this program does is to basically intercept (using API interception by modifying the iexplore import table in memory) the ShellExecute API. This is a compressor/decompressor soft. The problem is that when IE is in protected mode, it does not call ShellExecuteEx, but it "tells" IEUser that a given file will be executed. I would like to know how iexplore tells ieuser that a file has to be launched.... I've used several tools like Process monitor (from sysinternals) but I don't see any event neither file that is used... Thanks! Hello. Probably a good place to find out this type of information ...Show All

• SQL Server Select *

  I know Select * has a performance impact and its better to use Select Column1, column2... But is this also true for Select * from #TempTables. Thank you all for your comments. Just one more thing. If I dont use indexes in my #TempTables ie. its a simple #temptable, Will i still get a performance improvement if i use Select Column1, Column2 Column 3.. instead of Select *. ...Show All

• Internet Explorer Development Missing application icon in the customize dialog

  Hi folks, this is my first post to this forum. Background: I and my company has an application for updating there homepages directly in Internet Explorer. It works well in IE 6, you start the app by clicking on the icon in the toolbar. The problem is now in IE 7, the application is still accessible through the View/Explorer bar. But the icon is missing. And the icon is not available in the Customize Toolbar dialog. In IE6 I have this in the registry to get it to work: [HKEY_LOCAL_MACHINE\Software\Microsoft\Internet Explorer\Extensions\{4C1A4A92-7CB2-425a-9E4B-665BAED90D27}\] "ButtonText"="Portello" "Clsid"="{E0DD6CAB-2D10-11D2-8F1A-0000F87ABD16}." "ClsidExtension"="{03BD04A4-2 ...Show All

• Internet Explorer Development Interacting w/tabs in IE7

  Is there a recommended way of (a) enumerating open tabs in an existing IE7 window, (b) figuring out which tab is active, and/or (c) setting a specific tab to be active I am working with a .NET forms applications, not an IE7 extension. The only way I've found to enumerate tabs is to step through the HWND hierarchy and look for windows of class TabWindowClass, but this seems awkward and doesn't let me do (b) or (c). If this is the best way to interact with tabs, does someone have a nice clean example of how to do this in a reasonably robust way, how to get IWebBrowser2 interfaces to individual tabs, activate tabs, etc. Thanks for any tips you have! -Dan http://research.microsoft.com/~dan (Interestingly, MSDN forums _insis ...Show All

• SQL Server call store procedure from another store procedure

  I know I can call store procedure from store procedure but i want to take the value that the store procedure returned and to use it: I want to create a table and to insert the result of the store procedure to it. This is the code: Pay attention to the underlined sentence! ALTER PROCEDURE [dbo] . [test] AS BEGIN SET NOCOUNT ON ; DROP TABLE tbl1 CREATE TABLE tbl1 ( first_name int , last_name nvarchar ( 10 ) ) INSERT INTO tbl1 ( first_name , last_name ) VALUES ( exec total_cash '8/12/2006 12:00:00 AM' '8/12/2006 12:00:00 AM' 'gilad' , 'cohen' ) END PLEASE HELP!!!! and God will repay you in kind! Thanks! Let's say @res1 is output parameter ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Any Complete n00bs Besides me?

  Hi guys. I am a complete n00b when it comes to game programming. I work in the web hosting business and work with ASP.NET a lot. So some stuff looks familiar. But C# is a whole new monster. This release of XNA by Microsoft (thanks by the way) has inspired me (and my small team of two) to make this cheesy side-scrolling game idea we've juggled around for years. I'm not sure we'll ever finish, but it's more of a hobby than work. So, my question... Are there any other true new folks besides me Anyone totally new to this "game programming" world I like it so far. I'm doing tutorials like mad. Soon I'll actually be able to start my game You will find that you are not alone in your travels... Just remember to ask questions ...Show All

• SQL Server Adding Data Viewer causes BI Studio to crash

  I am having this issue with BI Studio when I add Data Viewer to a relatively large data set, it causes the Visual Studio to crash. Has anyone experienced this Any help on this will be highly appreciated. Thanks, Ashish Also, I should mention here an important information. This happens only when I set the MaxBufferRows to 1000000 and BufferSize to 104857600. Thanks, Ashish ...Show All

• Windows Forms WMI help! Confused!

  Ok, I am using WMI to get the name of the network adapter on a users machine. Here is how I am doing this: ManagementObjectSearcher searcher = new ManagementObjectSearcher("Select Name from Win32_NetworkAdapter"); foreach (ManagementObject adap in searcher.Get()) { this.textBox1.Text = "Adapter Name: " + adap.GetPropertyValue("ProductName"); } Problem!!!!!!!!! --------------------------------------- it only returns a name of Packet Scheduler Miniport! ---------------------------------------------------- I tried changing this: adap.GetPropertyValue("Name"); to this: adap.GetPropertyValue("ProductName"); But then it jsut says that it cannot be found. ...Show All