<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
Scripts with tag
SQL Server 2000
Refine your search with one of the following additional tags (with number of items):
SQL Server 2005
(5)
Miscellaneous
(2)
Enterprise Manager
(1)
Registered Servers
(1)
T-SQL Aids
(3)
Administration
(1)
Maintenance and Management
(1)
Restore
(1)
Backup
(2)
DMO
(1)
powershell
(1)
T-SQL
(1)
Search for
any
content tagged
SQL Server 2000
Add a script
Items 1 to 9 of 9
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
|
18 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,263 reads
Import/Export SQL Server 2000 Enterprise Manager Registered Servers
Exports and imports SQL Server 2000 Enterprise Manager groups and server registrations using Powershell.
Read more...
By
Chad Miller
2008/05/08
|
Source:
SQLServerCentral.com
|
Category:
powershell
Rating:
|
Discuss
|
Briefcase
|
601 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
Generate SQL Scripts from Database
Simulate EM's Generate SQL Scripts with DMO and VBS
Read more...
By
Absinthe
2008/02/15
|
Source:
SQLServerCentral.com
|
Category:
DMO
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
1,192 reads
Restore database with all necessary files
It creates the script for restoring your database with all the backups (full, differential and transaction log) needed.
Read more...
By
Josep
2008/02/12
|
Source:
SQLServerCentral.com
|
Category:
Restore
Rating:
|
Discuss
|
Briefcase
|
883 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,506 reads
Check Availability Window - SQL2k
This script allows you to check the several availability windows for the current day.
Read more...
By
Pedro Lopes
2008/01/18
|
Source:
SQLServerCentral.com
|
Category:
Maintenance and Management
Rating:
|
Discuss
|
Briefcase
|
582 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
|
917 reads
Items 1 to 9 of 9
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
