Enable sa login for SQL Express 2005 using osql.exe

microsoft.public.sqlserver.tools

17 Dec 2005 7:29 AM

Qingsong Zhang

Hi,

Is there a way to enable the sa login using osql.exe? I think SQL Express
2005 disables the sys table modification using osql.exe.

Regards,

Qingsong

17 Dec 2005 7:40 AM

Mike Epprecht (SQL MVP)

Hi

ALTER LOGIN sa ENABLE;

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: m***@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

Show quote

"Qingsong Zhang" <qingsong_zh***@affymetrix.com> wrote in message
news:etAOavtAGHA.2704@TK2MSFTNGP15.phx.gbl...
> Hi,
>
> Is there a way to enable the sa login using osql.exe? I think SQL Express
> 2005 disables the sys table modification using osql.exe.
>
> Regards,
>
> Qingsong
>