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 20 of 20   
 

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...
Rating: |  Discuss |   Briefcase | 1,540 reads

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.  Read more...
By Premjit Das 2013/12/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,435 reads

Permission scripting over all databases

Scripts permissions/roles for db user across all databases.  Read more...
By W Louw 2013/10/01 | Source: SQLServerCentral.com | Category: permissions
Rating: |  Discuss |   Briefcase | 12,476 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,118 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 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 5,617 reads

Truncate or switch range of a partitioned table

Script to duplicate structure, switch or truncate choosen partitions of a table  Read more...
By Federico Iori 2013/06/03 | Source: SQLServerCentral.com | Category: truncate
Rating: |  Discuss |   Briefcase | 1,118 reads

Run SQL Hosted VBS Script from SQL

This routine allows you to run VBScript directly from SQL (i.e. without having to create a file in advance) by pushing the script to a temp file.  Read more...
By John Bevan 2012/09/20 | Source: SQLServerCentral.com | Category: script
Rating: (not yet rated) |  Discuss |   Briefcase | 905 reads

Scripting SQL jobs using PowerShell

Using powershell to create different sql scripts in different files.  Read more...
By Premjit Das 2013/12/13 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,435 reads

Automated Script-generation with Powershell and SMO

Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.  Read more...
By Additional Articles 2012/02/28 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,584 reads

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 | 2,070 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...
Rating: |  Discuss |   Briefcase | 1,540 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,638 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,607 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 2010/10/07 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 4,108 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,593 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 | 2,109 reads

Another sp_who3

Get processes run and the command.  Read more...
By Kristian Ask 2010/10/07 | Source: SQLServerCentral.com | Category: dba
Rating: |  Discuss |   Briefcase | 4,108 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 | 2,023 reads

Find information about all databases

ALL database information  Read more...
By umar iqbal 2009/04/28 | Source: SQLServerCentral.com | Category: databases
Rating: |  Discuss |   Briefcase | 2,015 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 2013/05/07 | Source: SQLServerCentral.com | Category: growth
Rating: |  Discuss |   Briefcase | 5,617 reads
   Items 1 to 20 of 20   
 
Tags
databases (3)    
t-sql (3)    
administration (2)    
logins (2)    
powershell (2)    
scripting (2)    
sql server 2005 (2)    
automatic (1)    
automation (1)    
backup/restore (1)    
compare data (1)    
compare dataset (1)    
daylight (1)    
dba (1)    
delta (1)    
diagnostic (1)    
duplicate table (1)    
dynamic (1)    
function (1)    
grant (1)    
growth (1)    
integration services (ssis) (1)    
partitions (1)    
permissions (1)    
role (1)    
run (1)    
savings (1)    
script jobs (1)    
scripting jobs (1)    
security (1)    
simple-talk series (1)    
size (1)    
smo (1)    
sp_help_revlogin (1)    
sp_helpdb (1)    
sp_msforeachdb (1)    
sql job (1)    
sql jobs (1)    
sql server 7 (1)    
sqljob (1)    
sqljobs (1)    
stored procedures (1)    
switch (1)    
time (1)    
truncate (1)    
user (1)    
vbs (1)    
vbscript (1)