Getting to Know sp_helpuser

Sep 4

Posted by

The stored procedure, sp_helpuser, is useful in showing various information about the users such as login name, default database, default schema and the SID.  You can also see if a user name is aliased.  I hope you find this useful.  Enjoy!

About these ads

About SQLGator

Florida Gator and Certified SQL Server Enthusiast, Star Wars fanatic and is there anything else...oh yeah PS3! I am a geek and SQL Server DBA who dabbles with VMWare, there are other technologies greater than these? Not so fast my friend! I also love to travel to new and exotic places.

Posted on September 4, 2012, in Maintenance, SQL Schoolhouse and tagged . Bookmark the permalink. Leave a Comment.

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 974 other followers

%d bloggers like this: