sql server full text search: When I run sp4 on my sql7 win 2k server, the patch gets
as far as writing scripts 1 of 8. It says that it can't
has problems executing the script and ask to retry or
cancel. I can hit the retry button but after 4 tries, it
cancels out of the patch. I've updated the win 2k server
patches to sp4, rebooted a few times, shutdown all other
programs before installing the patch and nothing has
worked.
Does anyone have any suggestions?
Thanks,

you have to debug your installation script.

Start the upgrade like this c:\x86\setup\Setupsql.exe k=dbg
where x86 is the directory you have your sp in.

For instance, we could try to run upgrade.sql manually at
the debug interrupt, and start SQL with the same options
that the installation tried:

C:\TEMP\SQL2KU~1\SQL2K_~1\X86\BINN\osql.exe -S
NJRETAIL2NT -b -n -d master -o "D:\MSSQL7
\install\upgrade.out" -i "D:\MSSQL7\install\script1.sql" -
U sa -P

This will allow you to step through your script1.sql
script command by command. Make sure you replace