Jeff...got it.

Grant,

Got it. Good advice about testing from all.

And it looks like I can us ALTER to create a non-clustered index after the table was created.

Grant,

I think that is what I am doing.  The primary path AFTER sign in is by UserId - the identify column. However, at sign in it looks for the User...

Scott, fyi...I do have a clustered index defined for the column that is the primary key - an IDENTITY column.

[UserId] [int] IDENTITY(1,1) NOT NULL,

CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED

(

[UserId] ASC

)WITH (PAD_INDEX...

I agree I can try it...but I was looking for best practice when doing lookups on a table that already has a primary index and hence a clustered index.

If I...

We ran a Windows update and did a reboot and it fixed the problem. Thanks to all though for your input.

We ran a Windows update and did a reboot and it fixed the problem. Thanks to all though for your input.

Looks like their is an update missing. We will apply that and see if that resolves it. Will let you know. Thanks for all the suggestions.

Stephanie,

1.) I added the code to loop threw the SqlErrors Collection.

But all I get is: Index #: 0 Error: System.Data.SqlClient.SqlError: A severe error occurred on...

Phil,

Yes, I tried increasing it to 2 minutes. But it still fails after the 3rd poll.

Yes, I redesigned the logic so that it uses a "table valued parameter" passed to...