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

Content with tags Security, Administration, SQL Server 7, T-SQL Rss

   Items 1 to 6 of 6   
 

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,468 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,262 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 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,262 reads

The Case for SQL Logins - Part Two

In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.   Read more...
By Andy Warren 2002/08/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,769 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads
   Items 1 to 6 of 6   
 
Tags
configuring (3)    
miscellaneous (3)    
stored procedures (3)    
backup / restore (2)    
dts (2)    
indexing (2)    
installation (2)    
programming (2)    
triggers (2)    
user defined function (udf) (2)    
databases (1)    
distributed queries (1)    
english query (1)    
grant (1)    
logins (1)    
monitoring (1)    
openxml (1)    
performance tuning (1)    
permissions (1)    
replication (1)    
role (1)    
script (1)    
scripting (1)    
sql-dmo (1)    
strategies (1)    
updategrams (1)    
user (1)    
xml (1)    
xsl (1)