Re: Password on Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 05/19/04 

Date: Wed, 19 May 2004 14:26:15 +0100

Look up sp_password in Books Online. 

-- 
Jacco Schalkwijk
SQL Server MVP
"rikesh" <rikesh_patel@website.com> wrote in message
news:eGO2ADaPEHA.1048@tk2msftngp13.phx.gbl...
> Hi
>
> Is it possible to update the SQL server password on a local  machine and
> change it from sa, admin.  Our old DBA was very lazy and we would prefer
to
> use Strong Passwords?
>
> Is there a way you can apply this change without re-installing SQL again,
> perhaps through TSQL?
>
>
> -- 
> Kind Regards
>
> Rikesh
> (SQL2K-SP3/W2K-SP4)
>
>

Relevant Pages

  • Re: Password History in SQL Server
    ... Mike Epprecht, Microsoft SQL Server MVP ... >I know that there is a rule in SQL Server password naming that last n ...
    (microsoft.public.sqlserver.security)
  • Re: Password on Server
    ... > Jacco Schalkwijk ... > SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: SELECTs from different Server
    ... Vinod Kumar ... Books Online for SQL Server SP3 at ... "Rikesh" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: MS Shell Dlg
    ... Apologies, should have explained better, I meant in Enterprise Manager, when ... > Looking for a SQL Server replication book? ... > Rikesh wrote: ... >> This is probably not that important, but I changed the font, and now I ...
    (microsoft.public.sqlserver.server)
  • Re: OR or IN
    ... FOr small lists, the optimizer treats them both exactly the same way.. ... Wayne Snyder, MCDBA, SQL Server MVP ... "rikesh" wrote in message ... > I've got a big list in my WHERE clause, and I was wondering what clause to ...
    (microsoft.public.sqlserver.programming)