Another idea is to use a job with Agent Tokens to name your log file by "job start time" for instance.

Here is an example of what the job text might look...

This query gives you the row size of every table in the db.

select o.name, sum(c.length)

from sysobjects o,

     syscolumns c

where o.id = c.id

  and o.type = 'U'

group by o.name

order...

There are a few different ways to do this. The method I use the most is to create a temp table in the parent stored procedure and then insert the...

In the past I have used 2 techniques to by pass triggers. One is to create a dummy temp table on the connection and then check in the trigger for...

Here is code that will give you the table name to which the currently executing trigger belongs.

Create Trigger <triggerName> on <table>

for update, insert, delete

as

 Select TableName = Object_Name(Parent_Obj)

 From SysObjects o

 Where...