The following VBScript code snippet can be used to script all SQL Server Jobs on a SQL Server instance:
There are other tools such as SQLPing (sqlsecurity.com/DesktopDefault.aspx?tabid=26) that can be used to scan an IP address range for SQL Server instances.
For as long as I can remember the sqlwish@microosft alias has been used for submitting features and ideas to the Microsoft SQL Server team.
Below are the steps to generate a deadlock so that the behaviour of a deadlock can be illustrated:
— 1) Create Objects for Deadlock Example
An update to the SQL Server 2005 Books Online (BOL) has been released and can be downloaded from http://www.microsoft.com/
The November edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The VBScript code snippet below uses SQLDMO to read the EventInfo column from DBCC INPUTBUFFER for a specified SPID:
I have finally had an opportunity this morning to re-build my laptop with the RTM of Visual Studio 2005 and SQL Server 2005.
If you are ever looking for a message that has been posted to the SQLDownUnder mailing list, then the complete archive can be found at http://www.stillhq.com/
In SQL Server 2000 there are two ways to identify the New Database default locations ie. where the data and log files are created when a database is created without specifying a filespec