thanks ted! worked here also 🙂

thanks steve',,

im actually just having a look at it.. thanks =)

and if i want to create a stored procedure for this... where i can put in a variable for the domain..

for example,, i want to type in...

hehe.. embarrising 🙂 yea know i see it ... thank you very very much!! I bow greatly 😀

regards arash from denmark.

hi john,

ok.. when i ran the script first time, it created the user in every DB. so far so good. but it did not show at all in my...

and when i create the user PLYS\SQLMPLowPriv from GUI, i dont get any errors.

hmm.... seems like the script doesnt work entirely?...

yeah 🙂 ... think i got it working... but,, the user is not shown in my security login... how come?

i can see its in every db under security - users.

oh sorry, it is a security group in the domain. named PLYS\SQLMPLowPriv

so far i get this...

Msg 15407, Level 16, State 1, Line 1

'SQLMPLowPriv' is not a valid Windows NT name. Give the complete name: <domain\username>.

Msg 15151, Level 16, State 1,...

heres a link for the microsoft scom sql user:

http://technet.microsoft.com/en-us/library/dd767431.aspx

thanks alot journyman!.. just what i needed. i will try it out and get back to you. thanks so far.

hey u guys... i need some help with this also!..

I am having my doubts that our SQL is using the memory fully... especialy because AWE is set, but i...

WOW!! this is exactly 100% what i was looking for.

Thank you so much SSCrazy!!...

thanx henrik staun poulsen...

navnet lyder dansk =) ... såe,, endnu engang TAK