 |
|
Web Wiz Web Hosting 30 Day Free TrialWindows Hosting 30 Day Free Trial, with no obligation, on all our Windows Web and Reseller Hosting Packages.For more information see our Windows Hosting 30 Day Free Trial page. |
Problem seeing database in SQL Server Mgmt Studio |
Post Reply 
|
| Author | |
milesee 
Newbie 
Joined: 17 April 2010 Status: Offline Points: 2 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Problem seeing database in SQL Server Mgmt StudioPosted: 17 April 2010 at 1:13am |
|
Hi,
I've just signed up with We Wiz and have installed SQL Server Management Studio to setup tables, views, etc. in my database, but whenever I try to expand the "Database" node in the Object Viewer tree, I get an error, basically relating to the fact that I don't have permissions to acces the first database it sees, which is "aspnetdb". After OK is clicked on the error message, no other databases are displayed!! Can someone help me please?! I don't want to have to resort to T-SQL just to create a few tables.
Thanks in advance,
Miles.
|
|
 |
|
|
WebWiz-Bruce
Admin Group 
Web Wiz Developer Joined: 03 September 2001 Location: Poole, England Status: Offline Points: 8039 |
Post Options
Thanks(0)
Quote Reply
Posted: 19 April 2010 at 9:12am |
|
The problem will be that you need SQL Admin permissions to view some of the columns you have in the Object Explorer Window in SQL Management Studio.
On the Databases node on the Object Explorer window you will see some column names at the top, right click on this and remove the columns that you do not have permission to view, such as Recovery Model, Compatibility Level, Owner, etc. |
|
|
|
Topic Options|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
