there is no direct way... this is a workaround
Alter login [test1] with CHECK_POLICY = OFF
go
Alter login [test1] with CHECK_POLICY = ON
go
Friday, May 25, 2007
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
I am an Ex-Sailor from Indian Navy who possesses rich experience in Microsoft SQL Server. I would take this opportunity to pay tribute to all those who serve their country with pride, always keeping “Service before Self”.
About Me
- Madhu K Nair
- I belong to a small village called Cherumundasseri in Pallakkad District of Kerala,India the “Gods Own Country”. I am proud for being an Ex-Sailor from prestigious service of Indian Navy. I owe to Navy for giving me a world class training and a platform to apply my knowledge.
Blog Archive
-
▼
2007
(39)
-
▼
May
(7)
- SQL Server 2005 Performance Dashboard Reports
- SQL Server 2005 Integration Services Guided Tours
- How to unlock the user with out password reset
- SQL Server 2005 Deployment Guidance for Web Hostin...
- FAQ : How to change Authentication Mode in SQL Ser...
- Third party Tools for SQL Server
- Optimizable SARGs in SQL Server
-
▼
May
(7)
Labels
- Advantage of Disadvantage of Table Partitioning (1)
- ALTER Database (1)
- Data import (1)
- Excel 2007 (1)
- FAQ (37)
- Guidelines for table partitioning (2)
- Horizontal Partition (1)
- How to create files from images stored in database (1)
- openrowset (1)
- Table Partition (6)
- Vertical Partition (1)
- WITH NOWAIT (1)
- WITH ROLLBACK IMMEDIATE (1)
Posts
No comments:
Post a Comment