Before bringing it over to your test environment. when you did your back up of your Production db, did you also do a log backup? Or was the actualy...

YES!!! Pam - I've got it! Thank you so much for the development of the logic. I was able to coax one of my developers to help...

Pretty awesome stuff! I like it when I can find things to keep my developers happy, and this is just one of a bounty of goodies I have been...

Very cool report! This one is going into my toolbox!

That's incredibly impressive. I was reconsidering my career and life not that long ago, and was beginning to go back to school to take Pre-Pharm / Business classes. ...

I decided to reformat this script (more out of curiosity than need), but please let the code in the initial post be a lesson to all - this is how...

Hey Pharmboy!

I didn't - it was a guess. I live in Minneapolis / Saint Paul, and it is a Medical Community Mecca here. The U of M has...

Pam Brisjar (3/1/2011)

---

A few more questions for you to make sure I have this...

So your database can be of type "c" OR type "t"

Version can be 000, 001, 002, etc....

For instance...

SELECT m.drugid,

m.ordersetid,

m.orderid,

c.drugid,

...

P.S. If you would like to "Pretty up" the code more - in other words, use the kinds of punctuation that coders do naturally, I have found this to...

PharmD's rule! PharmD's with SQL knowledge DOUBLE RULE!

😀

Found it! Major rookie mistake - I forgot to issue the GO after the END of my trigger. Guess what it was doing? Including some of the lines...

Could it be that this is happening because the version of SQL Server is 2005 Express?

Pam, thank you. I appreciate your's (and everyones) assistance. Here is the script's logic thus far...

USE <database name>

GO

--DROP and CREATE Function to determine the schema version.

IF EXISTS (SELECT...

It already has an indicator called "TheTextValue" where the row is the "SchemaVersion".