another way would have been to detach the database, rename the files and then re-attach the new filename.

perfect - many thanks

You might also want to check out the 'datepart' command

Why don't you just detach the database, copy the files across and then attach in the previous and new locations ?

Thanks for that - I do have the error message mentioned in that email in my SQL Server log file

Have u tried doing a

backup log <databasename> with truncate_only

first ?

another way is just to do a select

left(getdate(),12) - does return it as a varchar though

yes I do... thanks for all your help

I think I have sorted it - I believe the round circle on most of the icons in the execution plan, indicate that the query is running in parallel.

Thanks...

Be careful when using xp_sendMail...

Soon it wont be supported (and it already does not work on one half of a cluster)

See

http://support.microsoft.com/view/tn.asp?kb=312839

for its replacement.

It uses SMTP instead, and...

Thanks very much

thanks for that.

We are running SQL 2000 sp3. Memory must be recovered some how, as when I come in on a Tuesday morning the memory is back to 300Mb + available.

The Optimisation takes around 3 mins, and the integrity check less than 10 seconds.

What I am worried about is the continuing drop in memory. SQL is not recovering

Yes - one of the integrity checks