You can get the name of the log file for your database by looking in the sysfiles table. [Read More]

You can use cursors in SQL Server stored procedures to process data already in the database and take action accordingly. These can be used just like recordsets within standard code - for example: [Read More]

For example, to change the owner of table MyTable to user MyUser, just run the predefined stored procedure sp_changeobjectowner: [Read More]

Catching unknown / dynamic variables [Read More]

Conditional Debugging Attribute [Read More]