March 13, 2009 at 9:39 am
My company recently purchased a vendor application with a SQL Server 2005 database and I've been given the task to create several custom reports using Crystal Reports. No documentation came with the database and I've been instructed to use the views for the reports instead of the base tables. I have Management Studio and I can see the columns in each of the views, but I want to be able to see the underlying query that defines the view in order to make sure my reports are correct. When I try to use the Generate SQL Server Scripts Wizard on the views I get an error message telling me I have insufficient rights. I've asked the DBA and he said he can't give me that access because then I would be able to modify and delete object in the database.
Is there any way I can see the information I need without that level of access?
Thanks for your help. The DBA hasn't been very helpful and I did a search on BOL and couldn't find any information on this. I'm rather new to SQL Server and I'm trying to learn on the fly on my own.
March 13, 2009 at 9:56 am
The DBA should be able to give you specific permisson to view the definition of the View, and then Deny modify/alter permissons.
March 13, 2009 at 10:13 am
Thank you so much. I did not know about the view definition feature in SQL Server 2005. Apparently the DBA does not know about it either. This is exactly what I was looking for. I really appreciate your help on this.
March 13, 2009 at 10:41 am
No worries, thanks for the feedback..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply