As Robin points out there is no built in way to make sure users have strong passwords when using SQL authentication. There are a couple changes you can make (with appropriate warnings!) that will allow you to do this. Read on to find out why and how.
2004-03-02
6,649 reads
This script will display the defragmentation of table(s) all indexes of selected tables and display a table/list of the DBCC SHOWCONTIG. It will aslo will report if there are tables in the list that can't be found in the current database. Run the script in the database where the tables you want to check are.Check […]
2003-08-21
780 reads
Don't like the blackbox approach of maintenance plans? Like the maintenance plans but need a tweak to suit your needs? New author Robin Back has put together a monster script to allow you to build your own quickly and easily.
2003-08-20
9,763 reads
I manage quite a few hundred databases across the company. Time to time I get a question if I can check wheather a database is beeing used or not, and if it is, by whom?There are probably a 1000 ways to do this, but I've created a script for creating a scheduled job that runs […]
2003-07-15
2,648 reads
Full documentation on the Undercover Catalogue can be found HERE It’s been a while...
By DataOnWheels
It was awesome to see the Kentucky data community come out for the first...
Hi all, We have a lengthy process that uses 30 tables, some of them...
All, I'm trying to find a way to let some of our users see...
Hello, I have a script that was running really long, and I have found...
Can I create In-Memory OLTP tables in SQL Server Express?
See possible answers