I build as a backup/restore from production and script it that way so I can repeat the process.

Be sure that sensitive information is scrambled or changed as part of your...

My biggest issue is that the resources will be in contention. In dev it's easy for someone to test a new query and eat up all the CPU or an...

You can also script in stages, tables, then views, then procs, then logins, etc.

There are a few companies that do this, but it's $$. Protegrity was one.

no built in roles. You need to be the owner if you're not a sysadmin, I believe.

Honestly we tend to leave it on the OS drive (With SQL files) since our boxes are usually dedicated to SQL Server.

In general we do:

OS Drive: SQL OS + client tools (Raid 1)

Z: drive - Data + backups (Raid 5)

Y: drive - Log drives (RAID 1)

If we have a tempdb load, then...

I believe that Yukon is included, but SA is for a time period. Yukon is probably a year away, so if youthink you might want it and SA covers it,...

I'll add this to the list. That's a good one!

We're still looking at this. Requires some coding to get on one page.

We'll get to it. Kind of busy right now, but we should be able to add the last post...

I'm not sure one if better than the other. I like osql or isql since scripting it pretty simple to use and I can always launch outside of another tool...

Are you asking which type of tool or which type of client language? Your questions point to both. The tool wouldn't have a runtime. Unless you are looking for something...

What does the proc do? How is the web server connecting?

I'd ask you "how would you find out?" and see what you said. Personally I think honesty, including "I don't know" is the best policy. I've been doing this for...

maybe change to specifically mention "inner join" in the query?

Not sure, this is a strange one.