A simple example of SQL server admin tools.

using System;
using System.Data;
using System.Data.SqlClient;
using DAL.Interface;

namespace DAL
{
    public class ClsSQLHelper : IFacade
    {
        SqlConnection ObjSqlConnection;
        SqlCommand ObjSqlCommand;
        SqlDataAdapter ObjSqlDataAdapter;
        DataSet ObjDataSet;

        #region "Public functions"

        public DataSet GetRecordSet(string strConnectionString
                                  , string strSQL)
        {

            ObjSqlConnection = new SqlConnection(strConnectionString.Trim());

            ObjDataSet = new DataSet();

            try
            {
                ObjSqlCommand = new SqlCommand(strSQL, ObjSqlConnection);
                ObjSqlDataAdapter = new SqlDataAdapter();
                ObjSqlDataAdapter.SelectCommand = ObjSqlCommand;
                ObjSqlDataAdapter.Fill(ObjDataSet);

            }
            catch (Exception ex)
            {
                //MessageBox.Show ( ex.Message);  
            }
            finally
            {
                ObjSqlDataAdapter = null;
                ObjSqlCommand = null;
                ObjSqlConnection = null;
                strSQL = null;
            }
            return ObjDataSet;
        }

        public string GetScript(string strConnectionString
                              , string strObject
                              , int ObjType)
        {
            string strScript = null;
            int intCounter = 0;
            if (ObjType != 0)
            {
                ObjSqlConnection = new SqlConnection(strConnectionString.Trim());

                try
                {
                    ObjDataSet = new DataSet();
                    ObjSqlCommand = new SqlCommand("exec sp_helptext [" + strObject + "]", ObjSqlConnection);
                    ObjSqlDataAdapter = new SqlDataAdapter();
                    ObjSqlDataAdapter.SelectCommand = ObjSqlCommand;
                    ObjSqlDataAdapter.Fill(ObjDataSet);

                    foreach (DataRow ObjDataRow in ObjDataSet.Tables[0].Rows)
                    {
                        strScript += Convert.ToString(ObjDataSet.Tables[0].Rows[intCounter][0]);
                        intCounter++;
                    }


                }
                catch (Exception ex)
                {
                    strScript = ex.Message.ToString();
                }
                finally
                {
                    ObjSqlDataAdapter = null;
                    ObjSqlCommand = null;
                    ObjSqlConnection = null;
                }
            }

            return strScript;

        }

        #endregion

        public bool ExamineConnection(string strConnectionString)
        {
            bool Result = false;

            try
            {

                ObjSqlConnection = new SqlConnection(strConnectionString.Trim());
                ObjSqlConnection.Open();

                if (ObjSqlConnection.State == ConnectionState.Open)
                {
                    ObjSqlConnection.Close();
                    Result = true;
                }
            }
            catch
            {
                Result = false;
            }


            return Result;

        }


        public string ExecuteScalar(string strConnectionSring, string strScript)
        {
            SqlConnection ObjSqlConnection = null;
            SqlCommand ObjSqlCommand = null;
            ObjSqlConnection = new SqlConnection(strConnectionSring);
            string strMessage = null;

            try
            {
                ObjSqlCommand = new SqlCommand(strScript, ObjSqlConnection);
                ObjSqlConnection.Open();
                ObjSqlCommand.ExecuteScalar();
                strMessage = "Succes";
            }
            catch (Exception ex)
            {

                strMessage = ex.Message.ToString();
            }
            finally
            {
                ObjSqlConnection.Close();
                ObjSqlCommand = null;
                ObjSqlConnection = null;
                strScript = null;

            }
            return strMessage;
        }

    }
}