Audit SQL Logins - Updated
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server.
Update to Simon Facer's script.
2011-05-23 (first published: 2007-09-25)
13,413 reads
SQL Auditing - Generate a listing of the SQL logins, and the permissions for each database on a server.
Update to Simon Facer's script.
2011-05-23 (first published: 2007-09-25)
13,413 reads
2011-05-23
335 reads
Query Active Directory to get information on user logins.
2011-05-19 (first published: 2011-05-16)
3,902 reads
Stored procedure to backup all DB (chose user or system). You can do full, differential and log backups
2011-05-13 (first published: 2011-05-06)
3,164 reads
View login information for all accounts that use SQL authentication.
2011-05-12 (first published: 2011-05-09)
2,985 reads
Find the last day (or number of days in a month) in one statement without having to use IFs or BUTs.
2011-05-10 (first published: 2011-04-29)
2,435 reads
This script is used for drop and create a new or existing user. IF User is already exists in database then first it will dropped and then recreate.
2011-05-05 (first published: 2011-04-28)
1,823 reads
Excel files includes a very good functionality called Macro execution. And here we can use this functionality to write one macro that will generate INSERT statements.
2011-05-02 (first published: 2009-02-21)
16,650 reads
Returns Top 25 fragmented indexes complete with full object name and index name.
2011-04-29 (first published: 2009-05-29)
10,026 reads
Remove tab,line feed and carriage return frome text field
2011-04-28 (first published: 2011-04-21)
3,370 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru, Kota...
WhatsApp:0817819444 Jl. Brawijaya 79, Dusun Muncar Baru, Tembokrejo, Kec. Muncar, Kabupaten Banyuwangi, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers