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

If you post the trigger code, we can help you debug it.

I'll second Jack's advice. You might want to set tempdb larger to start with to handle this, set up a trace, check in maintenance operations. If this is during the...

How did you migrate things? Are you sure statistics are up to date?

There are definitely issues with security here. I was thinking more of something you would have that would be private as I am sure it would be misused by companies.

Be sure you document which items are on which drive letters. Easy to make am mistake when you are in the middle and confuse things.

I'd also make a backup just...