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


 

Content with tag script Rss

   Items 1 to 12 of 12   
 

Compare 2 datasets and output delta in one TSQL statement

There are many ways 2 compare datasets to find differences, this is one of them.  Read more...
By Theo Ekelmans 2011/11/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |  Briefcase | 1,561 reads

Find Job Names that Contain SSIS Packages and their Location

This will give you a list of jobs that contain SSIS Packages should you have a project in which you may need to review changes to Packages.  Read more...
By Shirley Noa 2011/08/23 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |  Briefcase | 658 reads

Verify a database backup using T-SQL

A script to verify a database backup using T-SQL code  Read more...
By Nakul Vachhrajani 2011/07/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |  Briefcase | 1,224 reads

Script Logins

Rewritten sp_help_revlogin. Why? Because sp_help_revlogin is annoying.  Read more...
By Gordon Klundt 2011/04/04 | Source: SQLServerCentral.com | Category: sp_help_revlogin
Rating: |  Discuss |  Briefcase | 2,066 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 0001/01/01 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 3,818 reads

Get daylight savings time

After scouring the site, and googling until my fingers bled, I finally put together a function that will return the dates when daylight savings time began/ended since at least 1990.  Read more...
By Langston Montgomery 2010/08/26 | Source: SQLServerCentral.com | Category: function
Rating: |  Discuss |  Briefcase | 1,274 reads

Parsing / breaking character separated values in a table in one query

At times, we have situation to parse the character separated string in the table column.   Read more...
By Atif-ullah Sheikh 2010/07/14 | Source: SQLServerCentral.com | Category: script
Rating: |  Discuss |  Briefcase | 1,943 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 0001/01/01 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |  Briefcase | 3,818 reads

Automatic Generation of Insert, Update and Delete stored procedures

This script automatically generates stored procedures for insert, update and delete operations on the given table  Read more...
By Samardeep Khera 2009/08/12 | Source: SQLServerCentral.com | Category: stored procedures
Rating: |  Discuss |  Briefcase | 1,781 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |  Briefcase | 1,337 reads

Database Growth History

This script uses the backup tables to get info on the growth of your database files.  Read more...
By Nicholas Williams 2009/02/12 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |  Briefcase | 2,678 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |  Briefcase | 9,924 reads
   Items 1 to 12 of 12   
 
Tags
databases (3)    
t-sql (3)    
administration (2)    
logins (2)    
sql server 2005 (2)    
automatic (1)    
backup/restore (1)    
compare data (1)    
compare dataset (1)    
daylight (1)    
dba (1)    
delta (1)    
diagnostic (1)    
dynamic (1)    
function (1)    
grant (1)    
growth (1)    
integration services (ssis) (1)    
permissions (1)    
role (1)    
run (1)    
savings (1)    
scripting (1)    
security (1)    
size (1)    
sp_help_revlogin (1)    
sp_helpdb (1)    
sp_msforeachdb (1)    
sql server 7 (1)    
stored procedures (1)    
time (1)    
user (1)    
 
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.