La vida de un DBA, Basis y Bedel en Puerto Rico
The name of the hour and a half wasted is:
SAPEVENTS.DLL IS USED BY Eventlog SERVICE
or
PROBLEMS REPLACING SAP DLL DURING A KERNEL UPGRADE
or
HOW TO REPLACE A DLL THAT IS IN USE BY A WINDOWS SERVICE THAT CAN NOT BE STOPPED
In Windows NT the command used was mv.exe, and was included in the resources cd
In Windows Server 2003 the command to achive that is InUse.exe
You can obtain InUse from the following Microsoft Web site:
http://support.microsoft.com/kb/927229
C:\>inuse C:\tmp\Kernel-2007-05-23\run\sapevents.dll C:\usr\sap\QA2\SYS\exe\run\sapevents.dll
INUSE is about to replace the following file
Destination File: C:\usr\sap\QA2\SYS\exe\run\sapevents.dll
Version: 6400, 155, 13, 13622
Created Time: 11:18:43, 2005/09/13
Last Modified Time: 18:43:18, 2006/10/29
Last Access Time: 11:28:51, 2007/05/24
Size: 880,640 byte(s)
Replacement File: C:\tmp\Kernel-2007-05-23\run\sapevents.dll
Version: 6400, 175, 13, 45015
Created Time: 10:11:25, 2007/05/24
Last Modified Time: 18:45:31, 2007/03/21
Last Access Time: 11:28:51, 2007/05/24
Size: 880,640 byte(s)
Do you want to continue? (y/n): y
C:\tmp\Kernel-2007-05-23\run\sapevents.dll is replacing --> C:\usr\sap\QA2\SYS\exe\run\sapevents.dll
Changes will not take affect until the system is rebooted.
The SQL Server 2005 Management Studio took MINUTES to load. I checked a lot of info about that and NOTHING worked...
I've been for weeks with this annoyance. None of the tips worked, BUT when I was looking in the registry I found something...
This keys were pointing to a folder in machine that no longer is in my network !!!
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell
I changed both to a local directory, and now it's opening in less than five seconds !!!
I hate (and love) SQL Server 2005...