The biggest value I find in the use of PBM is in conjunction with Central Management Server.  Also the EPM Framework is a fantastic tool for reporting on Policy compliance.

http://us11.campaign-archive2.com/?u=bc83b66e68223227792d2bebf&id=e88918ce06

Hey Arun, Thanks for putting this out there! I set this up in my environment but when I select a server from the drop down the report shows the...

Please check out

http://www.sqlskills.com/BLOGS/PAUL/post/Importance-of-proper-transaction-log-size-management.aspx">

http://www.sqlskills.com/BLOGS/PAUL/post/Importance-of-proper-transaction-log-size-management.aspx

This should give you a start at understanding the transaction log and how to manage it. The folks that blog on SQL SKILLS are experts...

Rodney,

Thanks for sharing your thoughts and experiences. I am facing that "fork in the road" now. My preference is to specialize in SQL Server administration and performance tuning...

I have used the following for a number of years. I've used it on 2005, 2008 and 2008R2. Ther may be a simpler solution but this one works...

Hey Linking90,

You may also want to consider a design change to your table. You should change the 3 columns other than User_ID to the bit data type if 1...

This is a good resource for investigating 18456 errors

http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456/

May not be the only method but I would look at setting up an insert, update trigger on each of the subtype tables. Maybe a redesign of table structure to...