My bad! That is what I get for typing before going to a meeting. Sorry for misleading you!

David

Use the substring function i.e. substring(columnname, 12, 16) first number indicates starting position and second number indicates stop position. BOL has a really good example there as well.

Hope this...

You should see a 8.00.532 (or something greater with the hot fixes) for the version information that comes out with the select @@version.

I am assuming that this is for SQL...

Nor I on a 7.0 box. Never seen it before so, I would stick with the known MS xp_sendmail.

David

Make sure you can open the path in command line such as a DOS window or from the run line. If there are any spaces in the path it will...

Very cool Steve! Did not know you could do this and the wheels are already turning to see how I can swing this here. Thanks!

David

From SQL Server 2000 System Table Map (download from MS - search on systbl.chm)

"Elapsed time in the execution of the job or step in HHMMSS format."

Hope this helps.

David

I wouldn't do the mail in a trigger but rather a stored procedure and then create a job to run the procedure every 5 minutes or so. That way when...

quote:

---

Can we use the detach/attach method going from SQL7 to SQL2K ? Would the difference in system tables cause a problem...

Depends on the scenario. Some instances I will keep multiple days worth of files on disk other times I will overwrite each night. Some I will copy to other servers...

My post wasn't too clear when it came to the native SQL backups. I prefer them over third party for a myriad of reasons, your problem being one of them....

So when you do a sp_who2 is there any connections open to the database in question? If so, close that connection then do the detach / attach. If that still...

Jeff,

This is a way out there guess but could you try attaching the database again using the single file method, backing up the database and the log and then doing...

And the sp_attach with new paths specified is not working with the new log file either?

David

Let me guess, Veritas restore? If the Restore utility is not native SQL and has the restore job showing completed, you should be able to detach and reattach the database...