This Stored Procedure will display object level permissions
for stated User or Role.
Procedure output is ready to execute batch.
Usage:
Exec ScriptPermissions 'public'
Generates Filegroup listing on a db for each table
This script generates filegroup listing on a given database for each table within the database. This will be very handy to indentify which table is built on a particular filegroup. This is useful for a VLDB (very large database).
2005-05-27 (first published: 2005-05-09)
438 reads