The decision on what to make a clustered index is more based on the queries made against the table, not the definition. You would want those queries that look for...

We don't allow deleting of posts, and we're prefer if you figure it out, just post again.

Thanks for the update.

Steve,

We'd love some basic articles on how this stuff works if you're interested. You wrote some great descriptions above.

It's not clear what you are asking or what you did. Please provide more details about what happened, and what commands you ran.

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.