<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_top"><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
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tags
SQL Server 2005
,
SQL Server 2000
Refine your search with one of the following additional tags (with number of items):
Miscellaneous
(2)
Backup
(1)
T-SQL Aids
(2)
Monitoring
(1)
Administration
(1)
T-SQL
(1)
Items 1 to 6 of 6
Proc to Rename a file
A simple way to rename a file from within a T-SQL Script, primarily designed to add a date-time stamp. Works in 2000 and 2005.
Read more...
By
Simon Facer
2008/06/17
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
16 reads
Row count and space used for all tables in database (update)
This procedure works like the sp_spaceused procedure but this one shows statistics for all tables in the selected database or for all databases (excluding tempdb and model).
Read more...
By
Rafal S.
2008/05/02
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,249 reads
Available bytes for row expansion (adding columns) in a table
This scalar function accepts a table name and returns the number of bytes left out of the 8060 bytes available for adding new columns.
Read more...
By
ruchir
2008/04/03
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
339 reads
A Failed Jobs Monitoring System
One DBA's tale of how to monitor jobs for failure and ensure that the DBA is alerted to the fact that there is a problem.
Read more...
By
TJay Belt
2008/02/05
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
7,821 reads
Backup Stored Proc
Script to backup 2000/2005 databases.
Read more...
By
Scott Duncan
2008/01/17
|
Source:
SQLServerCentral.com
|
Category:
Backup
Rating:
|
Discuss
|
Briefcase
|
2,496 reads
Check Instance Info
Named or default instance, this will check info like Virtual Server Name, Cluster Name , Current owner, Preferred Owner? and? Status? (if clustered) and IP/Port for the current instance.
Read more...
By
Pedro Lopes
2007/12/19
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2000
Rating:
|
Discuss
|
Briefcase
|
915 reads
Items 1 to 6 of 6
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
