Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Diagram Pane in Design View not showing columns Expand / Collapse
Author
Message
Posted Friday, October 12, 2012 11:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 5, 2012 9:59 AM
Points: 6, Visits: 171
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 !!!
Post #1372289
Posted Friday, October 12, 2012 1:53 PM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 3:57 PM
Points: 369, Visits: 1,211
Does account used for linked server has right to see the view definition (not just SELECT permission) ?
Permission is "VIEW DEFINITION".


_____________________________________________________
Microsoft Certified Master: SQL Server 2008
XDetails Addin - for SQL Developers
blog.sqlxdetails.com - Transaction log myths
Post #1372344
Posted Tuesday, October 16, 2012 12:04 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, November 5, 2012 9:59 AM
Points: 6, Visits: 171
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.
Post #1373446
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse