I'd simply run something like this on the server once :

SELECT O.NAME FROM YourDbNameHere.dbo.SysObjects O WHERE OBJECTPROPERTY(O.id, 'IsMsShipped') = 0 ORDER BY O.NAME

Then do myrs.Filter to find a match. ...

Best way to answer that one is for you to make an html page with 2 checkbox with the 2 different values and see what works.

From what I remember of...

So what do you find wrong with that technic (didn't try it, but seems to do the job).

What are you trying to do exacty in that process?  Maybe there's another approach...

Just a thaught from a power user point of view.

You trust this guy with maintaining 5-6 servers.  On which he is an admin.

Now if you can trust if with that much...

I can't imagine the DB design not being protected in some way.  It would seems to me to be like saying that a song is fully copyrighted but that you...

Just make sure you run it with the bit bucket... 250 000 results window can actually kill your local machine .

Thanx for this extensisve testing.  I think we can conclude that those 2 methods are pretty much tied up.

Anyhow just make sure you retest this on your server if you...

Use the bitbucket method... that way you won't have to select and display any data.  That's why I can run half a million iterations in 8 seconds on a 1.3...

Is the cost of dropping the clustered index, before the delete and then recreating it after awards too high?

I need the tables definition to know how to link the code to its code id.  I can't answer your particular question correctly on the first try without that.  Any...

I'm sure it's gonna depend on the license contract and what "they" did.  Are you able to provide a little more details?

I'm not even sure that the table design is correct but that is for another discussion...

You can send the code_id in the access for and hide it from the users. ...

Yup, can't say I like table names with spaces (inherited one system with plenty of those).

Thanx for clearing this out for us.

Ya thanx Sergiy, great little nugget of information on transactions in there.

LOL.