CODEWITHSUNDEEP
sql-serverpermissionslinked-server
Stan
Stan

Reputation: 38255

SQL Server - what permission need to open for view a table schema in a linked server

After creating a linked server on SSMS 2008, how should I see linked server table schema? Should I change any permission on remote SQL Server? Also, what commands can check those permissions for all accounts? Thanks.

EDIT: running on SQL Server 2000.

Upvotes: 0

Views: 1259

Answers (2)

Zachary
Zachary

Reputation: 6532

You specifically want to look at "sp_tables_ex" and "sp_columns_ex" if you are looking for table/column schema information. You might also be able to use DMV on the remote server to pull the information you need. The link below talks about the two SP mentioned above.

KB203638

Upvotes: 1

Will A
Will A

Reputation: 25008

You can either change the credentials used to connect to the linked server on the Security tab of the "New Linked Server" dialog, if you need to connect through using delegation or a specific logon, or you'll need to make changes to the permissions on the server being linked to.

Upvotes: 0

Related Questions