Chris Harshman

Phil Parkin

Thank's you very much for your answers, I will try to figure it out.

Thank you so much)

Yes, I mean it

Maybe someone needed

SELECT Rls.name as RoleMemeber,RlsMembers.name as [User]

INTO #RoleUser

FROM sys.Database_Principals Rls

INNER JOIN sys.database_role_members drm ON Rls.principal_id = drm.role_principal_id

INNER JOIN sys.Database_Principals RlsMembers ON drm.member_principal_id = RlsMembers.principal_id

WHERE Rls.is_fixed_role = 0

AND Rls.type =...

Thank you very much for your help , I will try to write a query .

Thanks again for your help.

WOW!!!

Many Many thanks for your answers

For a quick fix I use UNION ALL

I don't know, why i did double quotes, I find this example in internet, but this script work well and it download resul set in csv file

declare @cmd varchar(8000)

set @cmd=...

I do this script and it run succeseful

declare @cmd varchar(8000)

set @cmd= 'bcp "TestDB.dbo.ia_ReportUser" queryout "C:\TEMP1\2255212.csv" -c -t"," -T -S '+@@servername

exec master..xp_cmdshell @cmd

When I run TestDB.dbo.ia_ReportUser in QA

I have a...

This is stored procedure

[Devel].TestDB.dbo.ia_ReportUser

thank you!!!

You are right, when I did your scritp, the table compressed.