Sometimes you need an audit trigger on a table. I have created a generic trigger that will work for (almost)every table. if the audit table is not there yet, It will copy the table structure (but strip identity attributes) and put all the data in an AUDIT_ table.I believe this will work for almost every […]
2004-09-02
1,614 reads
Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]
2004-06-25
914 reads
This script will create scripts for every database object. This makes it easy to check them in to VSS.Usage : DMOScriptDatabase 'Databasename','Directoryname'
2003-05-19
606 reads
This script will create scripts for every Table. This makes it easy to check them in to VSS.Usage : DMOScriptTables 'Databasename','Directoryname'
2003-05-19
890 reads
A week ago I posted this script. It was a much simpeler version without error checking. Now all the sprocs return the same errors. 0 THERE WERE NO ERRORS -99 UNEXPECTED NR OF RECORDS AFFECTED 0 THE SQL ERROR NUMBER Also with the insert statement the @ID is set. So you can retrieve the […]
2003-02-25
409 reads
This is a script that creates Insert / Update / Delete and Get stored procedures for a specific table.It will only work for tables with a unique primary key.Have a look at what is does, and if you like it, Vote for it. Maybe there are tons of sprocs out there that perform the same […]
2003-02-19
282 reads
Well, ever wanted to know what was happening on disk....You could with FN_vitrualfilestats....Here is a NICE SPROC that samples all databases and puts it in a table. You can choose if you want to Retain values in the table or that it must be cleaned every time the sproc runs.( Put this data in a […]
2003-01-31
925 reads
Sometimes people want a Stored Proc with optional parameters. A lot of times people will use a coalesce for this. The problem with optional paremeters is that the query plan will never be an exact mach for that specific query. ( You never know what paremeters are filled..... )To solve this problem look at the […]
2002-12-06
457 reads
Sometimes it is usefull to log stuff in SQL server while stored procs are running. If a long stored proc runs you sometimes want to be able to log a message in a loggin file. But what if a rollback occurs.... The message is lost as well.Here is a method to set up a seperate […]
2002-10-01
736 reads
I liked the script of using a table as an array. But Didn't liked the cursor in it so I rewrote the script so that it uses a memory table.I tested it in the Query analyzer and this one is indeed faster. So all the people out there yelling that a memory table is faster […]
2002-08-07
1,252 reads
A while back I wrote a quick post on setting up key mappings in...
By Steve Jones
In 100 years a lot of what we take to be true now will...
At Saturday the 21st of February I’m presenting an introduction to dimensional modelling at...
Hello, I inherited a number of tables with like 20-30 column using nvarchar(256) in...
Hi, i'm running vs2022. I'm trying out a c# script that i'd like to...
I upgraded a SQL Server 2019 instance to SQL Server 2025. I wanted to test the fuzzy string search functions. I run this code:
SELECT JARO_WINKLER_DISTANCE('tim', 'tom')
I get this error message:Msg 195, Level 15, State 10, Line 1 'JARO_WINKLER_DISTANCE' is not a recognized built-in function name.What is wrong? See possible answers