What i've done is load the file into a single column table. Then count the occurance of the | delimiter. If it is not equal to the number...

That's close to the path i am on. Challenge? 49 files. 15 wider than 80 columns. :ermm:

Blasted vendor! :angry:

I agree, fixing the source is the ultimate solution. Unfortunately the source is an outside 3rd party who has been quoted say "The specification is more of a guidline."...

Derrick Smith (10/1/2010)

---

You _might_ be able to shut down the server, copy the data files of the mirrored db, bring it back up, and then try to attach the new...

We've tried that, but unfortunately the snapshot can only be used to revert / restore the database it was created by.

We also tried breaking the mirror, restoring the tail of...

AFIK they are using the native client, but the app is written a little odd. There are a lot of hard coded values instead of looks, etc. I...

I like the idea of failover, backing up, then failing back. unfortunately it take ~4.5 hours to backup the database. And it must be available 24x7 except for 2...

Here is a script I wrote to find out what logins were on my server(s) and what roles those logins belong to. It also will so if the user...

Thank you all for the responses.

Unfortunately, a test envioronement will not provide any impact as this is a user in the finance department building his own reports, and he thinks...

2) I cannot change the structure of the production database. I have a nightly ETL that migrates the data from production to a reporting database.

1) I am looking...

Yes, we are running on Enterprise Edition.

The long term view is to preaggregate the data and roll it into an SSAS cube. But the business needs info now. ...

I reverse engineered the database using Visio's built in tools. Then as changes are developed they are first added to the model.

When I started here the first thing I did was model the DB, as one did not exist. Fortunately we have Visio 2007, and I was able to reverse...

That solved it!

The 2 servers were running under different service accounts. Once i correctly supplied the account names the mirror established.

Thank you all for your assistance.

Greg

The following message appears in the error log.

Database Mirroring login attempt by user 'DOMAIN\User'. failed with error: 'Connection handshake failed. The login 'DOMAIN\User' does not have CONNECT permission on the...