|
 |
About Us | |
|
SSWUG Articles | |
 |
Articles | |
|
FAQ |
|
Administration | |
|
Backup/Restore | |
|
Connectivity | |
 |
Development | |
|
General | |
|
Installation | |
|
OLAP | |
|
Replication | |
|
Transfer/move | |
|
Trouble | |
|
SQL 6.5 |
|
Scripts | |
|
Tips | |
|
Test Exams | |
|
Advertise | |
|
Download | |
|
History | |
|
Search | |
|
Traffic | |
|
Related Links | |
|
||
|
|
||
 How can I return from within a T-SQL the list of all available OLE DB providers? Answer: You can use the xp_enum_oledb_providers undocumented extended stored procedure to return the list of all available server's OLE DB providers. This extended stored procedure does not require any parameters. This is the example to run: EXEC master..xp_enum_oledb_providers See this article to get more information about the useful undocumented extended stored procedures: Useful undocumented extended stored procedures |