Friday, February 24, 2012

Enable sa login for SQL Express 2005 using osql.exe

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
Hi
ALTER LOGIN sa ENABLE;
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Qingsong Zhang" <qingsong_zhang@.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
>

No comments:

Post a Comment