Find the serial no from the computer

I lose the original box of SQL server 2000 eng. How can I find the serial
no. from the Server which installed SQL server 2000 before. Thanks much!!Run 'REGEDIT' from Windows Start--> Run.
Traverse the following chain:
"HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
Microsoft SQL Server
80
Registration"
The "Registration" entry has the product ID. You can also
get the CD-key from here.
--
HTH. Ryan
"Eco" <eco@.hotmail.com> wrote in message
news:epG6QqGgGHA.2416@.TK2MSFTNGP03.phx.gbl...
>I lose the original box of SQL server 2000 eng. How can I find the serial
> no. from the Server which installed SQL server 2000 before. Thanks much!!
>sql

Find the serial no from the computer

I lose the original box of SQL server 2000 eng. How can I find the serial
no. from the Server which installed SQL server 2000 before. Thanks much!!Run 'REGEDIT' from Windows Start--> Run.
Traverse the following chain:
"HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
Microsoft SQL Server
80
Registration"
The "Registration" entry has the product ID. You can also
get the CD-key from here.
HTH. Ryan
"Eco" <eco@.hotmail.com> wrote in message
news:epG6QqGgGHA.2416@.TK2MSFTNGP03.phx.gbl...
>I lose the original box of SQL server 2000 eng. How can I find the serial
> no. from the Server which installed SQL server 2000 before. Thanks much!!
>

Find N/w adapters remotely

Is there any command I can use to find out the n/w adapters used on a remote
SQL 2000 Server without actually logging onto that box and going to My
Network Place and so on.. Want to be able to do it remotely
ThanksYou can run mmc, add the Device Manager snap-in, point it at your remote
server and have a look at the Network Adapters section to find out what
adapters you're using on that box. Not exactly a cmdline but you don't have
to start a full TS session on your remote server.
HTH.
--
Cheers,
Mike
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDDrKNn0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Is there any command I can use to find out the n/w adapters used on a
> remote
> SQL 2000 Server without actually logging onto that box and going to My
> Network Place and so on.. Want to be able to do it remotely
> Thanks
>|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDDrKNn0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Is there any command I can use to find out the n/w adapters used on a
remote
> SQL 2000 Server without actually logging onto that box and going to My
> Network Place and so on.. Want to be able to do it remotely
>
You can try doing an xp_cmdshell ('ipconfig /all') and capturing the results
to a table.
> Thanks
>

Find N/w adapters remotely

Is there any command I can use to find out the n/w adapters used on a remote
SQL 2000 Server without actually logging onto that box and going to My
Network Place and so on.. Want to be able to do it remotely
ThanksYou can run mmc, add the Device Manager snap-in, point it at your remote
server and have a look at the Network Adapters section to find out what
adapters you're using on that box. Not exactly a cmdline but you don't have
to start a full TS session on your remote server.
HTH.
Cheers,
Mike
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDDrKNn0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Is there any command I can use to find out the n/w adapters used on a
> remote
> SQL 2000 Server without actually logging onto that box and going to My
> Network Place and so on.. Want to be able to do it remotely
> Thanks
>|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDDrKNn0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Is there any command I can use to find out the n/w adapters used on a
remote
> SQL 2000 Server without actually logging onto that box and going to My
> Network Place and so on.. Want to be able to do it remotely
>
You can try doing an xp_cmdshell ('ipconfig /all') and capturing the results
to a table.

> Thanks
>

Find N/w adapters remotely

Is there any command I can use to find out the n/w adapters used on a remote
SQL 2000 Server without actually logging onto that box and going to My
Network Place and so on.. Want to be able to do it remotely
Thanks
You can run mmc, add the Device Manager snap-in, point it at your remote
server and have a look at the Network Adapters section to find out what
adapters you're using on that box. Not exactly a cmdline but you don't have
to start a full TS session on your remote server.
HTH.
Cheers,
Mike
"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDDrKNn0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Is there any command I can use to find out the n/w adapters used on a
> remote
> SQL 2000 Server without actually logging onto that box and going to My
> Network Place and so on.. Want to be able to do it remotely
> Thanks
>
|||"Hassan" <fatima_ja@.hotmail.com> wrote in message
news:uDDrKNn0EHA.2016@.TK2MSFTNGP15.phx.gbl...
> Is there any command I can use to find out the n/w adapters used on a
remote
> SQL 2000 Server without actually logging onto that box and going to My
> Network Place and so on.. Want to be able to do it remotely
>
You can try doing an xp_cmdshell ('ipconfig /all') and capturing the results
to a table.

> Thanks
>

Find an associated user

I am trying to copy a database that is on a Windows 2000 box to one
that is on Windows 2003. Is there a way to export a list of server
login names? I am having problems with one I am trying to create where
on the old server using Teratrax I can see that it is an associated
user Name, but I don't know which user it is associated with. Is there
a command that can tell me which user the account is associated with?
It definitely isn't a domain user and isn't a local account. It says
that the user is a SQl user but I can't seem to find where the
association is.
hi Mark,
"Mark Constant" <constants@.mix-net.net> ha scritto nel messaggio
news:ce43fdea.0412011310.6ac9ef82@.posting.google.c om
> I am trying to copy a database that is on a Windows 2000 box to one
> that is on Windows 2003. Is there a way to export a list of server
> login names? I am having problems with one I am trying to create where
> on the old server using Teratrax I can see that it is an associated
> user Name, but I don't know which user it is associated with. Is there
> a command that can tell me which user the account is associated with?
> It definitely isn't a domain user and isn't a local account. It says
> that the user is a SQl user but I can't seem to find where the
> association is.
SET NOCOUNT ON
USE TEMPDB
PRINT 'adding SQL Server Login [x] to [' + DB_NAME() + '] as [x_user] in the
[db_datareader] database role'
EXEC sp_adduser 'x', 'x_user', 'db_datareader'
PRINT 'grandting [x_user] in [' + DB_NAME() + '] database [db_datawriter]
database role membership'
EXEC sp_addrolemember @.rolename = 'db_datawriter' , @.membername = 'x_user'
PRINT 'listing all [' + DB_NAME() + '] database users'
EXEC sp_helpuser
PRINT 'listing [' + DB_NAME() + '] database [x_user] user''s database role
membership'
EXEC sp_helpuser 'x_user'
PRINT 'Dropping [x_user] user from [' + DB_NAME() + '] database'
EXEC sp_dropuser 'x_user'
which results to
adding SQL Server Login [x] to [tempdb] as [x_user] in the [db_datareader]
database role
Granted database access to 'x'.
'x_user' added to role 'db_datareader'.
grandting [x_user] in [tempdb] database [db_datawriter] database role
membership
'x_user' added to role 'db_datawriter'.
listing all [tempdb] database users
UserName GroupName LoginName DefDBName UserID SID
-- -- -- -- -- --
----
dbo db_owner sa master 1 0x01
x_user db_datareader x a 5
0x67F945E170B2574AA8DCB909B68D46A9
x_user db_datawriter x a 5
0x67F945E170B2574AA8DCB909B68D46A9
listing [tempdb] database [x_user] user's database role membership
UserName GroupName LoginName DefDBName UserID SID
-- -- -- -- -- --
----
x_user db_datareader x a 5
0x67F945E170B2574AA8DCB909B68D46A9
x_user db_datawriter x a 5
0x67F945E170B2574AA8DCB909B68D46A9
Dropping [x_user] user from [tempdb] database
User has been dropped from current database.
as you can see you can inspect the result of sp_helpuser system store
precedure
(http://msdn.microsoft.com/library/de...-us/tsqlref/ts
_sp_help_45o2.asp) that reports, as long as the user name, the corresponding
Login..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply