I'm not sure why working from home would imply a pay cut. The employer is the one who saves money when the employee works from home - no infrastrcture costs...

?? looks like the original question got deleted... Oh well!

take out the "as" in the table definition for Size_backup_D and it will work...

declare @p nvarchar(255)

set @p = 'This is the data import for ' + convert(nvarchar, getdate())

select @p

it's up to the developer of the sp as to whether it continues when a problem is encountered. As the previous post says, look for transactions... specifically a rollback (or...

would something like this work:-

declare @db varchar(255)

set @db = 'mydatabase'

declare @sql varchar(1024)

select @sql = 'select stats_date(object_id(''' + @db

November 8, 2006 at 3:58 pm