I wanted the identity column to look like the order the records should have been entered in. Going forward the identity column will work fine since it will represent the...

Adding the clustered index worked. Unfortunately I already had a clustered index on the table as well as many constraints so I had to do a lot of dropping and...

I have tried three of the suggestions against my database:

declare @find varchar(1000),

@sp_prefix varchar(1000)

set @find = 'unitxref'-- enter search string here

set @sp_prefix = isnull(@sp_prefix,'') + '%'

set @find = '%' + @find...

Thank you Mark! I will add this to my list of tools.

Thank you - perfect!

Thanks. That seems to help.

Actually... I have three queries that I am comparing. I have been running them with those two commands in between over an over. I get different times each time (for...

Thank you Frank. Just what I was looking for!

Happy New Year!

Deborah

Thanks for the response. Speed is definitely an issue though. On further study, I did find two databases that did have Auto Close On. I changed both of them and...