Thank you, but I guess that my question was not clear. I want to only add new members to an existing role; I don't want to have to list...

Thank you. I was trying it from both VS and MS - both work now with your help.

thanks

Are you able to post the monitoring scripts?

Thanks.

That worked beautifully -- thank you.

Once again, posts here have saved me. 

Thank you -- I can modify this to get what I need.  Maybe MS will add the old functionality back in? 

Thank you.  Losing my mind and thinking only of the master db info.

Ryan, thank you, but this will not work in SS 2005.

As far as the SSIS method, do you know offhand a way to exclude specific logins?  I can see a...

thank you

I was just hoping to do a single check against the db -- inserting/updating thousands of rows at a time.

" You might like to know that it is in SQL Server 2005. "

Do you have an example of the syntax?

Don't know why, but rebooting the server over the weekend cleared up the problem.

Yes -- the set statement alone causes this error.

Yes, thank you.

Thank you.  Do you know if this is still valid in SQL 2005?