Markus (10/18/2012)

If you have the 'Enforce Password Policy' checked and that user then puts the password in incorrectly more...

So that's the only reason for the locking of the login?

I have gone thru the blog. Mine is Win 2003. It says login can be locked out if inputting wrong password continuously for certain times. Also, CHECK_EXPIRATION is off for...

Ok. But this is SQL login and how come Windows password policy will come into effect here.

Can you please help me understand the scenario in detail?

Thanks

Yes password policy is inforced. Is this the cause? If yes, how?

Max and Min memory have been setup and few GBs are left for OS. Clearing up cache is not releasing server memory.

Things are even much slower. So just wanted to know how we can release memory without restarting SQL.

There is a requirement to reset SQL Server memory without restarting SQL Services. And the below commands are not doing the needful.

The T-SQL which I have given above is schuled as a job and report is generated in table format like this.

ServerDriveTotal Space(in GB)Free Space(in GB)% FreeSpace

Server1C:100.0 ...

Thanks for your reply. But I need this in T-SQL, SSRS is not available.

I tested on a table. Dropping clustered index doesn't impact data.

What about data as leaf node of a clustered index conatains data pages?

No such reason. I was going thru some blogs, wanted to dig some more.

Thanks, the query was useful.

We are in the process of retiring unused DBs. These databases and tables were created few years back.

Also, its not necessary that a table should have index.