<div>
<div class="content wysiwyg-content">
I can use <br />
<br />
osql &nbsp;-S server -E<br />
<br />
to open an osql session.<br />
<br />
How, then, could I create a user and a login with sa rights/role using t-sql?<br />
<br />
Thanks,<br />
Steven
</div>
</div>


I can use 

osql  -S server -E

to open an osql session.

How, then, could I create a user and a login with sa rights/role using t-sql?

Thanks,
Steven

SQL 2008 create sa-role user from command prompt

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.