Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts by Gokhan Varol

SQLServerCentral.com profile

   Items 1 to 7 of 7   
 

System Proc sp_SysMon to monitor sql server health

I created as a system proc but it can be executed individually. It will print some system health counters.  Read more...
By Gokhan Varol 2012/01/31 | Source: SQLServerCentral.com | Category: system health
Rating: |  Discuss |   Briefcase | 2,168 reads

System proc sp_SysInfo to get

Useful for system information. Does not have to be a system procedure, it can be executed seperately.  Read more...
By Gokhan Varol 2012/02/21 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,359 reads

Link Session info to CDC or in other words Auditing with CDC

CDC provides before and after images of modified data. If information about the session required that modified the cdc there is a workaround.  Read more...
By Gokhan Varol 2011/06/20 | Source: SQLServerCentral.com | Category: cdc
Rating: |  Discuss |   Briefcase | 615 reads

Get an email notification of the failed job step detail

This trigger will notify the existing email operator of the job with detailed job step information.  Read more...
By Gokhan Varol 2011/02/17 | Source: SQLServerCentral.com | Category: sql agent
Rating: |  Discuss |   Briefcase | 2,769 reads

Retrieve Database Object permission scripts and Role members scripts

I often need to synchronize the user permission between databases. I wrote this simple query to script the sql statement to per item.   Read more...
By Gokhan Varol 2011/02/03 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 2,595 reads

Stored procedure to script tables, has many options

I needed a fast way of creating identical copies of multiple tables. The criteria was to make identical copies of tables for a specific schema. Well there it started.  Read more...
By Gokhan Varol 2011/02/01 | Source: SQLServerCentral.com | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,238 reads

CLR Aggregate to Concatenate delimited strings

One must be carefull unless the input is sorted by the value passed to the function and there is no paralelism there is no guarantee that the resulting value will be sorted.  Read more...
By Gokhan Varol 2011/01/27 | Source: SQLServerCentral.com | Category: string
Rating: (not yet rated) |  Discuss |   Briefcase | 782 reads
   Items 1 to 7 of 7