Domagoj,

Best of luck with that and hope things get better in 2009.

At least he tries. I think he's slightly in over his/her head with this stuff, but he's plugging along.

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