My SQL 7 DB returns

Unicode data sorting

Locale ID = 1033

case insensitive, kana type insensitive, width insensitive

Sort Description Order

Character Set...

It shows 7.00.623, so SP didn't go through.

BTW, what's version on SQL 2000?

You're right even though I remember applying SP2. So I guess SP change the version. Now I have to find what are the diffrences in those versions.

Thanks all!

At least I don't remember installing SQL 2000, I wouldn't do such a thing without testing. I have a couple of Apps from MS Office 2000 Premium SR1: Front Page...

Office 97 Pro, nothing fancy. No 2000 eval.

I have Dtspkg.dll and Dtspkg.rll ver. 1998.11.13 on the server and 2000.02.08. ver. on development machine. Both are servers using SQL 7 SP2. How's that happened?

Where new version came from?...

That will cost me. Is any cheaper way to update the libraries only though?

Andy, can you be little more specific about

serialize access to the file and uniqueidentifier, please? Do you mean creating text file via VB-script with uniqueidentifier?

Thanks!

Yes, but the server where it will be running doesn't have SQL server installed.

I specify it on Advanced Tab, Transact-SQL script (TSQL) Command Options. This step looks looks in script like:

EXECUTE @ReturnCode = msdb.dbo.sp_add_jobstep @job_id = @JobID, @step_id =...