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…
Year: 2011
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…
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:
Count your lines of code
How much code has gotten into production? How many different objects have this code? Isn’t that also a measure of just how ‘big’ your responsibility is? If you have a massive application with thousands of stored procs and functions…guess who…
Finding SQL Server’s Full-Text indexes
I have a lot of servers. Full-Text operations sort of slipped up on me. Then, a developer asked for assistance…in particular who else was using full-text that he could ask for guidance? I couldn’t tell him. That got me started…
SSRS Report History – keep more than 60 days
Many may know that the following query can get information about the history of reports being called.
New 2008 r2 Install SSIS “Failed to retrieve data for this request.”
You might also get: “The SQL Server instance specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer.” To resolve this…
Drop user who owns a Schema
How often are you deleting users and you get the warning that this user owns a schema and the schema is going to get dropped also…and are you sure you want to do this? … And no, you’re not really…
Character selection by location in a string
Suppose you had a 4 character field (prefx), and you wanted to find all those records where the 2nd and 4th characters were numeric, with the other two being alphabetic. Here’s a neat, simple solution: select * from TableName where prefx…
Monitoring Log File Growth in SQL Server
We recently had to ‘migrate’ a vendor supplied database with a vendor-supplied process. We were warned that the database log file could grow some 10,000% !!!! Not finding that particularly palatable, I upped the transaction log backup to every minute. I…