Not that you shouldn't be shrinking the log regularly. It should have enough space, without physical growth, to hold all entries between log backups.

http://www.sqlservercentral.com/articles/Administering/sqlmailresources/605/

Apparently it's not working: http://146.176.166.22/~andrew/s2/execsql.pl Suffered: 500 Internal Server Error

Those interactive ones are ripe for SQL Injection attacks.

Maybe it's time for a new picture to replace the RBAR one 🙂

Congrats!

Hey, pick up running as a new vice, that's what I did 🙂

http://amileaday.blogspot.com/

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