Cannot shrink transaction log SQL 2005
If you ever come across a MS SQL 2005 transaction log that refuses to shrink, this little bit of code might help you out.
Posted on July 28, 2012 at 20:12 by simon · Permalink
· Leave a comment
In: SQL · Tagged with: dbcc, sql, Transaction log
In: SQL · Tagged with: dbcc, sql, Transaction log
T-SQL Example code: useful stores procedures and snippets
Here are some useful one liners that I find very useful
Posted on July 12, 2012 at 23:41 by simon · Permalink
· Leave a comment
In: SQL · Tagged with: alter database, attach, dbcc, detach, exec, restore, sp, sp_, stored procedure, update
In: SQL · Tagged with: alter database, attach, dbcc, detach, exec, restore, sp, sp_, stored procedure, update
T-SQL Example code: SQL Fixes
Here are a few lines of code that have got me out of troubel in the past: