Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2007-07-09 : 11:24:27
|
| hi Im trying to query information_schema in a different server, if I query sysobjects I have no problem, I however want to use inf.shcema since I understand it will be supported in further versions of sql server,im using:select * from myRemoteServer.myRemoteDb.information_schema.table_constraints--but not successfulthank you |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-09 : 15:04:49
|
| Tried with openquery? |
 |
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2007-07-09 : 15:22:17
|
| thanks r,i used :select * from OPENQUERY ( myLinkedServer,'myRemoteDb.dbo.sp_pkeys @table_name = ''myySpecificRemoteTable'' ' ) and it seems to work--------- |
|
|
|
|
|
|
querying information_schema remotely