Developing Matt

My Technical Journal

sp_helpme

leave a comment »

helpful help helps that I use (system procs to gleaning information from your database):

sp_help (objectname) shows parameters and other information on objects.  I use it for stored procs

sp_helptext (objectname) shows the context of that object (stored procs, it will show the query)

sp_helpindex (tablename) shows index info on table

sp_helprotect (objectname, username) shows permission info   (null one or other for more info)

sp_helpserver (servername) shows server information

sp_helpuser (username) shows sid, groupo, login of user

sp_helptrigger (tablename) shows the kinds of triggers on a table

sp_helpme   unfortunately, this doesn’t do anything.

all this and much much more here

Advertisements

Written by matt

November 5, 2008 at 1:55 pm

Posted in T-Sql

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: