dcroman's Q&A profile

• SQL Server Triggers fire when no records are affected?

  Why is it that SQL triggers fire when the result of the insert/update/delete query returns nothing. I have found that I have to make special coding effort in my triggers to detect that condition or they will exceed nesting limits. This problem, IMO, is wasteful of the DBA's time, and the server's overhead! The same case could be made for not firing the update trigger if no data has changed. The engine has to know this, as it is constructing the insert/delete virtual tables. Is this something that the SQL engine designers are considering changing If not, why not Just to add to what Steve has said. The most sensible and easiest is to add 'if @@rowcount=0 return' as the first statement in your tri ...Show All

• Visual Basic Disabling sort function in Datagridview

  Hi Is it possible to disable the "sort function" in datagridview that happens when pressing the header I would like display some data that you cant order by clicking on the columheader. Can you lock the headers somehow i dont want any column to get sorted . But I am desktop application user and i don't get any such property in datagridview. If u can please help me. ...Show All

• SQL Server Login failed for user 'TEST\administrator'. [CLIENT: <local machine>]

  Hi Friends, I am getting the below error while installing CSF DevLite edition on Following is the breif Info Server Is : Win2003 SQL SERVER 2005 Installed on Same PC Domain Name is : Test User : Administrator he is a build in Admin, PLEASE HELP ME!!!! Thanking in advance. EVENT LOG 1: Login failed for user 'TEST\administrator'. [CLIENT: <local machine>] EVENT LOG 2: The description for Event ID ( 11609 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following info ...Show All

• Visual Studio Team System Bug - UI crash & Build fails without errors or warnings

  This is related to http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=848718&SiteID=1 but now I can reproduce the other error (project does not build) and it goes off topic, for that reason I'm starting a new thread. In the previous thread I (several other threads indicate this problem too) reached a state where it was no longer possible to build or deploy the project. In this state there were / are no errors or warnings when an attempt was made to build. I have found that this occurs when a file is deleted from the project and for some reason the project file is not updated to reflect the deletion. In this case it was a crash of the IDE caused by being to quick changing the focus after a delete. On restart the IDE did indicat ...Show All

• Visual Studio Express Editions grrrr - registering

  For some reason the registration page says my email address is invalid so i can't get the key, but its the same one i logged on with. Help Thanks!! good point lucas, i edited my profile on the page you specified, tried again the registration and it works! there is probably some missing part in the web visual studio registration ...Show All

• Visual Studio Organizing additional content

  Asside from interrupting the processing and using a external script or executable, how does one go about organizing additional content within the help file Thanks! Rory I don't have an e-mail address for you, so I'll stick it on my webserver . Thanks! Rory ...Show All

• SQL Server ExceptionHandling in T-SQL?

  Hi all, Is there any concept of exception handling in T-SQL while writing Stored Procedures, plz. help me with this issue. I'm using SQL Server 2000 To back up what Robert said, T-SQL did not have a rich set of error handling capabilities in 2000, whatsoever. You have to deal with the error message on the client end. So be careful to check for and close any transactions you might have started when you get error messages back and want to stop the batch. ...Show All

• Windows Forms Binding Complex Business Objects to a DataGridView

  Presently I have a Business Object Called Client as shown in incomplete form below. I have a DataGridView bound to a bindingsource which the bindingsources datasource contains a of List<Client>. Is there anyway to set the DataPropertyName on the DataGridView columns to items in the child objects public class Client : BaseBusinessObject{ private Person _clientContact; private Address _clientAddress; private string _clientName; public Person ClientContact{ get return _clientContact} public Address ClientAddress{get return _clientAddress} public string ClientName{get return _clientName} } public class Person{ //person properties} public class Address{ //address properties ...Show All

• SQL Server Unble to define composite PK for return table definition of Table valued function

  Hi, I am unable to define a composite PK for return table definition. It does not let me add table level composite primary key. How can do that . I can not see any return table example with composite PK ALTER FUNCTION [dbo] . [SalesProjection] ( @HistoryStartDate datetime = null, @HistoryEndDate datetime =null ) RETURNS @SaleProjTable TABLE ( CompanyId int , DeptId int , Product int , ProjectionQty numeric ( 19 , 6 ) , Constraint PK_Salesprojection Primary Key(CompanyId,DeptId,Product) ) as begin -- do work here return end @SaleProjTable TABLE ( CompanyId int NOT NULL , DeptId int NOT NULL , Product int NOT NULL, ProjectionQty numeric ( 19 , ...Show All

• .NET Development Allowing null values in otherwise restricted enumeration

  Excerpt from XSD: < xs:complexType name = " CT " > < xs:sequence > < xs:element name = " CTval1 " type = " ST " nillable = "1 " /> < xs:element name = " CTval2 " type = " xs:string " /> </ xs:sequence > </ xs:complexType > < xs:simpleType name = " ST " > < xs:restriction base = " xs:string " > < xs:enumeration value = " STval1 " /> < xs:enumeration value = " STval2 " /> < xs:enumeration value = " " /> </ xs:restriction > </ xs:simpleType > I would like to allow ...Show All

• SQL Server People with same last name causing problems (Adam you there)

  I run a report which displays transcripts for members. One page per person with their name, courses they've took, date of the course and their score. The problem I am having is when the report runs and comes across the same last name for many people (say, Hanna and Billy Alexander), it's only giving me the first "Alexander" it comes across and it is putting all the information for the other "Alexander's" in that first transcript. How do I separate out the people who's last name is the same say "Smith" or Jones" I have a distinct clause on my query and when I run it I can see the other people with the same last name and their unique courses and scores (each of them have a unique member ID) - it's w ...Show All

• Visual Studio Team System Review WI isn't associated with an iteration?

  Just curious, why isn't a review workitem have iteration and area fields Shouldn't a review be associated with these Jason, If your team requires these fields to be part of the Review work item, you can customize it to add the 2 fields. The work item types shipped out of the box may not meet all your needs but they are easily customizable so you can tailor them to meet your organization's needs. Look here for more details on modifying the work item types: http://msdn2.microsoft.com/en-us/library/ms243849.aspx Thanks ...Show All

• Visual Studio Tools for Office "RaceOnRCWCleanup was detected"

  I have an Outlook addin developed under VS2005 and VSTO2005. It acts as an interface between our CRM application and Outlook, transferring data between the SQL Server 2005 backend and Outlook. If the user quits Outlook while data is being transferred, under the debugger I get an MDA popup that indicates that ... " RaceOnRCWCleanup was detected Message: An attempt has been made to free an RCW that is in use. The RCW is in use on the active thread or another thread. Attempting to free an in-use RCW can cause corruption or data loss." I'm not sure if the RCW ("Runtime Calleable Wrapper") is one to Outlook, to SQL, or something altogether different. Is there a "safe" way to release the RCW ...Show All

• Visual Studio VSS Space

  Hi all, Our VSS size has grown very high >45GB. We believe that the projects in VSS won't constitute that much of space, it should not be more than 10GB. I am not able to run analyze since it fails due to insufficient space. Is there any way I can find which files are no longer use and can be deleted Thanks RM I meant there are lot of files in VSS database (aaaaaa.aa) which is over 1GB. I ran the following command ss PHYSICAL $/ to check which projects are mapping to which files in VSS. I am not sure if deleting the files present in VSS db but not mentioned in the list generated by ss command would cause any harm. Particulary if the files are anyway used while checking history... Thanks RM ...Show All

• Visual C# How to replace a line on a text file without creating a new file.

  I am new to c#, I am using streamreader and streamwriter. However, I do I open a text file, replace the 5 line with a new string without creating a new file Thanks in advance. And about how to read a file and modify it into another file, here is an example:             FileStream fin = new FileStream ( @"C:\input.txt" , FileMode .Open, FileAccess .Read);             FileStream fout = new FileStream ( @"C:\output.txt" , FileMode .Create, FileAccess .Write);             StreamReader sr = new StreamReader (fin);  &n ...Show All