Recently I had troubles restoring a database in my SQL Server 2005 instance (SP3). I used the ‘wizard’ in the SQL Server Enterprise manager but after I got the message ‘restore completed successfully’ the database hung in ‘Restoring’ state, blocking connections. read more →
Braindump of a session where I had to remove a SQL Server database from single-user mode. read more →
Microsoft SQL Server 2005 JDBC Driver java test program. read more →
Create, rename and drop a database in sql server … read more →
Control structures syntax; IF THEN ELSE, CASE, WHILE . read more →
Say you have an sql trace for the event ‘TSQL SQL:StmtCompleted’ you are, most probably, NOT interested in the sql statements executed through the SQL Server Agent for instance. read more →
Returing values into tsql variables from a dynamic sql statement using sp_executesql stored procedure. read more →
A translation of oracle dba_* tables/v$* views/functions to their respective mssql counterparts. read more →
Display/Alter running traces or an alternative way to shutdown your server (when ‘c2 audit mode’ is enabled). read more →
Display or change global configuration settings for your mssql server through sp_configure. read more →
,
