SQL Server Service Check Utility

I was ask to see if Full Text Search was installed on a development server one day. So after some manual work to collect this information I thought that maybe there could be a better way. So I wrote this script to help out.

Here is how this script could help you:

• Determine the status of SQL server service(s) - running or not
• Determine if the service is installed or not

I have executed it on the following servers

32 bit and 64 bit
SQL 2005 with SP3 - Stand alone and on multiple instances
SQL 2008 with SP1 and SP2 - Stand alone and on multiple instances
SQL 2008 R2 latest patches
SQL 2012 with latest patches

Hope you find it useful.

Thanks,
Rudy

Download script here:  https://docs.google.com/file/d/0B07PMQYOhF2DMEliT0pKSmozSDA/edit?usp=sharing

T-SQL generator for sp_configure

The purpose of this script is to create a T-SQL output that can be execute on SQL Server (2005 and higher) to recofigure the SQL server as compared to the settings on which you have executed this code from. This script is great for rebuilding a SQL server from bare metal, UAT and/or development environments so that it matches your original environment.

Thanks,

Rudy

Download script here: https://docs.google.com/file/d/0B07PMQYOhF2DbU40MXRaUGVmRGM/edit?usp=sharing