Thank you all for your time. If the login has the "Enforced password policy" checked then if the windows server has a value under LocalSecurityPolicy\SecuritySettings\AccountPolicies\AccountLockoutPolicy\AccountLockoutThreshold

then the login will take on...

Hello Ninja,

Thank you for your response. I will take it as there is no such thing as locking the SA account after # of logins in...

A security company is trying to use sa account to hack on to our sql server and they say after 6 tries it locks out the account. My question is,...

Hi GSquared,

Why didn't I think of that? You are a true SQL developer. Thank you for your time.

Hi Ten,

That is a great idea, except that I have a variable in the order by clause like:

ORDER BY d.PurchaseOrderQty ' + @OrderBy + ' ,UserNumeric1'...

Hi SS,

The rest of the code is as you can assume:

END

FETCH NEXT FROM RandomUser_CURSOR INTO ...

Mahesh,

Sorry I did not see your post earlier. The problem was that I am using Microsoft Applcation block and it was timing out. So as soon...

Mahesh,

Thanks for your response. The err: label looks like following:

err:

print @Step

I am debugging the Stored proc and stepping thru line by line. As soon as there...

Thanks, SSRookie.

Thank you, that worked.

Matt,

This is exactly what I thought, but since this is automatic, I don't know what to do. The reason for me to use ADODC is so...

There is no way I can disable the PK, the DBA will kill me.

Keith,

Like I wrote earlier, if I fill the primary key column in the grid and then click on row above of below the current row then...

Shamsudheen,

Thank you so much for your prompt reply, I have to fix this issue urgently. Here is my stored proc

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE Procedure [dbo].[DS_GetProductsByFilter]

@FieldName...

Shamsudheen,

Thanks for your reply. You are correct in your understanding. I cannot directly connect to a table because it is a join query.

Thanks,

Ram.