OSQL problem

[angiem]

I am adding a user to my database and grant them access using OSQL, no problem with adding user but this statement doesn't work, what am I doing wrong

-E -d database -Q \EXEC sp_grantdbaccess \username,\userpwd\

 

[mrdenny]

You don't need to specify a password when using sp_grantdbaccess. Look up sp_grantdbaccess in BOL for all the paramaters.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com