Can you give me the exact example? The row number is arbitrary depending on how you sort so this seems like an odd thing to do. I have...

Is the 100 to 150 a field that you can reference in your table or are you talking simply row numbers? If you have a field just create a...

To find objects with name > 30:

select *

from sysobjects where len(name) > 30

and name not like 'sp_%' --eliminates system procs as long as u dont use sp_

to find columns >...

Take a look at BOL on the topic "OPENROWSET". I think this is what you are referring to. Ad hoc queries on different servers.

Darren

Do you have the user name field on each table that you need to filter? If so, you could use a stored procedure that passes in that username when...

I'm not sure about the nesting you are using? You simply select and then subselect with no qualification? What is this query supposed to do or is it...

Also, right after you insert into that table the last IDENTITY created is stored in @@IDENTITY variable. You could use that as a return value from your insert proc.

Darren

Also, is the update changing a field in the primary key? That could cause the dup insert.

Darren

I would do an IF EXISTS on the primary key before you do the insert.

Darren

Try setting a trace event (sp_trace_setevent)

using the column_id = 18 which shows the CPU time. Would that help?

Darren

Could you paste the chunk of vb code that is rolling back, I need to see in order to understand this scenario.

Darren

Did you try sp_who2 to see what is running?

Darren

Try something like this.

select b.* from syscomments a, syscolumns b where

a.id = object_id('YourStoredProcName) and a.id = b.id

Darren

The front end will have to change in that you will have to specify a new connection string to the SQL Server. That is if you are using ADO....

Do a sp_helpindex on your table. The "index_keys" column will have a (-) next to the column that is descending, otherwise it will show nothing if ascending.

Darren