Looks like my font was wrong :

3) Listen to Noeld and try to find a set based approach for this.

What is the goal of that stored proc?

You don't seem hth .

declare @id

exec usp_addtest 'bob', @id output

There's less irrelevant (in this case) information in sp_helpindex .

I suggest you immediatly fameliarize yourself with sp_who2, sp_lock and dbcc inputbuffer(spid), you're gonna need it.

Don't come back running here when it fails.

Or a best version to rule out the query completely :

exec sp_helpindex 'TableName'

HTH.

And maybe the developpers who dare to work with that... unless they have no other choice.

Change the function

from

AND XType NOT IN (34,35)

to

AND XType NOT IN (34,35,36)

If you don't have any row in SysObjects of type PK, then you have no primary key in that database, you could also extend the search to 'UQ' for...

As I said, research only for procedural approach when no set based approach exists (or works at reasonable speed). Sometimes it's faster to use a cursor, but it's just...

I'm glad it's not for simple a_understandable procedures .

You can always do this :

Dim MyForm as Access.Form

set MyForm = Application.Forms("FormName")

MyForm.FkClient = SomeValue

...

while (@id is not null)

begin

select @id = min(id) from table where id > @id

Update Table set SomeField =...