The 309 version returned no result, it did not give an error, but it returned a blank string. I did not have the time to debug it, so I used...

After 24Hrs of coding and searching for alternatives I almost gave it up but I finally get the DDL and previousversion DDL in a trigger working.

I have got it working...

Thanks for the credits, but my input was only a few lines of code:)

Your defenitely fast, thanks for providing the updates; I am working on an auditsystem

where you can combine...

Thanks for this script, it has been a great help!

I extended the script with a few lines and now it returns also the DDL for views, procedures and functions.

--############################################################################## ...

Same but now untill datetime:

-- RESTORE FULL BACKUP

USE MASTER

RESTORE DATABASE [AdventureWorksDW] FROM DISK = N'c:\BackupFullAdventureworks_20100119.bak' WITH FILE = 1, NOUNLOAD, STATS = 10, norecovery

GO

RESTORE LOG [AdventureWorksDW]...

Pro's,

Today I've got a PM about this subject.

I worked out some sample for a PIT-restore. I'd like to share this to you all:

Poin in time (Marked transaction)

-- MARKED TRANSACTION

--GO BACK...

At first, many thanks for your reply. I hope you didn't break your head that hard:)

I changed my script in:

Code:

--create testdatabase

USE MASTER

DROP DATABASE VINCENT

go

create database vincent

USE [master]

GO

ALTER DATABASE [vincent] ADD...