• Interests: SQL, Biztalk, .NET

Technical Article

Create an audit trigger on a table

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 […]

5 (5)

You rated this post out of 5. Change rating

2004-09-02

1,601 reads

Technical Article

Restore Backup and all TRANLOGS in a specific DIR

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 […]

5 (1)

You rated this post out of 5. Change rating

2004-06-25

904 reads

Technical Article

Generate Insert/Update/Delete Sprocs for a table

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 […]

You rated this post out of 5. Change rating

2003-02-25

388 reads

Technical Article

Generate Insert/Update/Delete/Get  SPROCS

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 […]

4 (1)

You rated this post out of 5. Change rating

2003-02-19

269 reads

Technical Article

Log DISK IO statistics per Database file!!!

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 […]

You rated this post out of 5. Change rating

2003-01-31

901 reads

Technical Article

Stored Proc with optional parameters

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 […]

You rated this post out of 5. Change rating

2002-12-06

439 reads

Technical Article

INSERTS that will STAY after a ROLLBACK is issued

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 […]

You rated this post out of 5. Change rating

2002-10-01

725 reads

Blogs

THAT Conference 2024 in Wisconsin Dells

By

I’m headed back to Wisconsin Dells next week for THAT! Conference 2024. This is...

7 Best Online Advanced SQL Training Courses to Learn in 2024

By

The world runs on data, and SQL is the key to unlocking its secrets....

Calling a REST Endpoint from Azure SQL DB

By

External REST endpoint invocation in Azure SQL DB went GA in August 2023. Whereas...

Read the latest Blogs

Forums

Thinking About Technology

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Thinking About Technology

SQL Server on Linux Restrictions

By Steve Jones - SSC Editor

Comments posted to this topic are about the item SQL Server on Linux Restrictions

Error fetching data via Linked Server

By Ram

Hi, SS ver: SS 2017, SE; Oracle: 19.23 SE We have a nightly job...

Visit the forum

Question of the Day

SQL Server on Linux Restrictions

Which of these features are not available on SQL Server on Linux? (choose 2)

See possible answers