Viewing Your Database in SQL Server Management Studio
Date Submitted: 9-23-2010 by 
Rachel
RachelMany of you let us know that you needed this functionality restored, so we did. Thanks for letting us know what we can do to provide you the best hosting service possible.
As a security measure, our MSSQL team disabled the “view server state” permissions on Web hosting accounts. This change prevents you from viewing your database directly from SQL Server Management Studio. However, you can still see your database through a new query window, which increases your safety and protects your data in the shared environment.
To view your database, you can enter the following commands in the query window:
| Enter this command | To do this |
|---|---|
| sp_helptext ‘myviewname’ | See the contents of a view |
| sp_helptext ‘myprocedurename’ | See the contents of a stored procedure |
| sp_help ‘mytable’ | See the details of a table |
| sp_help ‘objectname’ | Get more information about a specific object |
| select * from sys.tables | List database tables |
| select * from sys.procedures | List stored procedures |
| select * from sys.views | List views |
| select * from sys.database_permissions | List permissions in the entire database |
| select * from fn_my_permissions (‘mytablename’, ‘object’) | List permissions for a specific object |
| select * from fn_my_permissions (‘myviewname’, ‘object’) | List permissions for a specific object |
| select * from fn_my_permissions (‘myprocedurename’, ‘object’) | List permissions for a specific object |
| select * from fn_my_permissions (‘mydatabaseuser’, ‘user’) | List permissions for a specific database user |
You can refer to SQL Server Books Online (BOL) for additional commands.
20 min expected wait time
5 Comments on "Viewing Your Database in SQL Server Management Studio"
Sorry, a blog is no replacement to a much needed functionality.
I don’t like it, it might drive potential user away. I have to use SQL Server web Admin to manage the database, I had a problem when I was trying to insert a new column in a table, the new column was also created on the end, but i want to insert it in the middle of the existing columns.
“Many of you let us know that you needed this functionality restored, so we did. Thanks for letting us know what we can do to provide you the best hosting service possible.
As a security measure, our MSSQL team disabled the “view server state” permissions on Web hosting accounts. This change prevents you from viewing your database directly from SQL Server Management Studio”
Not following you here. fail.
I’m glad you restored this functionality for SQL Server Mgmt Studio. But did you recently remove it again? I just connected for the first time and cannot view or access my database in the Object Explorer tree. I can access it from the query window, but as everyone else has noted, this is not acceptable. Is there something specific I need to do to be able to make use of the Mgmt Studio features?
@OSCF Everything should be working normally. If you’re having issues, you should try contacting support.