Monthly Archives: March 2011

Variable history sizes in SQL Agent Jobs

If you have lots of jobs then you will need to adjust the max history sizes in the SQL Server Agent but what if you have one or two jobs that run every few minutes which hog all the log … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , , , | Leave a comment

How to get configuration and properties for your SQL server e.g version, type, licence type, collation

Use the SERVERPROPERTY function with a parameter. There are 30 (ish) of them so the follow gets them all or just cut and past the one you need. Run this in any DB SET NOCOUNT ON SELECT ‘BuildClrVersion’ as PropertyName … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , | Leave a comment