SQL Server database programming

Is there a way to suppress column headers in the results grid? I need to create a list of records from a specific table in multiple databases, but I don't want the column header to appear between the data from ...

Is there a reason why SQL would chose not to use an existing index on a table, when the data is being request in a UNION statement? Here is the type of statement I am using: Select * from Archive..report where cn = '12345' ...

Hello, I need to automate the replication from live server to test server (i.e weekly backup of a live server followed by restore to the test server). Any pointers would be greatly appreciated. Thanks in advance, Don Diego ...

SQL Server 2000. Inside a stored procedure I wrapped and update in 2 print statements as follows: PRINT 'e'   UPDATE dbo.MailNotificationRecipients SET SendTo = @SendTo, CopyTo = @CopyTo     WHERE UserGroupID = @UserGroupID PRINT 'f' The output is suprising to me ...

Hi, While I can run the following stmt. explicitly: --start DECLARE @iMiscItemId INT DECLARE @iPaymentItemId INT SELECT @iMiscItemId = TEMPLATE_ITEM_ID FROM T_GL_TEMPLATE_ITEM WHERE ITEM_NAME = 'MISC' SELECT @iPaymentItemId = TEMPLATE_ITEM_ID FROM T_GL_TEMPLATE_ITEM WHERE ITEM_NAME = 'PMT_CREDIT' SELECT CASE TRX.TEMPLATE_ITEM_ID         WHEN NULL THEN CAST(@iMiscItemId AS VARCHAR(20)) ...

In SS2000 I used this to truncate the log: dbcc shrinkfile ('MyDatabase_Log', 2) At 1st that worked in SS2005, but not anymore. It runs, but doesn't reduce the file size. When I first installed SS2005, Shrink File in Management ...

Hi, I try through C# (.NET) to connect to a database. I registered earlier a server and then I deleted the registration. Then I registered another one and I am able to see in the SQL Server Enterprise Manager my tables. ...

Hi all I would like to calculate the cumulative summation by ordering the descending type from htese below data, Id            Status        Item    Description        Score    Amount ...