Report SQL SERVER 2005 Permissions
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,838 reads
Reports permissions to three levels: database, schema and table -- in three formats: readable, structured, scripted.
2011-12-12 (first published: 2008-02-22)
3,838 reads
Delete duplicates with a CTE (common table expression).This script uses the same setup as the anonymous post using a cursor (http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1872).
2007-08-23
1,095 reads
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Knowledge of how your system behaves is vital to better control, maintain, and grow...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Background: We have MS Access database split with backend tables that we want to...
Comments posted to this topic are about the item Space allocated to the databases...
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...