SQL Server Tools

SQL server I/O has an excellent feature. According to this document: [link] it will perform retry operations if the I/O API returns ERROR_NO_SYSTEM_RESOURCES (1450). I have another application that I would like to imbue with ...

Any advice greatly appreciated. Thanks. jordan. ...

Hi, where can I find last change date for a stored procedure, in management studio it shows create-date but not when it last changed. Good to have when there are lots of developers on a test server... Thanx Jonas ...

Can anyone help me with my questions about the following deadlock. Deadlock encountered .... Printing deadlock information 2006-08-14 15:45:55.04 spid4     2006-08-14 15:45:55.04 spid4     Wait-for graph ...

I backed up a database (SQL 2000) from EM but because some disk problems the file became corrupted.  Aparently part of the problem was the transaction log did was not truncated before (it is twice the size of the data) ...

Is it possible to create foreign key between to distinct SQL databases ? Database A contains table [customers] (primary key : customer_id) Database B contains table [invoices]  (each invoice should be linked to a customer. Foreign key : customer_id) I would like to create an integrity constraint between ...

Am I the only one who found this useful? I am unable to find in Management Studio the equivelent to 2000 Query Analyzers "Show Server Trace". If it is no longer there, is there an equivelent way to do this? ...

I have to populate a summary table everyday. Need to count the number of (STATUS =)'Opened', 'Testing', 'Closed' and 'Pending'  from the  Cases table and INSERT these values  into the 'Summary' Table at 10:00 PM  everyday. ...

In SQL Server 2005, unless you belong to the sysadmin server role, executing msdb.dbo.sp_help_job will always return "0 (unknown)" in the current_execution_step column of first dataset returned. Granting the user membership to the SQLAgentOperatorRole, SQLAgentReaderRole, and SQLAgentUserRole does not make a difference. ...

Hello all, This seems to be a recent development. It appears that Integer data types are formatted with comma/1000's separators.  I don't think this was occurring before. Is this just a simple setting in QA or EM on my workstation or is this a setting on the server that may have inadvertently been set? ...

Hi all, I have a complex query inside a stored procedure. When I try to see the estimated query plan from Query Analyzer it hangs (I wait for at least one minute). When I stoped the QA with the red button it answers with a syntax error... ...

Hi all, I have a complex query inside a stored procedure. When I try to diplay estimated execution plan in query analyzer, it hangs. And then I have to stop the query. When I click the stop button it QA returns ...

Hello, just a quick reminder: There are 2 days left for the 75% discount on our LogManager Series. So, hurry up and join the party until Oct. 16th, 2006. [link] The LogManager series is a full-featured auditing suite for several ...