Yes eval installs on XP.

I don't know if it's common practice to have a carved in stone design before doing dev work.  I'd surely be ok with having a solid design plan, but which...

Maybe this can help too.

http://software.pricegrabber.com/database-management/m/436437/search=sql%202000

Have you checked out the MS site to see if you could buy / download one version of it?

You can still download the full evaluation version on microsoft.com.

That could give you some more time to find and buy the real dev version.

Can't be done easily if you have foreign keys all over the place.

One thing you can do is script the whole database, rename the actual DB, then run the script...

sarg = searchable argument.

This is a where clause that can use a index : WHERE MyDate BETWEEN '2007-07-01' AND '2007-07-02'.

Non searchable argument in that exemple would be this : Where...

Try again with the bit column, you'll most likely see a convert_implicit in the execution plan.

Change to sarg like this : WHERE BitCol = CONVERT(BIT, 1)

That'll most likely push you back...

Here's the whole tree (very roughly presented) :

--> Sql servers

--> Databases

--> Access data projects

--> Top level objects (Forms, reports, macros...)

--> FormsObjects

--> FormsObjectsProperties

--> FormsObjectsPropertiesEvents

--> FormsObjectsPropertiesCodes (I was insterting the code...

Fixed width = CHAR

always english = VARCHAR

This however assumes that those variables will never change, which is sometimes hard to garantee.

Not that I know of.  AFAIK, unless you had profiler running, there's nothing you can do now... except turn auditing on!

Agreed.  Dynamic sql was made for cases like this one.

AS long as you are not using user inputs in the proc, stay with loop / dynamic sql.  The solution is...

Wasn't even aware that I was that close .

Maybe I'll even get there before PASS 2007.

That happens... I don't ahve time to reread the whole post everytime I answer... sorry if anyone got offended by that "double" post .

truncate both tables, insert data in both systems.

GO home.

WHILE EXISTS (SELECT * FROM tbl1 WHERE value1 = 'abc')

BEGIN

UPDATE table1 set value2 = '123' where value1 =...