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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 OPENROWSET and OLE DB Providers

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-09 : 09:27:33
charlie writes "Execute "sp_helptext xp_logininfo" in master you can see the code behind xp_logininfo. The actual select is this...

select * from OpenRowset(NetGroupGetMembers, 'DOMAIN\group')

(fill in your domain and a group)

If you read in Books Online it explains the parameters for OpenRowset, but I'm confused as to where NetGroupGetMembers comes from. I'm assuming that it is an OLE DB provider name, but are there more of them like this one?

If you do xp_enum_oledb_providers this isn't listed... Can anyone expain how this works???


Thanks"
   

- Advertisement -