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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-15 : 09:24:07
|
| ALI writes "How to select data from sysremote_indexes system table? I get following error./*-----------------------------select * from dbo.sysremote_indexes-----------------------------*/Server: Msg 201, Level 16, State 7, Line 1Procedure 'dbo.sysremote_indexes' expects parameter 'ServerName', which was not supplied." |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-02-15 : 10:04:30
|
http://216.239.59.104/search?q=cache:X8k1kszQ9PAJ:files.seegers.nl/Welcome/Data/Downloads/Toolz/Citrix%2520tools/Access%2520gateway/CAAC45/Support/SqlExpress_2005_SP1/setup/program%2520files/microsoft%2520sql%2520server/x86/install/oledbsch.sql+sysremote_indexes&hl=sl&ct=clnk&cd=13&gl=siGo with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
spejbl
Starting Member
28 Posts |
Posted - 2007-02-15 : 10:07:05
|
| SELECT * FROM master.dbo.sysremote_indexes('YourLinkedServer','RemoteDatabase','dbo')Tomhttp://kbupdate.info/ |
|
|
|
|
|
|
sysremote_indexes