|SQL Server Articles|
SRS report writing for dummies
by Sherry Kissinger - 12/30/2009
My co workers will likely laugh (under their breath) at me, but I felt I needed this step-by-step for myself, so I can reference it in the future, the next time I need to create a prompted SRS report, or one that links to another SRS report.
How to check if Service Principle Name (SPN) is enabled
by Shaun Cassells - 12/29/2009
While troubleshooting recently, I came across an instance where I needed to verify a SPN was still set correctly for a remote SQL instance.
by Brian Mason - 11/2/2009
If you used mppublish.vbs for SMS 2003, you're going to need something else for SCCM; mppublish.sql
How to create a batch file using SQL
by Garth Jones - 9/28/2009
The output of this query can be used to create a batch file to execute service control to fix BITS service.
Advanced reporting against Add/Remove Programs (ARP), filtering and appending data
by Chris Nackers - 9/25/2009
I’m not a SQL expert by any means, so if you see something that isn’t quite right, well I already said I'm not a SQL expert :) This process involves custom tables and modifying your SQL database, proceed at your own risk. Don’t say I didn’t warn you...
Visit the SQL Server Support Forum
SQL Server Downloads