you should be using roles exclusively, not adding people to dbo, db_owner, or giving them permission.

Create user defined roles, assign people to those roles and things are much simpler.

Change the getdate to dateadd(yyy, -1, getdate()

Are there anything different about the transactions? If you take one that works, add another nested transaction, and then try it, does it still abort?

Seems strange. Can you provide some...

you can script out the objects (tables, views, etc.) and then run this on the new server. I think permissions is an option when scripting.

You do have to ask questions and get clarification, but I agree with Grant. If it happens too much, then they'll likely look elsewhere. Being able to communicate with the...

Standard here at SSC. Only one server, no need for Ent features.

Employers do adjust ranges over time, but not that often. From some large companies I've worked for, they review salaries every 4-5 years, often buying survey results from companies.

So fill...

Use SQLCMD as mentioned. BCP doesn't run stored procedures.

yes, it's no different than you typing multiple batches into QA. As long as you're on the same connection, the transactions work.

Great job Phil!

I've got something similar in the works, or maybe I've published one. Can't remember now, but pulling the plug is tough.

What's crazy is that if you can't salvage...

You could write a VBS script to do this using the object model. Don't have one handy, but search for one. Might be something at sqldts.com

If you're really concerned, give it a long, one-time password that you don't write down. Randomly bang on 20 keys to get it.

Don't rename it or delete it. You'll get...

I'd say Ben-Gan's Inside SQL is a must for 2005.

The others are good, and any of the admin books will work.

correct, if it's the first proc, you can ignore exec, but as a matter of practice: Use it.

This will work as well:

use master

go

sp_detach_db 'konfig'

go

sp_detach_db 'ndfi'

But do this:

use master

go

exec sp_detach_db...

Tend to agree with Michael. Monitor and observe the system. AWE isn't needed for 64-bit and my guess is SQL will keep building cache and run to 30GB unless you...