mobasha (5/26/2008)
it would be like this:he ask for sa i say i have no such login, tell me what u want and i will provide u with a user to do what u need.
end of sotry.
u know am not the only DBA, but soon i will, so i cant disable the sa out of blow or keep the password just for my self, i need time before say no.
That's what you get for "lying"... the real fact is the SA login exists... muster up your courage, get full management support, and start telling people "NO", they can't have the SA password. Doing what you said...
"tell me what u want and i will provide u with a user to do what u need."
... should be prefaced with "Management says no one but DBA's get's the SA password, however, tell me what u want and i will provide u with a user to do what u need." is the best way to go.
--Jeff Moden
Change is inevitable... Change for the better is not.