Please don't edit posts to remove everything. It's rude and looks bad.

Closed post.

You can even use the "START" command in a command prompt to spawn a process, or you could use DTS and execute the restores in parallel.

You do need two different...

So check and be sure that TCP/UDP 1433 and 1434 are open. I think UDP 1434 is the browser to enable you do connect.

If you can make an ODBC...

I like Pradeep's solution. If allows you to do other maintenance if you wanted to rebuild indexes/statistics, obfuscate data, etc. while keeping people out. you could also send a message...

Be sure that you check the Windows Event Log (System) to see why it didn't start. There should be an entry that gives you a reason.

You can use three part naming, database.schema.table to reference the other database. The write an insert select statement.

If you try and have issues, we can help, but we don't do...

The timestamp column isn't there to be a unique identifier. It's a versioning stamp in the database that some applications use to determine if something has changed in the row.

As...

Please don't cross post.

Closed thread. Answer here: http://www.sqlservercentral.com/Forums/Topic755298-149-1.aspx

Do you mean solo contractor? I haven't seen a lot written from the IT perspective. Have you ever contracted for someone? Meaning working for a consulting company? I'd say that...

It's not scalable for sure.

You are trying to keep in sync surrogate values that are acting as primary keys. However you are not generating them with in any realistic way....

For now I would set the model DB to the simple recovery mode and read only. Something will start throwing errors when it can't write to the database.

What you probably want for complex lookups is an SSIS package that moves data from server A-> B. Then another package to move from B->A. However you'll need to somehow...

I think you are missing files or the download was corrupt. There isn't much we're going to be able to do if you don't have a good download.

You can write a query or view to change data around and handle some simple transformations.

Without knowing more about what you mean, it's hard to recommend something.

I think anything you...

Replication will do this, and you can transform the data somewhat on either side.