SA-1 (8/6/2012)

---

I can see situations where, the nightly production loads may need to be loaded to non-production systems every once in a while. In this case, you would need to...

SA-1 (8/6/2012)

---

In our case, Uniqueidentifier / guid's won't work for account_ids.

We could either restore from backup or replicate data or sync using SSIS to instance_2.

I think this should work:

Use Identity...

True, but...

SA-1 (8/6/2012)

---

The issue is when that instance_1 is production only and instance_2 needs both prod and test data. There is the need to maintain the prod ids in instance_2 with...

What is the stored procedure? Maybe if you post that and some DDL for the tables it is referencing, we can help optimize it so that it does not cause...

dj1202 (8/6/2012)

---

After further review, I believe I understand your recommendation now. Are you suggesting that I input NULL or 0 values in the table, for all the location groups that...

SA-1 (8/6/2012)

---

Has anyone had the need to maintain unique identifiers across different sql instances. Any ideas how this can be accomplished?

ex:

tbl_Account has account_id as identity column, however, i need to...

tim.cloud (8/6/2012)

---

Yes, that is the only drawback I could find.

However, I can tell you first hand that it does work, and it's a pretty flexible solution other than having to...

Interesting. Though it seems to be a lot...

o you have a sample article or any information about putting this together? Since they have deprecated Transactional Replication with...

Glad you figured it out.

If you query directly from serverA, is the data updated? How did you verify that your update statement affected data?

Did you open a transaction for the update and not commit it?

We handle this a bit differently, and it depends on your space allowance... We take a backup every night of said database, and then restore it to databaseName_dayOfWeek. We...

Strange... What about the TRACE_PRODUCE_BLACKBOX option?

From BOL: No filename can be specified. The file will be saved as: N'%SQLDIR%\MSSQL\DATA\blackbox.trc'

Don't have time to set one up and test it, but maybe...