Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.

Reverse-Engineer Database Permissions (2005 up)

This script reverse engineers SQL statements to recreate database permissions.

Principals, Securables, Permissions oh my. SQL 2008/2005

RE: SQL Login Security

If your users are connecting through an application server you can put the SQL Server behind a firewall and just allow access through the firewall to the app server IP address, thus denying enyone else access.

RE: Restarting SQL Server every night

net stop mssqlservernet start mssqlserverand schedule it at windows level (at command).

RE: SQL statement help needed (2)

No, not me! But I know a friend who knows someone who has heard, that there might be some people... Actually I only thought about why always reinvent the wheel when someone else has done similar before.

RE: Passing a querystring to a stored procedure?

- keep sql-injection in mind ! Check http://qa.sqlservercentral.com/columnists/chedgate/sqlinjection.asp- just define your variables as sp-parameters and handle your statement in your sp. You will soon discover it's best to work with known predicates.- check http://www.sommarskog.se/dynamic_sql.html and http://www.sommarskog.se/dyn-search.html

RE: Windows server name from T-sql

I am looking for what severs are controlling the active clusters.

RE: Need help with calculation

Thanks to all, your input has been very helpful! CSDunn