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

views:

answers:

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.

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.

Will A 2010-07-17 04:03:16

+1 A:

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

Zachary 2010-07-17 04:17:32

Sorry not to mention I am running a SQL Server 2000, and it doesn't have those system tables. What should I do?

Stan 2010-07-21 00:06:51

both of the SP above should work in SQL Server 2000, here is a link to the documentation on sp_tables_ex, http://msdn.microsoft.com/en-us/library/ms176051.aspx

Zachary 2010-07-21 03:17:38

Thanks, even I find these info, still don't know what permission I need to grant for viewing table schema on linked server. Please advise, thanks.

Stan 2010-07-23 00:28:10

ansaurus

tags:

views:

answers:

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

related questions