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...

Have him open them and save as .dts files. (structured storage). Then open them back up with the new user.

OR reassign to sa and do the same thing.

Sorry, are they a volume set or a striped set? In a volume set, I believe things are written one drive at a time until it is full. However, if...

I'd check out Ken Henderson's book on Extended Stored Procedures.

http://www.amazon.com/exec/obidos/tg/detail/-/0201700468/qid=1081463879/sr=8-2/ref=pd_ka_2/102-0448774-6156119?v=glance&s=books&n=507846

or email him. He's done a few of them.

How are they combined? Windows can do it either way.

Never seen this. Is is SQL 2000, SP3a?