Monthly Archives: December 2011

Impersonation, Execute As & Remote queries

This week i had a developer creating a process (job) where a database user was to have authority to query remote machines.  To debug the process the developer needed to assume the role of the user running in the application.  In … Continue reading

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment

DB mail Query parameter not working

On one of my servers the query parameter just wasn’t working.  I kept getting this error: Msg 22050, Level 16, State 1, Line 0 Error formatting query, probably invalid parameters Msg 14661, Level 16, State 1, Procedure sp_send_dbmail, Line 504 … Continue reading

Posted in SQL 2005, SQL 2008 | 1 Comment

SQL Server’s Auto Growth settings

Over the last week I’ve been finding an unusual number of log file growths.  I did some investigation and found a good script to help me track what was the current status for file growths.  It is as follows:

Posted in SQL 2005, SQL 2008, SQL Administration | Leave a comment