The thing is, you can't create a variable of type image. If it were SQL 2005, you could use varbinar(max) but that's not an option on 2000. So the suggested...

Can you post the import proc please?

There are serveral people here very good at 'fixing' cursors (by replacing them with set-based code)

The do work together pretty well.

Make sure when you install 2005 that you create a new instance and don't upgrade the 2000 instance.

I would recommend setting the max memory...

Absolutely. While it wouldn't speed up the entire process, it would shorten the length of the locks on the updated table.

Not quite as simple.

Right click the DB, Tasks -> Export Data

Work through the various steps of the wizard. If you have problems, shout.

If you want no one to access the DB, sysadmin or otherwise, take the DB offline

Check the link in the first post. It's a blog post by Conor Cunningham, former member of the SQL Server Query processing team and former development lead on the Query...

You can save the package out as VB code. If you have anyone there who can read VB, it may be of use.

Restricted user means that only members of the sysadmin server role or db_owner database rolw can connect to the DB.

Is that what you're looking for?

Barely. I would doubt it would be visible.

I prefer the .. EXISTS (SELECT <constant> ... format, as it's fairly clear from that that no values are been returned

Can you post the code, the schema and indexes on the table and an approx row count please?

It is definitely possible. My work machine's set up that way.

Make sure you install SQL 2000 first (perhaps as the default instance) and then 2005 as a named

Or by writing optimal code and ensuring that indexes are appropriate.

Make sure you're running this in the database that the procs are in. Object_name, when passed one param, looks in the current DB.

If you're running SP2, you can use the...

There's a massive difference between the statements

Select 1 where exists(select * from dbo.WordIndex where Term='inc')

and

select * from dbo.WordIndex where Term='inc'

Exists is only checking for the existence of a row. It...