Find Users in a Database
This script would help you find users, their logins, roles etc in a database.
2002-04-01
376 reads
Scripts
Detection of Broken Forign Key Relationship
Under special circumstances, it could happen that database contains "orphan" records. Data in dependant table exists without it's "parent" record in a master table. It could be caused by a bulk insert operation without CHECK_CONSTRAINTS option, or by disabling foreign key for a while or adding a foreign key to a table that already contains […]
2002-03-27
257 reads
Script Generator for Triggers
This Stored Procedure creates the script of all existing triggersOptionally it creates the script to drop the triggers too.Triggers may belong to different owners. This procedure takes care of it.In SQLServer Enterprise Manager there is a facility to generate scripts forTables, Views, Stored Procedures etc.But it won't generate script for triggers unless we include the […]
2002-03-27
2,753 reads
spAuditPasswords
This script is actually part of an article written about performing a simple password audit on SQL Server logins when you start to administor a new SQL Environment. The script will scan the sysxlogins table located in the master database for SQL Server logins with no passwords, passwords that are the same as the login […]
2002-03-27
1,590 reads
2002-03-27
2,943 reads
Compare the structure & code of 2 databases
We often make changes in the test databases. But failure in making even the smallest change in the production database may lead to unwanted situations.This utility compares 2 databases.Parameters to be passed @DB1 Database 1 (SysName) @DB2 Databse 2 (SysName) @ShowDifferentOnly see later (Bit) Parameters 1, 2 may include server name as well. […]
2002-03-22
574 reads
Use DELETE On Many Tables With Foreign Keys
When deleting data from many tables, foreign key constraints can force you to specifically order your DELETE commands. This can take tons of time, especially if you have many tables. Here's a technique I use to delete data in the correct order during the restaging of test databases.It makes use of the system stored procedure […]
2002-03-22
1,649 reads
Double Metaphone (phonitic name matcher)
Soundex is not particularly good, So here is a better name matching algorithm.Add an: ALTER TABLE Contacts ADD DoubleMetaphone AS dbo.DoubleMetaPhone(Contacts.Surname)and then you can use this for de-duplicating contact data.
2002-03-21
1,658 reads
Monitor database size
Display disk space, unallocated space in every your database and write resutl in table USED_DISK for analisys
2002-03-19
2,160 reads
Get BCP out for all tables in a DB
The script mentioned below will export data in all tables into textfiles to a physical path on your system using BCP utility from a Database. The sql commands used in this stored procedure are BCP utility,Identity function and temporary tables. Here you required to give 4 input parameters, they […]
2002-03-15
2,253 reads
Blogs
Why companies use Palantir and how we help implement it in the Czech Republic
Palantir is an American software platform that brings together business data from different sources...
Wait… Could This Be the End of Index Maintenance?
While attending SQLCon and FabCon Europe in Barcelona, there were a lot of announcements...
Copilot on the Power BI Report Canvas vs. Modern Report Builder
By James Serra
(This is the second post in a three-part series on how AI is changing...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Packing and Decoding Device Status Codes with LEFT_SHIFT() and RIGHT_SHIFT() in SQL Server
Comments posted to this topic are about the item Packing and Decoding Device Status...
SQL Server Audit Failures
Comments posted to this topic are about the item SQL Server Audit Failures
Question of the Day
SQL Server Audit Failures
If I have a SQL Server Server Audit setup, what are my options for configuring the instance in the event it can't write to the audit log?
See possible answers