this was my first google hit for "Script Login with Permissions to User Databases":

looks like exactly what you want, right?

http://www.sql-server-performance.com/2002/object-permission-scripts/

I think you need to simply drop the users.

something like this would generate the commands to either fix orphans or drop teh users, would this help?

/*--Results:

DROP USER [GMS];

DROP USER [CCFD01\Jack.Campbell];

*/

SELECT...

Rob I'm a developer, so the do-it-yourself options for me are much more palatable.

it's very very easy to do it all yourself you can use CLR.

I've got prototype CLR's...

going back to the questions on the first page...we never got a definitive answer.

did you disable windows firewall and attempt to connect?

what was the results or specific error when you...

here's the equivalent SELECT so you can see what would get updated...does it look correct?

SELECT * FROM Profiles

INNER JOIN AllJobCategories j

ON j.Uniqueid = Profiles.id

...

= (SELECT must return one value per row;

here's what i think is the equivalent , but since the subquery would return more than one industry id per profile, you don't...

well the aliased table a in your query is sys.database_principals , and that does not have a column named [authentication_type ],

the only dmv i could find with that exact...

ok i ran your command, and i have a trace up and running...it is not stopped for me.

i had to change the path from c:\MyTrace\ to a folder for me...

i think that last command is missing the variable:

exec sp_trace_setstatus TRACEID, 1 --start trace

--should be

exec sp_trace_setstatus @TraceID, 1 --start trace

ok, i think i see what you mean.

correct me if I'm misunderstanding the question please.

The default behavior is to create a user witht eh same name as a login.

so for...

the key there was emulates what you are trying to do, not necessarily...

this is where regular expressions will help out;

can you install a CLR on your server to let you do regular expressions?

converting a string is a two part process, I...

you probably need to partition by customer number + upc or invoice_number + upc instead...it completely depends on your specific data. based on what i was able to derive,...

you cannot remove the public role, it's built in and required. everyone is part of the public role.

http://www.databasejournal.com/features/mssql/article.php/1478701/SQL-Permissions-The-Public-Role.htm

what you can do is never grant any permissions to that role. so...

notice how i provided all the code you might need to test the solution? if you can do the same, by providing either CTE or CREATE TABLE...INSERT INTO statements, you'll...