tag:blogger.com,1999:blog-6082652835152798567.post7451773469525831371..comments2024-03-28T00:58:12.736-07:00Comments on Sql server, .net and c# video tutorial: Unlocking the locked user accounts - Part 94Unknownnoreply@blogger.comBlogger9125tag:blogger.com,1999:blog-6082652835152798567.post-92137523452994490342020-07-23T01:11:23.848-07:002020-07-23T01:11:23.848-07:00SQL SERVER AGENT will available in ssms if we run ...SQL SERVER AGENT will available in ssms if we run as admin.Anonymoushttps://www.blogger.com/profile/17726945071366720430noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-87717480467771318182018-04-24T07:36:34.720-07:002018-04-24T07:36:34.720-07:00SQL SERVER AGENT is not available in ssms Express ...SQL SERVER AGENT is not available in ssms Express edition.....Anonymoushttps://www.blogger.com/profile/04089128183241571688noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-19692224259126770122015-12-12T09:13:26.984-08:002015-12-12T09:13:26.984-08:00Dear Sir,
Thank you Very Much
Sir,
I want to cre...Dear Sir,<br /><br />Thank you Very Much<br /><br />Sir,<br />I want to create a SqlServer Job, But i dont find SQL SERVER AGENT in my SSMS.<br />Please Help.<br />Thank youCasperhttps://www.blogger.com/profile/03479887327944898427noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-4024373441137838532015-01-15T10:09:02.996-08:002015-01-15T10:09:02.996-08:00dear arvin , cheak the store procedure u created m...dear arvin , cheak the store procedure u created may be u set the returncode=1 instead of -1.<br />if (@count=1) then select returncode=1 else select returncode=-1Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-42487916569078718612014-08-13T05:30:07.497-07:002014-08-13T05:30:07.497-07:00Dear Sir,
Thanks to your videos, they are very hel...Dear Sir,<br />Thanks to your videos, they are very helpfull and also interesting.<br />I want to use master password instead.<br />Means if any user's account is locked and he enters master password in password field then it should unlock his account.Anonymoushttps://www.blogger.com/profile/09675639828163514033noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-60317628777641456742014-07-22T02:33:11.805-07:002014-07-22T02:33:11.805-07:00Hi venkat sir is anyother way is there to unclock ...Hi venkat sir is anyother way is there to unclock the user namerajath chowdhryhttps://www.blogger.com/profile/05023844850579293837noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-62748961816067655112014-05-01T18:12:18.367-07:002014-05-01T18:12:18.367-07:00Hi Arvin,
Check for a valid Username against the ...Hi Arvin, <br />Check for a valid Username against the database first and then check whether the account is locked or not. That should take care of the issue. <br /><br />Alenoreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-18273235870237838992014-01-17T06:50:06.864-08:002014-01-17T06:50:06.864-08:00Dear Venkat, Can you help me with my problem in th...Dear Venkat, Can you help me with my problem in this tutorial,<br />WHEN I ENTER WRONG USERNAME IT LOCKED THE ACCOUNT even if the account is not register,,<br />tnx more power!Anonymoushttps://www.blogger.com/profile/17672616755956794165noreply@blogger.comtag:blogger.com,1999:blog-6082652835152798567.post-50569517289559072013-02-03T15:13:31.918-08:002013-02-03T15:13:31.918-08:00Venkat,
I look forward for your videos everyday....Venkat, <br /><br />I look forward for your videos everyday. You are doing great job. Keep up the good work.<br /><br />Regarding this topic: Wouldn't SQL Server Policy Management be another approach to resolve this issue. This way we can set the security policy to be 3 attempts across all the databases in the enterprise and also set up unlock rules to remove the lock if it is past 3 attempts. Just a thought.<br /><br />Thanks,<br />LisaAnonymousnoreply@blogger.com