Tagged Questions
0
votes
3answers
121 views
Merge Replication identity field issues
One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
5
votes
1answer
145 views
Getting Identity values to use as FK in an INSTEAD OF trigger
I have a series of updateable views we are exposing to end users as the interface for a back end process.
One of these views references two tables and requires an INSTEAD OF trigger for UPDATE and ...
1
vote
1answer
344 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 ...
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 ...
