Tagged Questions
1
vote
1answer
346 views
Copy SQL table to other server identity becomes int
I just built an Umbraco website. This uses a not-that-small SQL Server db. I copied this DB using the export data function built in in SQL Server 2008.
This copies all the tables and their content ...
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
767 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 ...
2
votes
1answer
131 views
Dropping then adding a table to a subscription with Identity option Not for Replication causes errors
We have a Transactional Replication environment that was initialised from a backup that replicates the data for several hundred tables.
When a table is altered, say a new column added, I have created ...
