Phil Parkin (4/29/2010)

---

Here's your Derived Column formula:

SUBSTRING([Column 1],7,4) + "-" + SUBSTRING([Column 1],1,2) + "-" + SUBSTRING([Column 1],4,2) + SUBSTRING([Column 1],11,13)

This will create a new column with data type Unicode...

Phil Parkin (4/29/2010)

---

Yes there is. You can fire the date into a derived column transformation where you can add a new column which 'derives' a proper date from your date...

EdVassie (4/20/2010)

---

Mirroring can be a useful way to quickly get access to your operational data, but there is a gotcha if you are using replication.

The mirrored instance uses the same...

Thank you Ed, this was a very helpful Case Study.

I think that I have decided to recommend upgrading to 2008 Enterprise and using P2P replication. Do you feel there...

Interesting. Do you find that the sites don't mind it taking 5 minutes to sync up the data once entered? So, if a rep at one site enters...

Actually, these are 24 hour uptime as there is a website that allows clients to create and update records at any time during the day. I was reading up...

Each of the six call centers and the main server all have mirroring enabled locally. I think it comes down to replication now. Would it be best to...

There are 6 call centers and each of them has an identical server that houses their own data that is replicated to the main server each night currently. The...

So I can use mirroring to multiple other servers at once? What about recovery, how would that be accomplished?

My co-worker found this solution that seems to have cleared up the problem.

http://www.dbforums.com/archive/index.php/t-694880.html

Now, if only we knew why it was happening in the first...

I just tried creating a table and it did the same thing...created it as System instead of User.

CREATE TABLE dbo.jacob_test

(First_Name char(50),

Last_Name char(50))

Turns out there were some print drivers that were interferring with the print spooler.  We think it started after one of the Windows Updates was completed.

We had to delete the...

I am on the phone with Microsoft Support.  They have done some troubleshooting and it appears that the print spooler is causing the issue.  Applications are also crashing every time...

If I click cancel it works fine until I connect to a data source and click 'File'.

Product Version = 8.00.2040, SP4, Enterprise Edition

If I am not connected to the data...

First, thank you very much to Newbie!, I tried for months to find something and you answered the question.

I waned to put an example on here, because it took me...