Srinath - MSFT's Q&A profile

• SQL Server Avoiding deadlock

  I have a stored procedure spUpdateClient, which takes as params a number of properties of a client application that wants to register its existence with the database. The sp just needs to add a new row or update an existing row with this data. I tried to accomplish this with code somethign like this. (The table I'm updating is called Client, and its primary key is ClientId, which is a value passed into the sp from the client.) IF (SELEC ...Show All

• Visual Basic About Timer

  I'm trying to define an interval shorter than 1 to object timer, but itsn't possible. Are there someone who knows about another way to do this with other component. I'd like to send byte from an serial port throw tcpip and receive from other serial port throw tcpip. Example: I have a device that conect an cable with serial port and rj45, this device has an ip adress like 192.168.0.16 and in this serial port has a point clock connected and I ...Show All

• SQL Server Error Message 443

  Hi, I'm trying to create the following function: CREATE FUNCTION dbo.get_id(@name NVARCHAR(50)) RETURNS INT AS BEGIN  DECLARE @id INT  SET @id = (SELECT id FROM dbo.language WHERE name = @name)  IF @@ROWCOUNT = 0   RAISERROR('Specified item does not exist', 16, 1)  RETURN @id END GO And I get the following error message: Invalid use of side-effecting or time-dependent operator in 'RAISERROR' within a function. ...Show All

• Visual Studio dotNetFX Install Error

  I am trying to install dotnetfx.exe for Framework 2 on a Win2000 Advanced Server machine and it blows up with the message shown below. Any ideas what I can do to get it to install. dotnetfx.exe - Appplication Error The instruction at "0x0100302c" referenced memory at "0x01e81000". The required data was not placed into memor because of an I/O error status of "0xc000009c". Click on OK to terminate the program ...Show All

• SQL Server Query Analyzer to SQL Server 2005

  For testing purposes, I installed SQL Server 2005 (September CTP Developer edition) on a Windows XP Pro machine whoch does not belong to a domain.  I have a Windows 2000 Advanced Server ruiing SQL Server 2000(SP4) and used Query Analyzer to connect to SQL Server 2005 in the XP machine. I am encountering a [DBNETLIB] General network error.  I already used an IP address instead of the server name, I can PING the IP address of the SQ ...Show All

• Visual Studio Extending editor context menu for .xml and .css files?

  I have a VSIP package with several commands. Those commands are added to the editor's context menu. In .ctc NEWGROUPS_BEGIN section I have a context menu group set up via guidSHLMainMenu:IDM_VS_CTXT_CODEWIN parent group Id. Unfortunately, that doesn't cover .xml and .css (and some other similar) files. Thus my menu items don't appear to in the context menu for those particular file types. Could someone share the group Id (simil ...Show All

• Visual Basic Making a Start Menu in VB.Net

  Hello, Does anyone know how to make a menu similar to the "Start" Menu, so that I can allow the user to drag & drop items from different folders in the same menu I need to let him/her rearrange the different items of the menu and add new folders and items. Thank you for your help! I'm not sure if it's the same control, but take a look at Lutz Roeder's CommandBar for .net. http://www.a ...Show All

• SQL Server [OLE DB] how can i use IRowChange::Insert() to insert data ?

  i have some objects like this:CDataSource   ds; CSession         ss; CCommand<CDynamicsAccessor> rs; and i successfully opened rs like this: ...// connect to MS-SQL Server CDBPropSet* DBPropSet = new CDBPropSet(DBPROPSET_ROWSET); DBPropSet->AddProperty(DBPROP_IRowsetUpdate, true); DBPropSet->AddProperty(DBPROP_UPDATABILITY,DBPROPVAL_UP_CHANGE|DBPROPVAL_UP_DELETE| DBPROPVAL_UP_I ...Show All

• Visual Studio Team System Test Case ID

  I'm playing with some code in the TIP, specifically in the MergeResults() method, but I'm confused by the behavior of the TestElement.Id. I'm monitoring this Id as it comes through MergeResults() by calling resultFromWire.Test.Id, but the value changes everytime I run the test. I was expecting that GUID to be the same everytime for the same test. This seems more like a a TestRun Id in practice than a TestElement.Id. I'm running the same test ...Show All

• Visual Basic A Complex Graphics Question

  Goodness!   Recently I bought Office 2003 and was astounded at it’s graphics and toolbars.   Along with that I almost lost the old toolbar that I’ve become some reliant on. I haven’t really lost it, but its graphics support is old and my icons look awful.   In order to learn vb2005 (from vb6) and to have pretty graphics   I decided to write a toolbar with identical functionality . Over the years I’ve read a ...Show All

• Windows Forms listbox control

  how do I manually add in listbox items in at runtime that act like they have a databinding. example ( I know this is incorrect) ListBox1.Items.Add("display",value) basically how do you add an item with a name/value pair would  I have to create clas ...Show All

• Visual Studio Team System Warehouse not updated due to field deletion

  I had posted a problem deleting a field definition ( http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=162221&SiteID=1 ).  We eventually were able to delete the field but now it seems that by removing the field the cube has been affected and the warehouse no longer updates correctly.   The field deletion worked, the fields are no longer appearing. (noticed that the fields get renamed in the Field table, they are no ...Show All

• Visual Studio ContinueOnError, yet still failing the build?

  I'm using MSBuild to run all the unit tests for our projects. The target looks like this: <Target Name="Test" DependsOnTargets="Build">    <CreateItem Include="FakeTestTarget\bin\$(Configuration)\*Test.dll;">       <Output ItemName="TestAssemblies" TaskParameter="Include"/>    </CreateItem>    <Exec ContinueOnError=" true " Command="mstest ...Show All

• Software Development for Windows Vista Custom If activity

  Hi, in beta1 I was able, enclosing it in a sequence activity, to create a branching that is more user friendly: I was exposing meaningful properties for the specific task for which the branching was meant (e.g. a document category), still retaining the ability for the user to drag his own flow in the different branches. I don't see anymore how to simply implement this funcionality in beta2: Grey box model is not supported anymore, so I can ...Show All

• Visual Studio Team System Feature suggestion: Option to open last project on load

  Hello, it's been a while since I checked on FxCop, so this may have already been suggested before. If so, I am sorry. It would be practical I believe to provide an option that would make FxCop load the last loaded project whenever FxCop starts up. TIA. What FxCop provides for this is a most recently used project and analysis target menu item. Look under the 'File' menu and you'll see you can choose from sev ...Show All