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

Content with tags Administration, Programming, Stored Procedures, T-SQL Rss

   Items 1 to 6 of 6   
 

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,253 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,684 reads

An Automated Solution for Migrating Database Structures

This article by Simon Galbraith (from Red Gate software, maker of SQL Compare) discusses migrating changes from development to staging, QA, and on to production. If you've never seen the need for a schema compare tool (Steve Jones!), this is worth reading.  Read more...
By Additional Articles 2003/05/06 | Source: DevX | Category: administration
Rating:  Rate this |   Briefcase | 2,211 reads

Logins, Users, and Roles - Getting Started

Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique.   Read more...
By Andy Warren 2005/09/30 (first published: 2003/02/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,253 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,684 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,568 reads
   Items 1 to 6 of 6   
 
Tags
sql server 7 (4)    
miscellaneous (3)    
database design (2)    
sql-dmo (2)    
strategies (2)    
visual basic 6 (2)    
basics (1)    
configuring (1)    
installation (1)    
security (1)