here you go:

CREATE ROLE DatabaseUser

EXEC sp_addrolemember N'db_datareader', N'DatabaseUser'

CREATE ROLE DatabaseDeveloper

EXEC sp_addrolemember N'db_ddladmin', N'DatabaseDeveloper'

EXEC sp_addrolemember N'db_datareader', N'DatabaseDeveloper'

EXEC sp_addrolemember N'db_datawriter', N'DatabaseDeveloper'

you need to create a user on the AS400 that has read only permissions.

then when you create the linked server, use that specific user for the remote login.

it is...

Sanz (2/15/2012)

---

Strange ! GRANT VIEW ANY DEFINITION was run against a Login and it was run in master. Still the permission does not reflect in other db's. Am I missing...

i'm pretty sure GRANT VIEW ANY DEFINITION TO LOGIN is a server scope command...it has to be against a login and not a user, and your database has to be...

is that logic right?

i don't think you need to go to the dmvs, first of all...

second, this pretty much says "if you find any of these conditions, even if it's...

sql runs as a service, it's main executable is not double clickable/runable...you go to Control Panel Administrative tools>>Services and see if it is running there or not (you can use...

lol my shops IT budget doesn't have room for any software that would make my life easier; it pretty much covers absolutely required hardware + licenses.

If i wanted something like...

looks like a GUI data input tweak;

if you go straight to TSQL, you cannot create a ulogin or user that starts with @

you can create either for a login which...

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...