|
|
|
|
|
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Highlighting the stored procedures item displays all of the procs in a database, the owner, and creation date. The final column gives you a very handy reference to determine which procs are encrypted. It was a little irritating to double click a proc to view it only to be told it is encrypted.
Double clicking a proc will display the stored procedure editor. The definition tab allows you to modify the proc. The privileges tab is where you can grant permissions on the proc. The dependencies tab gives a good overview of what objects are referenced by this proc.
The database roles have me a little baffled. When you viewed the server roles, it provided a nice description of what each one was for. It would have been really nice to see this same description for all of the fixed database roles as well.
DBArtisan 5.03 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
