Hi,

In Registered SQL Server Properties (General Tab) there is a check box
name "Always prompt for login name and password". A user can do it
using Enterprise Manager. But I need to know if it can be done by any
system SP or TSQL?

Thanks

Sajid Wasim

No. The database engine cannot prompt for anything, since it is running as a service, possibly on
another machine. The prompting need to be done by the client app.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


<ihavejunks@gmail.com> wrote in message
news:816726e4-b9f2-4383-a4e0-ae72d2d6e7c6@z11g2000prl.googlegroups.com...
> Hi,
>
> In Registered SQL Server Properties (General Tab) there is a check box
> name "Always prompt for login name and password". A user can do it
> using Enterprise Manager. But I need to know if it can be done by any
> system SP or TSQL?
>
> Thanks
>
> Sajid Wasim