I want to list database role members and most importantly, script them out. How can I do that?

Manoj Deshpande.

That's the answer! 🙂 Thanks so much David.

Hey thanks Ian. I got the answer. The correct thing for OUT is:

Master.dbo.xp_cmdshell 'BCP "Pubs.dbo.AUTHORS" OUT G:\BCPTEST2.TXT -C RAW -c  -T  -S Server'

Because, when I am using a...

HI,

My problem is a little different. I had this "Force Protocol Enable" checked. after that, the BCP "Query out" seems to be failing. But BCP "OUT" works. I tried on...