Like I said, it depends. They don't need any of those roles necessarily. If I want someone to run imports via DTS from Excel, I can add him as a...

depends on how they do it. Could get by with insert and select (maybe update). Sys admin isn't something I'd give out.

It can take awhile if it's lots of GB of space. Glad it's fixed for you.

replication may be the answer.

I don't think so, but you may email or check Ken Henderson's book.

Apologies gentleman.

I tested -na and forgot to change my text.

rename in windows

sp_dropserver <old servername)

sp_addserver <new windows name>, local

You want to use roles, as mentioned above. Either those mentioned above or make your own.

Litespeed will do the job for you, encrypts the file. You still have the password management problem. Don't take this too lightly, if you do, it could be your job.

You can write a script that runs continuously, basically something to read sp_who2 and watch the last batch and the CPU and/or diskio values. If they are growing beyond some...

If you didn't detach, reattach then I'm not surprised. the entry in the table is static, probably (my guess) changed only when attach detach. The parameter on startup is an...

Could have v7.0 Enterprise.

SQL Standard or Enterprise? Not that it should matter, just wondering.

I haven't seen this error, but this is one of those areas that is probably worth a call to PSS...

I don't think they are shipping B1 anymore, not sure if it's in MSDN.

The last rumor I heard was May/June for B2. There was a summit this week for MVPs,...

DMO could script the proc and then you'd execute this on the target server. Or select the source code from syscomments and execute on the target server. Be wary of...