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

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

<< Newer    Items 61 to 80 of 2999    Older >>
 

Format decimal value to fraction using a tally table.

We use a tally table to find the appropriate denominator for a given decimal part of a number.   Read more...
By Adrian Facio 2014/04/29 | Source: SQLServerCentral.com | Category: format
Rating: |  Discuss |   Briefcase | 860 reads

backup, differental and transactions

Backup all databases for an instance (complete, Differential or log of transactions)   Read more...
Rating: (not yet rated) |  Discuss |   Briefcase | 875 reads

Count all records the tables

Count all the records from the tables that exist in a database  Read more...
Rating: |  Discuss |   Briefcase | 1,580 reads

Script to Generate Table to Stored Procedure Cross References

Lists Tables and Store Procedure references. Runs a bit slow but appears to be accurate.  Read more...
By Marcus Dallasandro 2014/04/25 | Source: SQLServerCentral.com | Category: cross reference
Rating: |  Discuss |   Briefcase | 1,529 reads

Restore script genrator for moving dbs

usefull script for moving databases from one server to another  Read more...
By Anoop 2014/04/23 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 756 reads

Get the defination of all table type in database

THis script will generate the Drop and create script for all user define table type  Read more...
By Mitesh Oswal 2014/04/18 | Source: SQLServerCentral.com | Category: drop table
Rating: |  Discuss |   Briefcase | 1,051 reads

Dynamic table unpivot

Generate and execute dynamically select statement for unpivot table  Read more...
By kast218 2014/04/17 | Source: SQLServerCentral.com | Category: unpivot
Rating: |  Discuss |   Briefcase | 896 reads

Search objects in Database

Use this script to search objects in a Database. Also used to check a tables column types and details when no model is accessible. Replace <DATABASENAME> for database name.  Read more...
By bpimenta 2014/04/16 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,232 reads

Script out passwords

This script will let you get the passwords for all SQL Server principals.  Read more...
By Steve Jones 2014/04/01 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 2,405 reads

Generate script to rebuild indexes in a database

Generate script for reconstgruir ena database indexes  Read more...
By Andrés Michaca 2014/04/08 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,325 reads

Script move of DB files from one location to another

Generates Scripts to move DB files from one location to another SQL and powershell scripts  Read more...
By Greg Ryan 2014/04/15 | Source: SQLServerCentral.com | Category: sql server 2008
Rating: |  Discuss |   Briefcase | 1,572 reads

Find dependencies between field and sp/function

This script shows the stored procedures and functions affected by field name change in a table.  Read more...
By Raymond Xie 2014/04/09 | Source: SQLServerCentral.com | Category: dependencies
Rating: (not yet rated) |  Discuss |   Briefcase | 807 reads

Insert Generator - Stored Procedure

Stored procedure to generate an insert script for a table.  Read more...
By Nick Greene 2014/04/14 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,585 reads

Quick snapshot

Script enables a quick creation of snapshots for databases  Read more...
By Igor Micev 2014/04/04 | Source: SQLServerCentral.com | Category: snapshot
Rating: |  Discuss |   Briefcase | 917 reads

Identify Column Data Types

Use the following queries to list a result set of all column data types to any specified database. In the 2nd query, you will see a result set based on all text based data type columns in your database (XML data type not included). Modify accordingly.  Read more...
By Rich Yarger 2014/04/07 | Source: SQLServerCentral.com | Category: data types
Rating: |  Discuss |   Briefcase | 1,072 reads

Alternative for Policy Management in SQL Server

In versions prior to SQL 2008, there is no policy Management. However, we can enforce policies. The script gives an example to enforce naming standards on a stored procedure.  Read more...
By Karthik Jadav 2014/03/28 | Source: SQLServerCentral.com | Category: policy management
Rating: |  Discuss |   Briefcase | 505 reads

IndexInformation

Retrieve Index Information for all tables.  Read more...
By m mcdonald 2014/04/03 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 970 reads

Get the all user and their server role

The script give you the list of all users and their respective Server roles  Read more...
By Mitesh Oswal 2014/04/02 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 1,090 reads

Get the Column level difference for 2 database

The query will help to get the column level difference for 2 database(Like Prod and Dev database). This help us to verify what are the column changes has been done in dev environment after Prod deployment.   Read more...
By Mitesh Oswal 2014/04/10 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 916 reads

Defragmentation and update statistics for all online databases

Defragment and Update Statistics.   Read more...
By Vimal Lohani 2014/03/27 | Source: SQLServerCentral.com | Category: defragmentation.
Rating: |  Discuss |   Briefcase | 1,291 reads
<< Newer    Items 61 to 80 of 2999    Older >>