Matt has the right idea. You have to package and sell it, show them that value is being generated and it results in reduced costs.

Of course, at the end of...

Interesting debates and thanks for the comments. It's one of the reasons I do these updates as a break from the db stuff.

If you want to debate the personal liberty...

Very strange. I think you might want to investigate naming the transactions, being able to only rollback the nested one. OR, track that an error has occurred, and issue one...

The space monitoring in tempdb is the same as any other database. You have to track it over time specifically for tempdb to determine what the usage is.

So are you trying to back up 40-50 databases to one server? The rules for the standby server are the same as for production, allowing for some amount of slowness...

Ahhhhhh, don't write triggers that go back on themselves. I might be called by your company and don't want to deal with that.

show us some code, or explain what you...

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.