DO NOT POST HIPAA controlled information on the site. I have deleted the spreadsheet.

If you are seeking help with something from your work, you must use made up data, not...

And is the job running on the schedule and failing? Or just the one failure?

Are you sure the schedule is recurring?

It's not quite clear what your deployment is. And how this locks things.

If you're changing schema, then there's a lock while schema is altered. Most changes can flow through replication,...

I thought the API was included, but it's separate.

There's an SDK

http://www.red-gate.com/products/sql-development/sql-comparison-sdk/

1) I'd use the same database for all customers. If customerA has feature X and customerB has featureY, use separate tables. That way you can easily "turn on" features for...

What I do is more work to setup, but it works great, and handles failures of servers better, IMHO.

I have a db on each instance which is standard. It collects...

Don't use named pipes. Used TCPIP

Reference fixed.

If you're going to a latest schema, you could use SQL Compare from Red Gate. There's an API for scripting, and you could compare to a backup file or even...

Glad to see everyone behaved, and yes, I had a great day on the slopes at Keystone.

Jeff Moden (1/26/2012)

I've not experienced any noticiable...

GilaMonster (1/26/2012)

I've had that. It was followed by almost R10 000 repair bill for replacing the gaskets in...

True, you can use views of synonyms. That might work, although performance wouldn't be great.

For dev/test, it's probably fine.

You have three choices

1. delete 30GB of data

2. move data to separate databases. Meaning either move a portion of data from each table to a new database

3.move certain tables to...

Is that a "yes"?

BTW,...