Install

Is there a script that can give you the details of an installation for SQL s
erver 2000. What connection mode was used...etc
ThanksHi,
Have a look into serverproperty function in books online, But the
authentication mode can not selected using this function.
FYI, The authentication mode of SQL Server is stored in the registry, so you
need read the registry to check the authentication. Use the extended
procedure xp_regread to read the registry and get the authentication mode.
Thanks
Hari
MCDBA
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:27BA378C-E2BA-4ECD-8BF9-7B0C31959B78@.microsoft.com...
> Is there a script that can give you the details of an installation for SQL
server 2000. What connection mode was used...etc
> Thanks|||The install details for SQL Server are stored in a file called SQLSTP.log...
You will find it in the windows directory...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:27BA378C-E2BA-4ECD-8BF9-7B0C31959B78@.microsoft.com...
> Is there a script that can give you the details of an installation for SQL
server 2000. What connection mode was used...etc
> Thanks