I tried the same query on SQL Server 2008

But not working, it says in correct syntax near rowset

SELECT * FROM OpenRowset(NetGroupGetMembers, 'Domain\user')

Please need help to tell me how this works