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 41 to 60 of 3184    Older >>
 

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location  Read more...
By Vimal Lohani 2015/05/27 | Source: SQLServerCentral.com | Category: detach database
Rating: |  Discuss |   Briefcase | 838 reads

Query to find size of each disk file in a location

Query to find size of each file in a location  Read more...
By S M 2015/05/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 851 reads

Keyboard shortcut to select top 1000

select top * from table by highlighting the fully qualified, including database, table, using a keyboard shortcut.   Read more...
By Timothy Harms 2015/05/22 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,675 reads

Dynamic sql for convert table to flat file using bcp

I comment CATCH section for removing dependence to log procedures. Github link: https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_bcpTableUnload.sql  Read more...
By Konstantin Taranov 2015/05/21 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,141 reads

Wrapper

This can be used all codes deployed to an environment.  Read more...
By Timothy Harms 2015/05/06 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 155 reads

Script to document SQL Instance Details

SQL Script to document instance details  Read more...
Rating: |  Discuss |   Briefcase | 1,870 reads

Delete all files from a folder using xp_cmdshell

Delete all files from a folder using xp_cmdshell  Read more...
Rating: |  Discuss |   Briefcase | 742 reads

Dynamic Table Name on Select Into

Based upon todays date as suffix and chosen string as prefix, select data from predefined table into dynamically named new table. Script is properly error handled with most common errors  Read more...
By Jo Dacey 2015/05/14 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 1,467 reads

List CLR Objects in Database

Script lists all the clr objects in the database.  Read more...
By Harsha Majety 2015/05/15 | Source: SQLServerCentral.com | Category: sqlclr
Rating: (not yet rated) |  Discuss |   Briefcase | 701 reads

Taking Backup Of All DBs

Wrote the script to take compressed backup with combining many other features.  Read more...
By S M 2015/05/18 | Source: SQLServerCentral.com | Category: sql backup script
Rating: |  Discuss |   Briefcase | 791 reads

Query to find the Job Output file location at each job step.

Query to find the Job Output file location at each job step. This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.  Read more...
Rating: |  Discuss |   Briefcase | 679 reads

Extract default & Named Instance from @@servername

Extract default & Named Instance from @@servername. Print all characters before and after \ to find default and named instance name.  Read more...
Rating: |  Discuss |   Briefcase | 833 reads

Percentage of NULL Column Rows

NULL Column Rows vs Total Rows  Read more...
By Ram Ramamoorthy 2015/04/24 | Source: SQLServerCentral.com
Rating: |  Discuss |   Briefcase | 1,043 reads

Powershell command to extract SQL aliases configured

SQL aliases are stored in system registry and can be viewed via configuration manager. The powershell command can be used to extract the as same and save in a text directly  Read more...
By Kruti Mehta 2015/04/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 584 reads

A script to answer: Should I use SPARSE?

A brief introduction to the sparse option and script to help decide when to use it  Read more...
By Jeff Reinhard 2015/04/22 | Source: SQLServerCentral.com | Category: sparse
Rating: |  Discuss |   Briefcase | 1,152 reads

Check existence of a database

Check Status of a database. It will loop through all databases and will print message if the db is present.  Read more...
Rating: |  Discuss |   Briefcase | 1,078 reads

READ Data from default Trace

READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.  Read more...
Rating: |  Discuss |   Briefcase | 850 reads

Split String Function

This In-line Table Valued Function returns a table with individual records parsed from a string.  Read more...
By Chris Kutsch 2015/04/16 | Source: SQLServerCentral.com | Category: substring
Rating: |  Discuss |   Briefcase | 2,050 reads

Use Of Cursor Vs Simple While Loop

You can eliminate CURSOR many a places using WHILE Loop.  Read more...
Rating: |  Discuss |   Briefcase | 2,641 reads

Generate password using PowerShell

If you want to generate temporary passwords, can use my script.  Read more...
Rating: |  Discuss |   Briefcase | 840 reads
<< Newer    Items 41 to 60 of 3184    Older >>