Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

The query below returns most of the data from the SharePoint list that my customers want:

    SELECT * 
    FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0',
                     'WSS;IMEX=1;RetrieveIds=Yes;
                      User id=abc1;Password=xxxxxxx;
                      DATABASE=http://abcdefg/HijkLMno/;LIST=Whatever;',
                     'SELECT * FROM LIST') B

The issue is I need to join the local SharePoint User IDs from the UserInfo table. How do I construct the DATABASE= string and use OPENROWSET to get the ID, names, etc...?

PS I must use OPENROWSET; Please do not suggest i query these tables directly as I cannot.

share|improve this question
    
Can you explain why you "must use OPENROWSET" just so we have some context? –  Aaron Bertrand Dec 21 '12 at 23:06
    
We must use OPENROWSET because know of no other way to get to the data due to the way the SharePoint databases are installed. –  Todd O Dec 24 '12 at 17:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.