So what was the problem?

Who said anything about dropping a table??

Good point tho!

Select case when @SomeVar = 'Something' THEN CRI ELSE CTY END AS Col1,... FROM dbo.YourTable.

Need I point out that this is the wrong design for the system?

Can you post the final solution so that others may benefit from your work.

TIA.

Then it means you are connected twice to the database.

You can go to the detach database wizard, there's an option to kill all connections there.  You can use that to...

It means that there are more than 1 connection on the database.  You can set the database to single_user, run the backup then back to multi-users.

Or you can manually try...

Might be wrong on the system table used on that script.  Let's just say I didn't try to memorise it .  I usually just use...

If done using enterprise manager, the script generated will create a new table with the corrected design, then copy all rows to that table, then recreate drop the old table...

Are you taling about a derived table??

Select dta.* from (select * from dbo.SysObjects Where Status >=0) dta

If not I'd strongly suggest you let the optimiser figure out the fastest access...

That'll fail if you have foreign key constraints.  You'd need to use delete statements on those tables.  Also you'll have to delete from the child tables first.

I already saw a...

You got my vote.  White paper this stuff.

Potato, potâto.  That will still do row by row processing which is exactly the opposite of what sql server was optimisez for.

What is so complexe in that procedure that sql...

Why can't you rewrite the said sp to process more than one line at the same time??  Would be much simpler to do that way.

BTW, my version will use an index seek (or won't forbid the use of).  But either solution will return the correct data.

As I said, run a job a midnight every night.

Then in the job run a statement like this one :

UPDATE dbo.Logins SET IsInactive = 1 WHERE "Whatever you need...