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 the past i used the “Execute As Login“. This had problems this time. Continue reading “Impersonation, Execute As & Remote queries”
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
Query execution failed: Msg 208, Level 16, State 1, Server UFOsqlAB, Line 1
Invalid object name ‘CountySalesTax’.
What to do? Continue reading “DB mail Query parameter not working”
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: Continue reading “SQL Server’s Auto Growth settings”