Are all nodes and the client at the same patch level?

Why would you execute dbcc freeproccache in a maintenance plan? It defeats the purpose of caching, which speeds up SQL Server.

It's not that we don't want to answer, but this could be a book's worth of writing. We're asking what the goals of the audit are?

Most auditing is to determine...

Jeff, hopefully you can stick with those. Maybe point a few developers our way and they'll learn a few things to make life easier for you. And lessen the need...

sadaiyan,

People here volunteer their time and skill, and we are happy to try and help, but we expect you to try and do some work. We expect you to make...

Lynn,

Not sure if this applies, but check pathing in your setup files. We had an issue with Sp3 and multiple instances in SQL 2000 where we'd used different paths for...

I agree with Taylor. It depends on what you're doing.

Is this a technical audit? looking for adherence to best practices? Corporate standards? Something else?

Jeffrey has what I'd have written if I were a little quicker. Having different versions on the client and server can cause lots of issues.

If you edit on the server...

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