Don't write inside the code. Write the specific question at the end, or beginning. It's easier to read then I'm not sure exactly what you want.

Do you need an aggregation...

It's on the list, but it's a low priority. You can get a feed from threads/forums and scan that.

We have an item logged that would allow you to choose from...

Every time I do Yoda it comes out Scooby-Doo.

You are doing the equivalent of an upgrade here, side by side.

Moving databases: http://www.sqlservercentral.com/articles/Administration/movingyouruserswiththeirdatabases/2124/

For upgrades, this will help: http://www.sqlservercentral.com/articles/Upgrade/65872/

The big things are moving security, scripting out and moving...

I'm not sure if it's been corrected or not, but you cannot necessarily depend on sys.depends. Just writing that sounds silly, and it's frustrated many of us for years.

Red Gate...

I'm not sure this isn't possible. While the brain works great, why do we keep photos around? Why do we write things down and save them? We can't remember things,...

Are you updating all rows?

The short answer is you probably do not need a cursor, but you might need a subquery to calculate the totals.

I would try to write...

Please post a question somewhere that explains what you are asking people.

Also, you need to try and solve this. From the code I'm not sure if you have or if...

I'm not familiar enough with that is possible in a GPO. Can you use WMI scripts? Or could you set some type of environmental variable for the user?

What application are...

Well if your database server is running, that's not the issue. However you can have multiple services or users, or even applications using that account. It's possible that someone configured...

I take Lynn's point of view. I used to write all my joins as you did, Chris and that's how I learned. However in the 2000/2001 timeframe when Microsoft started...

searching by email would expose emails, which could be bad.

Adding a link to their PM form would be better. I'll add that to the list.

If the log is growing on every load, why shrink it? Why not leave it large? Doesn't make sense. If the database is growing, you are not properly watching size....

Most people I know have SSIS running on the same server as the database unless they have a large load of packages running. It seems to be OK. Separate service...

If you want to reduce the logins you need, you can remove logins from within SQL Server, but as you find out what's being used, you'll be breaking things. Make...