October 12, 2012 at 11:17 am
When creating a new view with the view designer from SSMS, if I type a table name in the SQL pane that is being accessed via a linked server, the column names do not show up in the Diagram pane - only a tbname.* is generated. The SQL will still execute and give results but I can not seem to get the column names to show. The linked server is defined to make the connection to the remote sql box with a generic readonly id. I tried granting that id sysadmin rights on both local and remote servers but still no column names. I am using SQL2K8R2.
Any help is appreciated !!!
October 12, 2012 at 1:53 pm
Does account used for linked server has right to see the view definition (not just SELECT permission) ?
Permission is "VIEW DEFINITION".
October 16, 2012 at 12:04 pm
For anyone interested, looks like the problem is caused by a table that has a special character in the name - blanks, spaces, etc. If you remove those, then the columns display in the diagram pane just fine.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply