SQLServerCentral: Scripts

Tables in Merge Replication

Find all tables used in Merge Replication Read more...

By Kishore Saripalli 2013/06/18 | Source: SQLServerCentral.com | Category: replication

Rating: (not yet rated) |

Discuss |

Briefcase | 215 reads

Find the position of all occurrences of an expression within a string

This iTVF returns both the relative and the actual positions of ALL occurrences of a string within a string. Read more...

By Steven Willis 2013/04/12 | Source: SQLServerCentral.com | Category: charindex

Rating:

|

Discuss |

Briefcase | 765 reads

Retrieve SQL Instance Connect Info

This script quickly returns Server Name, Cluster Node, Default Drive Letter for MSDB database, IP address and port Read more...

By Steven Whaley 2013/04/11 | Source: SQLServerCentral.com | Category: sql server |

SQL Scripts Manager Compatible

Rating:

|

Discuss |

Briefcase | 996 reads

Run SQL code on each database

You can use this to run a script/s on multiple databases Read more...

By Ashley McLellan 2013/04/10 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,870 reads

Scripting SQL Agents Jobs using Powershell

The script helps to Scripting SQL Agents Jobs using Powershell automatically by scheduling as a job. Read more...

By Saranya Venugopal 2013/04/09 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 840 reads

Rename Foreign Key Constraints

Rename Foreign Key Constraints in a consistent manner. Ideal for preventing constraint errors during code promotion. Read more...

By Wes Henriksen 2013/04/08 | Source: SQLServerCentral.com | Category: foreign keys (fk)

Rating:

|

Discuss |

Briefcase | 564 reads

Monitor current transactions and get all required information

Check which transactions are running, query text, percent complete , query_plan, wait_type, and how long they have been running etc. - with one command. Read more...

By Uday Reddy 2013/03/25 | Source: SQLServerCentral.com | Category: transaction monitoring

Rating:

|

Discuss |

Briefcase | 1,583 reads

Backups Snapshot

This script gives a server level snapshot of recent backups Read more...

By Nate Hughes 2013/03/26 | Source: SQLServerCentral.com | Category: backups

Rating: (not yet rated) |

Discuss |

Briefcase | 580 reads

Backup all SSAS databases using TSQL

Enumerates and backups all SSAS DB's Read more...

By Theo Ekelmans 2013/03/28 | Source: SQLServerCentral.com | Category: automatic

Rating:

|

Discuss |

Briefcase | 693 reads

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 | 984 reads

Copy Sql Objects

Copy tables, procedures, functions and view from one schema and another schema. Read more...

By Vinay Kumar 2013/03/29 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 749 reads

Copy Table

Copy tables from one schema to another schema. Read more...

By Vinay Kumar 2013/04/03 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 986 reads

Create Table with T-SQL

Generate create table statement using T-SQL. Read more...

By Vinay Kumar 2013/04/01 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 1,180 reads

Get List of tables with no identity columns

Get list of tables with no identity fields Read more...

By Harsha Majety 2013/03/19 | Source: SQLServerCentral.com

Rating:

|

Discuss |

Briefcase | 776 reads

Report Progress with Variables

Script task in my package's OnProgress event handler reports all variable values at each step. Read more...

By Joseph Morgan 2013/03/20 | Source: SQLServerCentral.com | Category: integration services (ssis)

Rating:

|

Discuss |

Briefcase | 697 reads

DB File Overview

This script will give you a overview of the current database files. Read more...

By Sean Huff 2013/03/21 | Source: SQLServerCentral.com | Category: database file

Rating:

|

Discuss |

Briefcase | 927 reads

Powershell - Document your environment

This script is an improvement from my original script entitled "Powershell - Query SQL Servers Operating system details". Read more...

By Justin Manning 2013/03/22 | Source: SQLServerCentral.com | Category: powershell

Rating:

|

Discuss |

Briefcase | 1,348 reads

Script to get max dates on tables that contain a certain column.

This script will allow you to get maximum date associated with tables that contain a certain column. Read more...

By Kishore Tallapragada 2013/03/18 | Source: SQLServerCentral.com | Category: aggregates

Rating:

|

Discuss |

Briefcase | 935 reads

Convert XML to String with formatting

Converts xml value into multi line string with indents Read more...

By Andrei Solntsev 2013/03/15 | Source: SQLServerCentral.com | Category: xml

Rating:

|

Discuss |

Briefcase | 1,185 reads

List all tables and their respective information.

List all tables in a SQL Server database with the details of them. Read more...

By Fernando Casas Osorio 2013/03/14 | Source: SQLServerCentral.com | Category: tables

Rating:

|

Discuss |

Briefcase | 2,151 reads