Why do you need that "ordering" ?

May I suggest you use a separate table to account for the IDs.

No lock will be needed watsoever!!!

Cheers!

r u using him as Scarecrow ?

>> Has sysname always been an Nvarchar datatype?  <<

YES it always have been nvarchar(128). SQL Server 7 and up are designed to support unicode named objects

Cheers!

It may not be that terribel if  it is as sswords said:

"Alright buddy, be quiet or I'm going to have to slap the 'wives' on you!" 

bad would be

"Alright buddy, be...

Wow, too many big things in too little time !!!!      you don't need any drug

I think you should pay a bit more attention at the thread because all solutions were based on that:

....

select name from #a where id % @Sample = @Offset

...

Select...

>>... replication is being performed to a database that can be used on the extranet.   The data in the extranet is were the LAt Long resides..... <<

If you are trying...

Yup, sometimes one has to look at the process as a whole and led the process determine the architecture and not the other way around!!

4000 is for that next AGREE 

OK the right approach is that you call the WEB service BEFORE you do the insert! then you don't need the trigger

Triggers should be used in short (not lengthy ) jobs. You need to re architecture your solution to minimize Trigger time!!

Also can you post what are you trying  to accomplish?

When you use splitted Access DB every time you change the BE path you need to use the "Linked tables manager"  to refresh the location of it ( or do it...

OR

Create a numbers table with several mod values( the most common hope fully is not that many ) by each number, pin it and...

That works well for "STANDARD" kind of queries. When variables are used in the update and double assingments are in the game I am not really sure if something is...

Drop the Tables TOO!