HI, Just let you know that SP4 and Hotfix (KB899761) both are cluster share software. Do need to make sure all SQL resource on line.  By the way, Hotfix KB899761...

Do I need to apply SP4 for both note or apply one note only?

hawg,

Sorry, I am talking about SQL 2K to SQL 2K.  I just retry it again. It works now. 

Thanks.

KT

hawg,

I have a question? I try those scripts to transfer user login and password between 2 SQL 2000 servers.  I can not get password for each user.  There are blank at password...

How Uncheck "Affect the Group" option in the Full Text resource properties.  There only have 3 tabs - General, Dependencies and Advenced

Thanks,

KT

Thanks guys for the help. 

sp_cycle_errorlog works for me now.  I may setup a alert and let sqlagent to taking care of it later.  By the way, could you please...