Scripts

Technical Article

Stored Procedure to Backup all Databases

This is the script I use to backup all my DB's this does fulls and dumps them locally to disk then spools them off to FTP. This stored procedure is designed to take 4 parameters @bksrv : This is the name or the IP address of the spooler or backup server to send to. @user […]

5 (1)

You rated this post out of 5. Change rating

2001-09-06

4,542 reads

Technical Article

Script to obtain datadictionary from a SQL2000 db

This script creates a stored procedure that, when executed, queries the system tables of any SQL2000 database to return a complete, ordered datadictionary. *Warning**This script only works on tables which have the description property filled out as my main purpose was to query the extended property description feature new to SQL2000. If you have not […]

You rated this post out of 5. Change rating

2001-08-27

3,112 reads

Blogs

5 Free Data Analysis Books to Kickstart Your Career

By

Dreaming of a data analyst career but feeling a little lost? Already playing with...

PostgreSQL error in Fabric Pipelines – No pg_hba.conf Entry for Host

By

I came across a bit of a weird error when I was trying to...

How I Effortlessly Dockerize Python-Based AWS Lambda Functions

By

As a Software Engineer, i would like to learn how to dockerize my Python...

Read the latest Blogs

Forums

Is Perfect Software Attainable?

By Louis Davidson (@drsql)

Comments posted to this topic are about the item Is Perfect Software Attainable?

SQL DB migration

By ShuaibV

Hi I am New To Azure Sql.  Can some one please share  If we...

Contained Availability Groups - Failover Questions.

By krypto69

Hi I am considering creating Contained Availability Groups in my production environment. Thinking I...

Visit the forum

Question of the Day

Multi-Database Marked Transactions

I run a marked transaction across multiple databases with this code:

BEGIN TRAN onemorenewdbTran WITH MARK 'mark from 3 dbs'
USE sandbox2
INSERT dbo.AddressTable
  (AddressID, AddressValue, AddressPostal)
VALUES
  (12, '123 three St', '4444')
GO
USE sandbox3
INSERT dbo.Logger (logdate, logmsg) VALUES (GETDATE(), 'tran message')
GO
INSERT sandbox4.dbo.logger (uid) VALUES (700)
COMMIT TRAN onemorenewdbTran
GO
How many marks are inserted into msdb.dbo.logmarkhistory?

See possible answers