Gail et el;

To my discovery there IS another backup process taking place. This time by the the host provider. I was unaware of this, but...

OK, well here is something interesting... It appears that I can load ...20110520170000.trn and nothing beyond it. Odd. Any suggestions?

--==================

Processing E:\dbtransfer\CONX_Prod_20110520163000.trn

RESTORE LOG [CONX_Prod] FROM DISK =...

Nope... that was my first thought too. Thanks.

Thanks... I'll keep poking at it.

Kurt

The approach I took was what I previously described. I wrote a function that looks for the elements of the data tag and stores the result into a table...

🙂

You have to admit that is so lame.... FYI I've posted this bug on the Microsoft support website. Thanks for your suggestion.

Kurt

Yes, in fact I tried everything. What I noticed is when I simply go to print the page breaks shift (or maybe the entities move to the to the...

That is exactly what I did and it works like a charm. Although not the design I was hoping for I don't think there is going to be much...

This new application has a set of static tables (for the most part) that I'd like to keep in a separate database rather than have copies of them in the...

What, if any, would be considered disadvantages for using table triggers to provide RI across different databases? I am presently designing a new system and was thinking of pulling...

Adam Seniuk (12/8/2009)

---

Actually the CTE uses the table indexes quite nicely, just review the query plan and you will see it pulls the indexes from the table. (Most of the...

CTE's have their place as long as you are not dealing with a large volume of data. One of the problems with CTEs is performance tuning. Unless I'm...

Here is my spin on this. First, I can appreciate the effort taken forth here. Anyone who has been in a DBA role for any period of time...

You are probably correct. When the company that I was working for was acquired all hardware were handled in another office 2000 miles away...

Thanks for your comments.

Kurt Zimmerman