js06's Q&A profile

• SQL Server DBCC CHECKIDENT (jobs, RESEED, 30) does not work

  Hi, I'm trying to set up merge replication and when I try to synchrinize with the subscriber I get the error "invalid column name ROWGUIDCOL". Following an article it recomended to reseed the identity columns on the subscriber so that there is no conflict. Now the tables with the identity column have the "Not for replication "option on. Using DBCC CHECKIDENT (table_name, RESEED, some_value) does not change the SEED when I check. SQL server help file remarks on DBCC CHECKIDENT say that if the column was created with the "Not for replication " option on it cannot change the value. From sql server help file: Remarks If necessary, DBCC CHECKIDENT corrects the current identity value for a column. The cu ...Show All

• Visual Studio Team System New Team Foundation Server MSSCCI Provider Available Now!

  I am happy to report we have released an updated TFS MSSCCI provider here . We have been able to address a number of requests (keep them coming) in this release including the following: PowerBuilder support Enterprise Architect support Improved Open from SCC experience Work items can now be modified in the checkinwindow Get latest on checkout support Check-in lock is treated as exclusive Setup works on x64 This is an unsupported "powertoy" like tool. There have been some discussions about the possibility of supporting it, but nothing yet. Keep reporting issues and comments to the forum or by e-mail . Great news, it's now supported! http://blogs.msdn.com/bharry/archive/2006/09/07/74499 ...Show All

• Audio and Video Development Blu-ray

  Does it bring bad luck to ask this on this forum :) Anyone knows of documentation or sites about BD-J mode, HDMV is a bit limited. Just because there are no HD DVD titles with games on the market (at the moment) and there is one in BD doesn't mean that BD-J is better. I don't think you can do anything more with BD-J that you cannot also do with HDi. Just check out an advanced sample I made once: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=852769&SiteID=1 ...Show All

• Visual Studio 2008 (Pre-release) SVCUtil.exe

  Hi All, I am working in WCF. Here my questio is, is it neccessary that to have Winfx SDK installed on the machine to use the SVCUtil.exe Next question, is there any advantage of using SVCUtil.exe instead of Add service reference Regards, Santha Hi, I have generated the proxy using SVCUtil.exe but I haven't install the SDK. Regards, Santha ...Show All

• Visual Studio How to use OLEDB to Connect to Sybase in Crystal Report Wizard in .Net 2005

  Hi, I hv an problem in using the OLEDB connection in crystal report wizard for Sybase Data Base Approcah that i hv followed is: OLEDB Provider : Sybase ASE OLEDB Provider. (Version 12.5) DataSource: MAGN.ASG,4000 UserID: XXXX Passwrod:XXXX Database: Cons When i enter this information and say Next it gives an error Error: Logon failed. Details: ADO Error Code: 0x Source: ASE OLE DB Provider Description: Cannot open file 'C:\Program Files\Sybase\OLEDB\\MAGN.ASG,4000.ids'. Native Error: ...Show All

• SQL Server T-SQL Question

  I need to figure out how to write a stored procedure to get the correct daily AAbutter price for sales orders on a particular day. I am pretty confused...but I am just a beginner. First of all, a sales person will input a date (@Date) to obtain a correct daily butter price for that day. This will be the date that the order was received...so it doesn't always mean that it is the current date. They will also put in a customer number as well (@Cust_Num). We have a table that gives historical data for the daily AAButter price with the fields MktDate, Price. The catch is how we deligate the AAButter price to our customers. They are categorized in 3 ways: Daily Pricing, M-F Average, and Thursday-Wednesday Average (with no SATor Sun AAButterPr ...Show All

• Visual Basic Retrieving values from DataSet/DataTable

  I have a DataSet with 5 DataTables holding selected fields from different tables. I want to know how to query a DataTable to retrieve any particular column value. Cos, I am using DataTable approach to load Fixed Values (Settings of my app. control panel) on app.load. I want to refer to these values on every calculation. Is this way correct Or, suggest. ...Show All

• SQL Server Integration of RS with Sharepoint

  Good Day , May I know if there is any sites which explains the integration of RS with SPS Regards Alu With SQL Server 2005 Service Pack 2, we will allow for you to publish reports directly to SharePoint 2007. I will blog on this soon at http://blogs.msdn.com/bwelcker . ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Xbox360 to PC Comparison

  Does anyone have an idea what performance I can expect from the Xbox360, I am writing my game purely for the console because I dont want to have to write a load of code for dealing with different spec machines (throttling the number of creatures, etc) and different types of input. The game I am porting is this (original is in vb.net and MDX) - http://www.entombed.co.uk I have managed to port the models, parrallax occulsion mapping shader and per pixel lighting. But I dont know how the Xbox360 is going to perform. My PC is this spec ( cr@p ish) - Intel P4 2.4 (400 FSB) ATI X800 XT PE 768 MB AGP x4 I am receiving an excellent frame rate from my PC and wondered what I should expect from the console, will it be twice as quick or mo ...Show All

• .NET Development Convert Binary file to Ascii and vice versa

  Hi, is there a simple way of converting a binary file to ascii file and vice versa Thanks, -srinivas yelamanchili You cannot convert binary data directly to ASCII these days, ASCII can only represent character codes between 0 and 127. A common workaround is to use Convert.ToBase64String to convert binary data into a Base64 encoding string that only uses ASCII characters... ...Show All

• Visual Studio Tools for Office creating VSTO outlook Addin Setup File

  i have created an outlook addin using VSTO , if i run the program its working fine , but if i install from the setup file , installation is fine, but no menus or buttons getting added to to outlook express, can anybody help me out on this issue.. Hi, I am also getting the same error message "Cannot set the security policy. The specified solution code group name is not valid" I have developed a add-in for Excel. But i have checked the solution code group name throughout all the custom action data. Twice i have created new project and did the same from the deploying visual studio 2005 tools for office second edition solutions using windows part 1 and 2. Thanks and Regards, Sankar ...Show All

• Visual C++ Interaction with an application running in CMD

  Hi all, I have written code for an appliation which needs to interact with another application which runs in CMD. I want to receive all the information produced by the application running in CMD so that I can manipulate them and at the same time I should be able to provide input to that application. Please suggest me somehting regarding this. Thanks, Looks like you want to call a console application from another one and display or use the output of that application in the calling console. No that's not my objective. The Called program will run in a different console and it can run for infinite time unless proper command is given to it. This can be achcived either using ShellExecute() or system() methods as mentioned by you. ...Show All

• SQL Server "Cannot retrieve code page info..."

  Hello again! I got a problem using an OLE-DB Source in my data flow task. It is an Informix-Server using the newest OLE DB-Driver provided by IBM. However, when I set up the OLE DB-Source with connection manager and SQl-Query, I get the following warning message: Warning at {2B334CA3-A792-4BC2-93AA-12FADCF1E696} [OLE DB Source [45]]: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used. Later when I tr ...Show All

• SQL Server File Groups

  Hi everyone, While creating our database in only one disc(C or D), suppose that we create more than one file group in order to group our data files. However, in this situation; I wonder that whether it brings any benefit or advantage to us. Also, I wonder that why we always have to put our data file into separate file group if we use separate discs for data files. Is not it allowed to use only one file group even if we use separate dics Would you explain these to me Thanks Hi, You suggest me to put log to different discs which I also appreciate since it is obvious that this brings performance benefit to the dics. But at the following link , it supports what I said about SELECT INTO. Reads from one discs and write to another table w ...Show All

• Visual Studio 2008 (Pre-release) WCF Channels

  Hi, I have the following scenario: IDmmyContract dummy = ChannelFactory<IDmmyContract>.CreateChannel("binding") i would like to know whether i can cache dummy for sometime and use it from more than one thread, so does the contract instance holds context information that are not thread-safe What;s the cost of creating a new contract instance per method call Thanks Yes, it's ok to have your channels cached for as long as you like. Note that you should make sure your code is resilient to the cached channel becoming unusable due to idle timeouts, etc. You can detect this by hooking the Faulted event on the channel and/or by wrapping your call in a try/catch (CommunicationExce ...Show All