Scripts by Gokhan Varol

I created as a system proc but it can be executed individually. It will print some system health counters.  Read more...

Useful for system information. Does not have to be a system procedure, it can be executed seperately.  Read more...

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...

This trigger will notify the existing email operator of the job with detailed job step information.  Read more...

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...

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...

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...