This Code will give you the logins created in the last X Days.
you can create a Job on each SQL instance and include this Code and send you notification every Morning/Evening about the logins changed Created in the last X Days.
Mani Singh,
2011-12-23 (first published: 2008-06-08)
This Code will give you the logins created in the last X Days.
you can create a Job on each SQL instance and include this Code and send you notification every Morning/Evening about the logins changed Created in the last X Days.
[X is a INT] SQL 2000 version select * from master.dbo.syslogins Where createdate >=getdate()-X [Replace X with Logins created in the last X=number of days] SQL 2005 Version Select * from sys.server_principals Where create_date >= GETDATE()-X [Replace X with Logins created in the last X=number of days]
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.
2007-10-02 (first published: 2002-08-14)
24,376 reads
In the final article in the series, Chris Kempster covers some of the more advanced methods to securing your SQL Server.
2002-02-18
9,783 reads
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.
2007-10-02 (first published: 2002-01-14)
50,358 reads
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
2001-10-30
6,113 reads
This document introduces SQL Server administrators and developers to the new security features of SQL Server 2000. In addition to outlining the new features, there is a detailed discussion about how to best implement security in a Microsoft Windows® 2000 domain environment as well as source code examples.
2001-08-02
1,383 reads