Be sure that you manage the backup files as well. Perhaps delete the ones older than the last 2 after the backup completes.

Remove rights from the database (permanent)

Set to single user mode and grab a connection

You might need the 2000 runtime if you run this as a DTS package as well. I haven't worked with this in 2008, so I'm not sure, but 2005 had...

Putting it in the ORDER BY will move the duplicates, not eliminate them. It needs to be in the GROUP BY, and you want to SUBSTRING back to the string...

Oh, and shouldn't is the case, but can't should be in there. Modifying the contract, especially once the workers don't have any leverage, is both ethically wrong, and should be...

Nothing is off topic, and as long as someone responds, might as well keep it going here.

I agree with Jack, too much loosey-goosey activity with retirement funds. I tend to...

You performed a striped backup. The backup of master went to two files, not one and you are only specifying one file.

Unless you find the other file, you cannot restore.

Have you checked permissions? the server might not have the rights to get to the Access file.

The thing you need to determine is why your log files are getting so big? Perhaps they need to be big, perhaps you do not have a proper schedule for...

It may or may not help. You have to examine execution plans and look to tune each part of it. There's no way to answer a general question like this....

What do you mean "trace"? Do you mean debug? there is no debugger in 2005. You can put the values or result sets into a table somewhere or you can...

Views cannot be created from stored procedures. They are created from tables.

http://msdn.microsoft.com/en-us/library/ms189918(SQL.90).aspx

http://msdn.microsoft.com/en-us/library/ms187440(SQL.90).aspx

Andy has the right idea, but why can you not just grant db_owner to a user as a role. This is the same as dbo.

They certainly need to evolve. They've been mismanaged for years, counting on cheap oil, big, expensive cars that they want people to buy every few years, a bad model. Not...