SQL 2000 database connected from which server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL 2000 database connected from which server

Author

Topic

Jazzy108
Starting Member

1 Post

Posted - 2009-02-24 : 21:18:08

I have to migrate SQL 2000 DB to New SQL 2000 DB server

I have dedicated SQL server which caters to clients dedicated web servers.

I have to check the database to whom these database belong so i can send details to client after migration is done.

I tried sp_who but it does not give IP of server.

Thanks

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-25 : 07:55:27

quote:
Originally posted by Jazzy108

I have to migrate SQL 2000 DB to New SQL 2000 DB server

I have dedicated SQL server which caters to clients dedicated web servers.

I have to check the database to whom these database belong so i can send details to client after migration is done.

I tried sp_who but it does not give IP of server.

Thanks

Your post is not clear.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-25 : 10:05:47

Or you mean this:

I run this in batch file to get information from windows task scheduler:

:: @ECHO OFF

:: *********** Version 1.0 **************

SET APP=C:\WINDOWS\system32\netstat.exe

:TOP

SET FILEDATE=%DATE:~-10%

SET FILEDATE=%FILEDATE:/=_%

SET LOGFILE=D:\temp\netstat_out_%FILEDATE%.log

ECHO . >>%LOGFILE%

ECHO %DATE% %TIME% >>%LOGFILE%

%APP% -a >> %LOGFILE%

ECHO %DATE% %TIME% >>%LOGFILE%

ECHO . >>%LOGFILE%

exit

Or You can use SQL profiler as well.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources