April 11, 2009 at 7:52 pm
I have a DotNetNuke database that functions well enough but when in SSMS the Tables item doesn't expand to show tables, the same with System Tables. Other databases display respective tables. I've 'mucked about' with permissions to no avail.
Any directive would be appreciated.
thanks
b
April 12, 2009 at 9:29 am
barryocteau (4/11/2009)
I have a DotNetNuke database that functions well enough but when in SSMS the Tables item doesn't expand to show tables, the same with System Tables. Other databases display respective tables. I've 'mucked about' with permissions to no avail.Any directive would be appreciated.
thanks
b
Which permission set do you have (sa / dbo / db_datareader ...)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 13, 2009 at 5:19 pm
Hi,
Along with the permissions, please check if you have any filter settings and remove them.
Right Click Tables -> Filter -> Remove Filter.
Thanks
Prem
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply