<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
Search:
Home
Articles
Editorials
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Content with tag
SQL Server 7, 2000
Refine your search with one of the following additional tags (with number of items):
Administration
(332)
Best Practices
(6)
English Query
(2)
Indexes
(1)
Miscellaneous
(124)
Career
(6)
Full-Text Search
(2)
Jobs
(1)
Performance Tuning
(121)
Naming Standards
(6)
Logins
(2)
Linked Server
(1)
T-SQL
(113)
Other
(6)
OpenXML
(2)
Lock and Connection Management
(1)
Security
(105)
Product Reviews
(6)
Permissions
(2)
Meta Data Services
(1)
News
(99)
Analysis Services (SSAS)
(5)
routine database growth
(2)
Metadata
(1)
Configuring
(83)
Bugs
(5)
routine growth
(2)
Notification Services
(1)
DTS
(76)
Rants
(5)
SQL Server 2008
(2)
Passwords
(1)
Programming
(69)
System Development Life Cycle
(5)
Storage
(2)
Perl
(1)
Strategies
(64)
upgrading
(5)
UpdateGrams
(2)
powershell
(1)
Monitoring
(55)
Access
(4)
Utility
(2)
proxy accounts
(1)
SQL Server 2005
(55)
Advanced
(4)
XSL
(2)
Random Numbers
(1)
Replication
(44)
Backup
(4)
Administering
(1)
Recovery
(1)
SQL Server 6.5
(33)
counter
(4)
Backup / Restore
(1)
Registered Servers
(1)
Indexing
(30)
Development
(4)
Book Reviews
(1)
Restore
(1)
Backup and Recovery
(29)
nums
(4)
Capacity planning
(1)
Role
(1)
Advanced Querying
(25)
SQLInsider Scripts
(4)
compare T-sql
(1)
Schemas/DTDs
(1)
Visual Basic 6
(23)
Table of Numbers
(4)
content difference table
(1)
script
(1)
Basic Querying
(21)
tally
(4)
Data Types
(1)
scripting
(1)
Installation
(21)
User Defined Function (UDF)
(4)
Database Mail
(1)
Scripts
(1)
Database Design
(18)
Arrays
(3)
database options administration
(1)
setup
(1)
Stored Procedures
(17)
ASP
(3)
Database Roles
(1)
SQL Agent
(1)
Disaster Recovery
(16)
Delimited Strings
(3)
Database Weekly
(1)
SQL Puzzles
(1)
Best and Worst Practices
(14)
Maintenance
(3)
Databases
(1)
SQL Server 2005 - SSIS
(1)
Distributed Queries
(14)
Maintenance and Management
(3)
Date Manipulation
(1)
SQLServerCentral
(1)
Service Packs
(13)
OLAP Server
(3)
Dependencies
(1)
SS2K5 - Replication
(1)
ADO
(12)
parse
(3)
Design and Theory
(1)
SS2K5 - XML
(1)
Basics
(12)
SQL Server 2005 - Security
(3)
Differential Backup
(1)
syscomments
(1)
SQL-DMO
(12)
SQLMail
(3)
DMO
(1)
Sysobjects
(1)
Triggers
(11)
State of the Business
(3)
Editorial
(1)
System databases
(1)
Availability
(9)
String Manipulation
(3)
Enterprise Manager
(1)
Table
(1)
Worst Practices
(9)
Admin
(2)
Error Description
(1)
Table aliases
(1)
.Net
(7)
Alias Data Types
(2)
Error Messages
(1)
Upgrade
(1)
Data Warehousing
(7)
auto-growth
(2)
Error Number
(1)
User
(1)
Reviews
(7)
automated DBA
(2)
GRANT
(1)
Writing readable code
(1)
T-SQL Aids
(7)
Certifications
(2)
index
(1)
xp_sendmail
(1)
XML
(7)
data file management
(2)
Items 1 to 20 of 974
Next 20 >>
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. (from Feb 2008)
Read more...
By
TJay Belt
2009/09/04 (first published: 2008/02/05)
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
19,067 reads
Get DDL for any SQL 2000 table
a stored procedure returning a single varchar(8000) of the CREATE TABLE script for any table.It does everything calculated columns, rules,indexes,defaults,triggers,constraints...everything.
Read more...
By
Lowell Izaguirre
2009/07/28
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 7, 2000
Rating:
|
Discuss
|
Briefcase
|
429 reads
Meta Data Services
Read more...
By
VM-723206
2009/07/20
|
Category:
SQL Server 7, 2000
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
2,470 reads
Table Index Store and Create
Query to save all index metadata
Read more...
By
Jorge Novo-396570
2009/07/17
|
Source:
SQLServerCentral.com
|
Category:
Indexes
Rating:
|
Discuss
|
Briefcase
|
439 reads
Differential Backup Store Procedure for SQL Server 2000
The Store Procedure can be use for generating Differential Backup datewise in SQL Server 2000.
Read more...
By
Swapnil Tawde
2009/07/14
|
Source:
SQLServerCentral.com
|
Category:
Backup / Restore
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
400 reads
Sending E-mail from SQL Server 200X
From monitoring e-mail messages to distributing reports for users, SQL Server's database mail proves quite useful. Learn how to use it in SQL Server 2000 and SQL Server 2005/2008.
Read more...
By
Additional Articles
2009/07/01
|
Source:
DevX
|
Category:
Database Mail
Rating:
Rate this
|
Briefcase
|
3,500 reads
The Automated DBA: Batch Database File Grower - SQL 2000 Version
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
Read more...
By
Jesse Roberge
2009/06/25
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
357 reads
The Automated DBA: Batch Database File Grower - SQL2000 ReportOnly Ver
Grows all of the data files in a database based on the greater of a fixed minimum free space amount or a dynamic percentage of the size of the largest table in the filegroup.
Read more...
By
Jesse Roberge
2009/06/19
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
361 reads
Enhancing the readability of your code: Table aliasing in sql
When writing SQL, picking good tables aliases can greatly enhance the readability of your code
Read more...
By
Sylvia Moestl Vasilik
2009/05/07
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 2005
Rating:
|
Discuss
|
Briefcase
|
7,595 reads
Read_Only Database
Read more...
By
Unknown .
2009/04/10
|
Category:
SQL Server 7, 2000
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
3,319 reads
From the Real World: SQL Server 2000 SP4 Installation Failure
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
Read more...
By
Praveen Voleti
2009/03/04
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 7, 2000
Rating:
|
Discuss
|
Briefcase
|
2,815 reads
Yet Another Deleting Duplicate Records (in-place)
Here is another "deleting duplicate records" script, this time in-place, using a uniqueidentifier column.
Read more...
By
Peter Petrov
2009/01/15
|
Source:
SQLServerCentral.com
|
Category:
Miscellaneous
Rating:
|
Discuss
|
Briefcase
|
1,215 reads
Get Error Description in SQL Server 2000
How to Extract Error Description in SQL Server 2000 based on Error Number
Read more...
By
Mudassar Ahmed Khan
2009/01/13
|
Source:
SQLServerCentral.com
|
Category:
Error Description
Rating:
|
Discuss
|
Briefcase
|
5,580 reads
Tables referenced by a stored proc (2000)
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
Read more...
By
David McKinney
2008/12/30
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 7, 2000
Rating:
|
Discuss
|
Briefcase
|
836 reads
Proxy Accounts in SQL Server
Yan Pan explains how to set up proxies in SQL Server 2000, 2005 and 2008, and compares the differences between them
Read more...
By
Additional Articles
2008/12/30
|
Source:
Database Journal
|
Category:
proxy accounts
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,629 reads
Powering up DTS with PerlDTS
This article introduces the PerlDTS project that provides a Perl distribution to access and execute MS SQL Server 8 DTS packages.
Read more...
By
Alceu Rodrigues de Freitas Junior
2008/12/22
|
Source:
SQLServerCentral.com
|
Category:
Perl
Rating:
|
Discuss
|
Briefcase
|
2,653 reads
The Full Potential of SQL 2000
Attending a conference and hearing about all the latest and greatest new features is a bit like spending holiday sampling exotic seafood and imbibing strange new cocktails. When you return, you're decidedly in the mood for a pie and a pint of beer.
Read more...
By
Tony Davis
2008/12/01
|
Source:
SQLServerCentral.com
|
Category:
Editorial
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
314 reads
Generate a random password
If you ever need a quick way to generate random passwords, this is a pretty useful way to do so
Read more...
By
Gaby Abed
2008/11/13
|
Source:
SQLServerCentral.com
|
Category:
Random Numbers
Rating:
|
Discuss
|
Briefcase
|
1,627 reads
Compare Dates in an iterative manner for a particular set of records
Compare Dates in an iterative manner for a particular set of records in a single query using SQL Server 2000
Read more...
By
Divya Agrawal
2008/11/12
|
Source:
SQLServerCentral.com
|
Category:
T-SQL
Rating:
|
Discuss
|
Briefcase
|
3,470 reads
Delimited String Parsing Functions - TwoCol set
Feed it two delimited strings of horizontal data and it returns it back as a vertical table with the two column data in the same synchronized position order.
Read more...
By
Jesse Roberge
2008/11/03
|
Source:
SQLServerCentral.com
|
Category:
T-SQL Aids
Rating:
|
Discuss
|
Briefcase
|
1,754 reads
Items 1 to 20 of 974
Next 20 >>
Most popular
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
|
6,925 reads
Get Error Description in SQL Server 2000
How to Extract Error Description in SQL Server 2000 based on Error Number
Read more...
By
Mudassar Ahmed Khan
2009/01/13
|
Source:
SQLServerCentral.com
|
Category:
Error Description
Rating:
|
Discuss
|
Briefcase
|
5,580 reads
From the Real World: SQL Server 2000 SP4 Installation Failure
SQL 2000 SP4 failure on Cluster with error:Setup failed to perform required operations on the cluster nodes
Read more...
By
Praveen Voleti
2009/03/04
|
Source:
SQLServerCentral.com
|
Category:
SQL Server 7, 2000
Rating:
|
Discuss
|
Briefcase
|
2,815 reads
Copyright © 2002-2009 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use
