View Not Visible 关注

0
Avatar
Legacy Poster

I created a View in MS SQL Server 2008 R2 and it is not visible in Bartender. When I attempt to add it manually via "Enter Table Names by Hand Only," it returns Bartender Error Message #6669, "table_view" is not a valid table name for the named OLE DB Data Source currently in use.

 

I am able to see the view perfectly fine in Crystal Reports and SQL Explorer. Bartender seems to be missing it.

 

Any ideas?

1 评论
0
Avatar
Legacy Poster
评论操作 固定链接

I had to grant db_datareader to my label viewer user in SQL Server Management Console.

 

Able to see the view now!

请先登录再写评论。