Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQL Server 7 Rss

   Items 1 to 20 of 987    Older >>
 

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,457 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 2013/05/15 | Source: SQLServerCentral.com | Category: random numbers
Rating: |  Discuss |   Briefcase | 3,260 reads

Disaster In The Real World - #2

Back in April Steve Jones wrote up a disaster at work. Andy had one this week and wrote up the story too. Copy cat! Pretty soon everyone will be having a disaster and writing a story about it! Give these guys credit for letting you see what happens when it ALL goes bad. Disaster recovery is hard to sell and hard to do, reading the article might give you an idea that will save you some time and/or data one day.   Read more...
By Andy Warren 2012/12/14 (first published: 2002/07/31) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 10,496 reads

Logins created in the last X Days

These scripts give you the list of logins created in the Last X Days for SQL Server 2000 or 2005.  Read more...
By Mani Singh 2011/12/23 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 2,249 reads

Comprehensive Backup Script

These scripts were generated to standardize our SQL backup environments, and to remove backups from Maintenance Plans.  Read more...
By Simon Facer 2011/12/22 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 3,340 reads

Generate SQL Scripts from Database

Simulate EM's Generate SQL Scripts with DMO and VBS  Read more...
By Absinthe 2011/12/16 | Source: SQLServerCentral.com | Category: dmo
Rating: (not yet rated) |  Discuss |   Briefcase | 3,808 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 MS 2011/12/15 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 3,402 reads

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 2011/10/28 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 2,766 reads

Set standard database options

Ensure all your databases have standardised options by running this script weekly.  Read more...
By Ed Vassie 2011/09/19 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 2,061 reads

Backup Stored Proc

Script to backup 2000/2005 databases.  Read more...
By Scott Duncan 2011/09/09 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 8,878 reads

Script a Database Role

Script one or all roles in a database. Includes users, obect permissions and column permissions.  Read more...
By Ed Vassie 2011/09/08 | Source: SQLServerCentral.com | Category: sql server 7
Rating: |  Discuss |   Briefcase | 5,036 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 2011/07/13 | Source: SQLServerCentral.com | Category: restore
Rating: |  Discuss |   Briefcase | 4,272 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 Skotak 2011/05/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 9,806 reads

SQL Server 7 Build List

A list of builds and versions for SQL Server 7.  Read more...
By Steve Jones 2010/08/26 | Source: SQLServerCentral.com | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 197 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. (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 | 22,403 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
Rating: |  Discuss |   Briefcase | 686 reads

Meta Data Services

By VM-723206 2009/07/20 | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 2,688 reads

Table Index Store and Create

Query to save all index metadata  Read more...
By Jorge Novo-@ETLDEVDBA 2009/07/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 856 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 | 719 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 | 4,314 reads
   Items 1 to 20 of 987    Older >>
 
Tags
administration (333)    
miscellaneous (124)    
performance tuning (121)    
t-sql (115)    
security (105)    
news (99)    
configuring (83)    
dts (76)    
programming (69)    
strategies (64)    
monitoring (55)    
sql server 2005 (55)    
replication (44)    
backup / restore (34)    
sql server 6.5 (33)    
indexing (31)    
advanced querying (25)    
visual basic 6 (23)    
installation (21)    
database design (18)    
stored procedures (17)    
disaster recovery (dr) (16)    
best and worst practices (14)    
distributed queries (14)    
service packs (13)    
ado (12)    
basics (12)    
sql-dmo (12)    
triggers (11)    
availability (9)    
worst practices (9)    
xml (8)    
.net (7)    
data warehousing (7)    
reviews (7)    
best practices (6)    
career (6)    
naming standards (6)    
other (6)    
product reviews (6)    
upgrading (6)    
analysis services (ssas) (5)    
bugs (5)    
rants (5)    
system development life cycle (5)    
access (4)    
advanced (4)    
counter (4)    
development (4)    
nums (4)    
sqlinsider scripts (4)    
table of numbers (4)    
tally (4)    
user defined function (udf) (4)    
arrays (3)    
asp (3)    
delimited strings (3)    
maintenance (3)    
maintenance and management (3)    
olap server (3)    
parse (3)    
sqlmail (3)    
state of the business (3)    
string manipulation (3)    
alias data types (2)    
auto-growth (2)    
automated dba (2)    
certifications (2)    
data file management (2)    
databases (2)    
english query (2)    
full-text search (2)    
logins (2)    
openxml (2)    
permissions (2)    
routine database growth (2)    
routine growth (2)    
sql server 2008 (2)    
storage (2)    
updategrams (2)    
utility (2)    
xsl (2)    
backup / recovery (1)    
book reviews (1)    
build list (1)    
capacity planning (1)    
compare t-sql (1)    
content difference table (1)    
data types (1)    
database mail (1)    
database roles (1)    
database weekly (1)    
date manipulation (1)    
dependencies (1)    
design and theory (1)    
differential backup (1)    
dmo (1)    
editorial (1)    
enterprise manager (1)    
error handling (1)    
grant (1)    
integration services (ssis) (1)    
jobs (1)    
linked server (1)    
lock and connection management (1)    
meta data services (1)    
metadata (1)    
notification services (1)    
passwords (1)    
perl (1)    
powershell (1)    
proxy accounts (1)    
random numbers (1)    
registered servers (1)    
restore (1)    
role (1)    
schemas/dtds (1)    
script (1)    
scripting (1)    
scripts (1)    
setup (1)    
sql agent (1)    
sql puzzles (1)    
sql server 2000 (1)    
sqlservercentral (1)    
syscomments (1)    
sysobjects (1)    
system databases (1)    
table (1)    
table aliases (1)    
user (1)    
writing readable code (1)    
xp_sendmail (1)