User Question

I am new to SQL and have a newbie question

Using OSQL how would I create a user that can access the DB with read and
write capabilities. I dont want the user to have SA capabilities but be able
to read and write to the DB.

I am using SQL Express 2k5


.

Relevant Pages

  • Re: osql in a cmd file, with SQL statements coming from the same cmd f
    ... Instead of having the SQL ... > want to have the SQL statements right there in the command file. ... > about instead of separate cmd and sql files. ... > Any way to do this with OSQL, ...
    (microsoft.public.sqlserver.tools)
  • Re: Cannot get OSQL line to work for SharePoint
    ... I'm sure other people have moved their SharePoint files from one drive to ... And do you need the OSQL command to execute automatically and quit? ... Because you can use it as an interactive query tool too, which might be easier for you to work with. ... then you enter a "go" statement to submit the query to SQL Server: ...
    (microsoft.public.windows.server.sbs)
  • Re: Can you use osql in DTS?
    ... Don't know if I mentioned it, but I am on SQL 7. ... > DTS can use Dynamic Properties tasks. ... > Can the osql be used in DTS? ... > @chartime into a stored procedure that I would call. ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... Don't know if I mentioned it, but I am on SQL 7. ... > DTS can use Dynamic Properties tasks. ... > Can the osql be used in DTS? ... > @chartime into a stored procedure that I would call. ...
    (microsoft.public.sqlserver.programming)
  • Re: execute a sql file
    ... > beside ISQLW, OSQL, and ISQL utilities, ... ISQL sucks! ... OSQL is better than ISQL, ... But if your SQL is slow, then the tools are not making it any ...
    (microsoft.public.sqlserver.programming)