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 - 2004-01-19 : 09:47:51
|
| writes "I'm having a strange issue with using sp_indexes. I've been searching hi and lo, and I haven't come up with anything. Maybe you can help.Background:MS SQL2K, sp3a (version 8.00.760). Running on Win XP Pro(for development and testing purposes. All the defaults were chosen during the SQL Server install. And the db owner is SA (and I am using that login for testing purposes (until I get through this issue).The environment is contained on a laptop for development purposes, but will be moved to the std edition on a windows 2003 server once fully developed. The server was added to the linked server list, using all the defaults for a SQL Server)I am trying to use sp_indexes (the server has been added to the linked table list).Upon executing sp_indexes (with the proper syntax: sp_indexes 'KFROSS','Rack','dbo','ADL','Rack_PK'), the error that is returned is:Server: Msg 7346, Level 16, State 2, Procedure sp_indexes, Line 9Could not get the data of the row from the OLE DB provider 'UNKNOWN'. [OLE/DB provider returned message: Requested conversion is not supported]OLE DB error trace [OLE/DB Provider 'UNKNOWN' IRowset::GetData returned 0x80040e1d].I've tried this using other servers (SQL2K) and for some reason no matter the combination, I keep getting this error.Thanks for the help,Doug Smith" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Using SP_indexes on SQL2K developer (single machine) 