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

Content with tags SQL Server 7, Administration, Security Rss

   Items 1 to 20 of 44    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,476 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,250 reads

Read_Only Database

By Unknown . 2009/04/10 | Category: sql server 7
Rating: (not yet rated) |  Discuss |   Briefcase | 3,919 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,250 reads

usp_SecurCreation - SQL 2k

Creates statements for securables creation.  Read more...
By Pedro Lopes MS 2008/06/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 874 reads

Beginning SQL Server - Logins and Users

Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.   Read more...
By Steve Jones 2007/08/03 (first published: 2004/09/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 41,043 reads

Auditing with SQL Profiler

SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.   Read more...
By Brian Kelley 2007/04/20 (first published: 2004/09/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,818 reads

Implementing Encrypting File System (EFS) with SQL Server

EFS provides a mechanism for encrypting files completely transparent to higher level applications such as SQL Server. In this article by Brian Kelley, he shows you how to implement this type of security in your environment.   Read more...
By Brian Kelley 2006/12/01 (first published: 2002/12/09) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 29,099 reads

SQL Server 2000 SP 3: What's New in Security

Service Pack 3 for SQL Server 2000 is huge. There are significant changes in it and they apply to all three products: the core SQL Server, MSDE, and Analysis Services. Because there are so many changes, this first article in the series will only focus on the security changes.   Read more...
By Brian Kelley 2005/12/09 (first published: 2003/06/05) | Source: SQLServerCentral.com | Category: service packs
Rating: |  Discuss |   Briefcase | 29,970 reads

SQL Server Security Part 2

In part one Chris Kempster covered a variety of security recommendations primarily for production systems. In Part two of this series he continues to explore security at a variety of levels where you may not realize you are vulnerable.   Read more...
By Chris Kempster 2005/11/04 (first published: 2004/01/30) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 35,069 reads

Conducting a SQL Server Operational Audit

Auditing, analyzing and documenting your SQL Server installation is becoming more important all the time, especially as more and more attention is being paid to the security of your environment. Chad Miller brings us a look at a framework and a sample document you can use in your environment to conduct an audit.   Read more...
By Chad Miller 2005/10/24 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,161 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

Troubleshooting Cannot Generate SSPI Context Errors

As a DBA you do not need to know how to setup an Active Directory domain or a DNS server, but you still need to know how Kerberos, Service Principle Names, and hostnames are used to perform integrated authentication to a SQL Server. This article by new columnist Chad Miller shows you some of the more integral parts of troubleshooting running Windows Authentication security in a SQL Server environmnet.   Read more...
By Chad Miller 2005/08/19 (first published: 2003/02/27) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 65,286 reads

SQL Server Security Part 1

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...
By Chris Kempster 2005/02/11 (first published: 2002/01/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 49,987 reads

Beginning SQL Server - Logins and Users

Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.   Read more...
By Steve Jones 2007/08/03 (first published: 2004/09/02) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 41,043 reads

Auditing with SQL Profiler

SQL Server includes a great auditing tool: Profiler. It's not the easiest tool to use, however, and it's one that takes some getting used to. Our resident security export, Brian Kelley looks at a simple example of using this tool to audit logins.   Read more...
By Brian Kelley 2007/04/20 (first published: 2004/09/01) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,818 reads

SQL Server Alerts

SQL Server Alerts provide a great way for the server to notify a DBA that some event has occurred, usually something bad that they need to fix. However alerts can also be used to drive business logic processes and enable some types of actions to be safely performed without requiring extraordinary rights by a user. Author Leo Peysakhovich brings us some ideas on how we can use alerts to implement business logic processing.   Read more...
By Leo Peysakhovich 2004/08/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 20,537 reads

Fixing broken logins and transferring passwords

When transferring a database to a new server, you are bound to experience a user problem. In this article by Neil Boyle, he shows you how to transfer passwords and accounts seamlessly to a new server.   Read more...
By Neil Boyle 2004/07/05 (first published: 2002/08/14) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 23,926 reads

Hidden Dangers!

How many of you register a server in Enterprise Manager? Now how many of you click the "save password" box? Probably most of you. Are you aware of the security risks associated with this? James Travis looks at one of potential problems here and other security issues relating to SQL-DMO.   Read more...
By James Travis 2004/05/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,561 reads

SQL Server Auditing and Notification

As Jeff says, "There are lots of articles about how to do auditing, but there are few discussions about how to use the auditing results in a real time environment". Well, now we have one that shows you how to do it!   Read more...
By Jeffrey Yao 2004/03/29 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,115 reads
   Items 1 to 20 of 44    Older >>
 
Tags
configuring (9)    
miscellaneous (6)    
programming (5)    
t-sql (5)    
installation (4)    
sql server 6.5 (4)    
strategies (4)    
dts (3)    
stored procedures (3)    
backup / restore (2)    
best and worst practices (2)    
indexing (2)    
logins (2)    
monitoring (2)    
replication (2)    
sql-dmo (2)    
triggers (2)    
user defined function (udf) (2)    
worst practices (2)    
ado (1)    
databases (1)    
disaster recovery (dr) (1)    
distributed queries (1)    
english query (1)    
grant (1)    
openxml (1)    
performance tuning (1)    
permissions (1)    
role (1)    
script (1)    
scripting (1)    
service packs (1)    
sql server 2005 (1)    
system databases (1)    
updategrams (1)    
user (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)