Thanx again... seems to be luck of the current load that dictates the results and not the function itself.

I agree that it is more secure that way...  but if the virus can reach is PC, what's stopping it from reaching the other servers?

Also I can't say I'd be...

Ya I saw that too.  The mystery around the plane could be explained with pocket of gas going out of the water.  Pockets that when big enough could sink a...

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. ...