SQLServerCentral - Scripts by Venugopal Saride

Backup history details EMAIL (past 24 hours) in HTML format

Get backup status email daily to your inbox in HTML format. Read more...

By Venugopal Saride 2013/03/27 | Source: SQLServerCentral.com | Category: backup

Rating:

|

Discuss |

Briefcase | 908 reads

Quick check SQL connection and process details with current SQL text

This script will be useful to quickly check incase of any blocking or log wait occurs Read more...

By Venugopal Saride 2011/12/30 | Source: SQLServerCentral.com | Category: connections

Rating:

|

Discuss |

Briefcase | 1,321 reads

Generate script to change column length of string datatypes in a DB

This script can be used to generate alter column length of any string data type column(s) in a database. Read more...

By Venugopal Saride 2011/12/27 | Source: SQLServerCentral.com | Category: char

Rating:

|

Discuss |

Briefcase | 741 reads

Generate alter datatype script for entire database

ntext, text, and image (Transact-SQL). This script will alter the data type from image to varbinary(max) which is very much required as the data type is out of support. Read more...

By Venugopal Saride 2011/11/28 | Source: SQLServerCentral.com | Category: ntext

Rating:

|

Discuss |

Briefcase | 776 reads