Thanks, this does exactly what I was looking for.

select'account name' = domain+N'\'+name,

'type' = convert(varchar(8), case when sidtype = 1 then 'user' else 'group' end),

'privilege' = 'admin',

'mapped login name' = domain+N'\'+name,

'permission path' = 'DOMAIN\GROUPNAME'

from OpenRowset(NetGroupGetMembers, 'DOMAIN\GROUPNAME')

That is the code.

Yea, it is not performing so well. I wanted to at least give it a try and see how it affects the performance. I don't know if the...

I like synonyms over views. They can be fully automated for remote servers during a restore process. Since they have a standardized form and their data is in...

The answer is wrong unless we are playing grade school try to trick the student games. The 1 letter difference between what may be considered wrong and what is...

Yea, that'll be a problem. It's going to run slower in SSRS than in management studio. I think you are going to have to fix your query before...

I would suggest you try running the query in management studio first. See how long it takes, how many records it returns, how many columns, how wide is the...

The report has 31 million records? Or the database? If the report has 31 million records, I would suggest you either figure out a way to filter it...

I have written an article solving exactly this problem with a nice UDF. It is here: Nth Weekday of the Month

[/url]

What did you do? We are working on getting the enterprise edition setup, but in the meantime, we do not have data driven subscriptions :ermm:

I have also found that if you're having problems with headers (text boxes above the tablix(s)), you can just add rows above the tablix header row. Then you can...