The latter... I don't know how to get the 2nd information dynamically.

Can't know if that index is not a constraint (primary key or unique). There's just no information about that on indexes.

That's why programmers invented categories .

I missed it too at first . But you have the best solution yet... you just have to make a small correction...

Sushila would have spotted that typo right away. I was saying "I don't care" and "I'm not making a case out of this" in the same sentence

The only date information about indexes can be found this way :

Select Name, CrDate from dbo.SysObjects where name in ('Primary key name','Unique constraint name') and XType in ('UQ', 'PK')

This...

Here's your answer for number 2 :

IN QA :

Create proc dbo.Test @Param as int

as

select @Param * 2

go

in VBA :

Sub x()

Dim MyCmd As ADODB.Command

...

Yup, and I don't care .

Try the query like this :

Select * from dbo.SysObjects maxdop1

HTH.

HTH.

check out SET STATISTICS IO too .

I was your number one before that... things change .

I'll plead the 5th on this one.

Still guessing without the code??? I'm gonna have to have a little talk with your mother, or boss about this .