Not really. Perhaps if you give more info about the proc or post some code, we will have other ideas.

Do you know what this proc was doing? Or what this was doing in Service Broker? There is likely a triggering event (message, proc, etc.) that is causing this as...

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