Script foreign keys
Using this script you can create a list of sql commands for foreign keys manipulation.
2012-01-10 (first published: 2007-11-02)
4,839 reads
2007-12-12 (first published: 2007-10-12)
2,035 reads
How to empty database
Sometimes you need to empty the content of database. Following script can do that for you.
2007-10-15
4,423 reads
Blogs
How to get the Active Directory user password policy values
By SQLPals
Recently I have had to troubleshoot quite a bit of SQL login issues and...
How do you use PowerShell toc check if an active directory user locked out, disabled etc.?
By SQLPals
If your organization uses a password policy (there are very good odds these days...
DBA Myths: The system sessions are the ones with a session_id 50 or less
Anecdotally any session_id that’s 50 or less is going to be a system session...
Forums
Numeric and Decimal
Comments posted to this topic are about the item Numeric and Decimal, which is...
Monitor / Alert PII fields - Best 3rd party tool?
I have been tasked with finding a new tool for Database Activity Monitoring. We...
Trigger store procedure with a file in SQL Server
Hi, Will receive a JSON file from an application on to D drive D:\tmp...
Ask SSC