Hi all
I'm responsible for moving a number of databases from our old SQL cluster to our new one. A lot of these are pretty old and trying to get more information about them is proving to be quite difficult. There are a couple of linked servers which are using the MSIDXS provider - that is, Microsoft Index Server (which i dont know much about). The prooperties of the linked servers (or running sp_linkedservers) doesn't give much information other than the datasource name & provider. How do i find out more about these linked servers, such as what databases are using them? I don't know much about Index Server either, but looking in Indexing Services in Computer Mgmt, i cannot see any folders set up on this server other than the default....
Can anyone help?
Thx,
Div
I'm responsible for moving a number of databases from our old SQL cluster to our new one. A lot of these are pretty old and trying to get more information about them is proving to be quite difficult. There are a couple of linked servers which are using the MSIDXS provider - that is, Microsoft Index Server (which i dont know much about). The prooperties of the linked servers (or running sp_linkedservers) doesn't give much information other than the datasource name & provider. How do i find out more about these linked servers, such as what databases are using them? I don't know much about Index Server either, but looking in Indexing Services in Computer Mgmt, i cannot see any folders set up on this server other than the default....
Can anyone help?
Thx,
Div
