Tagged Questions
2
votes
3answers
388 views
Inserting rows into other table whilst preserving IDENTITY
I'm performing ETL logic on a SQL Server table. I'm going to be synchronizing data from one table to another. For all of the records that need to be added to the target table based on the source ...
1
vote
1answer
104 views
Reset all IDs in a Large Table
Consider a table that contains around 9,000,000 rows. Each row has a int-based "ID" IDENT column whose value automatically increments on each insert. The table undergoes a lot of "churn," that is to ...
1
vote
1answer
91 views
Why is replication attempting to distribute NULL values into Identity columns
We are sporadically getting this error:
Explicit value must be specified for identity column
in our replication environment. I have checked the transaction command that is reporting the error and it ...
2
votes
2answers
765 views
How To Restore A Replicated Database
I am replicating our live database using transaction replication. This is basically to have a backup copy of our database in the case of server failure.
The replicated database is read only, so I ...
3
votes
3answers
278 views
Database Schema with a shared identity Field
I'm a developer treading into the database world so bear with me please.
I'm creating a Contract database with separate tables for various types of contracts.
I have 5 tables but would like to ...
