<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Content with tag
script
Items 1 to 17 of 17
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
|
4,296 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/01/22
|
Source:
SQLServerCentral.com
|
Category:
truncate
Rating:
|
Discuss
|
Briefcase
|
644 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
|
818 reads
Scripting SQL jobs using PowerShell
Using powershell to create different sql scripts in different files.
Read more...
By
Premjit Das
2012/05/03
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
1,589 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,456 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
|
1,958 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
|
852 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,512 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,454 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
|
3,993 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,477 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,050 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
|
3,993 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,923 reads
Find information about all databases
ALL database information
Read more...
By
umar iqbal
2013/05/25
|
Source:
SQLServerCentral.com
|
Category:
databases
Rating:
|
Discuss
|
Briefcase
|
1,842 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
|
4,296 reads
Permission scripting over all databases
Scripts permissions/roles for db user across all databases.
Read more...
By
W Louw
2013/05/25
|
Source:
SQLServerCentral.com
|
Category:
permissions
Rating:
|
Discuss
|
Briefcase
|
10,801 reads
Items 1 to 17 of 17
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)
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
