Correct, because it can see every event in SQL Server, only a sysadmin can use this.

I haven't seen this, but one of my tasks over the next few weeks is to do some testing on full text search. Hopefully I'll learn a few things.

Great catch. I was suspecting some type of process, backups, anti virus, defrag, etc. holding part of that file open.

Brian Kelley has a great article today on Anti-virus and SQL...

you can, but the backup utility is not very tolerant of network delays. I'd backup locally and then copy the file over.

select count(*) where yada, yada

then set rowcount = count(*) - 1

delete where yada, yada

You can also have the SMTP service running on the local host and bounce off there to your notes server.

Can you give more direction? Brian Kelley has some good articles on this site.

script the objects out from the source, search/replace, oldwoner. with newowner.

vote for backup restore of all dbs. Move user dbs first, then system dbs.

if there truly is a generic account, you need to use business logic to stamp "who" the user is.

BK works for a large company that hosts apps for other companies. Not really an ISP, more of an ASP. I'll let him chime in there.

As for crippling the box,...

Most are on .851 here. A few .859, a few at .842

DTS has been flaky to me. I prefer backup/restore, no downtime, works, etc. detach/attach works, but requires downtime.

Can you reboot? I've seent he cursor message, but can't remember what it was. It was awhile ago and I think it cleared itself. As far as diskkeeper, do you...

I use David's technique, but pipe the output to a single file. I then search for any error's that I've "echo"'d of there was an error.