February 27, 2006 at 1:30 pm
In SQL 2005's Object Explorer I expand Databases, hilite a DB, then click VIEW \ SUMMARY (at top of screen). My DB objects appear in right pane (Diagrams, Tables, Views, Programmability, etc) along w/ 7 icons above the DB Name. The last of the 7 icons is "REPORT" -- but it's protected -- How can I unprotect this icon and see a report..
February 27, 2006 at 3:13 pm
I tested and foud out that if I connect to the local or remote 2005 server with either admin or low-privilege logins I have Reports enabled. But when I connected to SQL Server 2000, Reports were not enabled even if I was a system administrator in both SQL and Windows servers.
Regards,Yelena Varsha
February 28, 2006 at 10:03 am
Reports relies on the new DMVs in 2005 and will not work with 2000
Terry
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply