Diagram Pane in Design View not showing columns

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Diagram Pane in Design View not showing...

Diagram Pane in Design View not showing columns

Rate Topic

Display Mode

Topic Options

Author

Message

davemiller3

Posted Friday, October 12, 2012 11:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 05, 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

Vedran Kesegic

Posted Friday, October 12, 2012 1:53 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 12:57 PM
Points: 343, Visits: 1,089

Does account used for linked server has right to see the view definition (not just SELECT permission) ?
Permission is "VIEW DEFINITION".

_____________________________________________________
XDetails Addin - for SQL Developers and DBA
blog.sqlxdetails.com - Transaction log myths - debunked!

Post #1372344

davemiller3

Posted Tuesday, October 16, 2012 12:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, November 05, 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 »

Permissions