I was uncertain about the locking going on during a Begin Trans --- commit, but I will try that. I can not revoke rights since our vendor has everyone as...

I thought I did... just tried on the server with 2016 instance installed (only version on this server).. and I am getting a different error.

Integration Services uses CLR...

Uggg.. I made a mistake and was connecting to the wrong QA server... works now.

It is a vendor table and they are just pulling in data... into the table.. and you have no single group of columns that can become a key.. and then...

Interesting... must have been network then... although that is a bit hard to believe.. SSMS did allow me to run sp_whoisactive and return results.. but for some reason this query...

Ok, thanks will try that.

David

No trigger.. I copied the data out ....minus ID.. dropped the table and re-created.. copied the data back in and it is happy now. Still not sure what happened.

Luis Cazares (10/25/2016)

SELECT t.name, c.name, c.is_identity

FROM SCCOE_Order_Progression.sys.columns c

JOIN SCCOE_Order_Progression.sys.tables t ON c.object_id = t.object_id

JOIN SCCOE_Order_Progression.sys.schemas s ON t.schema_id = s.schema_id

WHERE s.name = 'dbo'

AND t.name =...

That is what I understood.. and I think the create table has it set up correctly.. in my opening post.. Here is the error message:

Msg 515, Level 16, State 2,...

Not sure if we should put an index into this database... but the following fixed the issue:

CREATE NONCLUSTERED INDEX [IX_MSRepl_Commands_Art_Pub] ON [dbo].[MSrepl_commands]

(

[article_id] ASC,

[publisher_database_id] ASC

)

INCLUDE ( [xact_seqno]) WITH (PAD_INDEX ...

After an hour I just killed it.. so do not know... I did try three times.

I can run just fine, using the same AD account I used for the publication, if I use windows cmd.

C:\Program Files\Microsoft SQL Server\100\COM>snapshot.exe -Publisher [R2D2] -PublisherDB [Data_Mart] -Distributor [R2D2] -Publication...

It looks like I can set up a table to hold some information: has my main chain of jobs started today, has my daily snapshot written its files, is there...

One issue that I seem to have missed in this stairway.. If you are looking at Transactional Replication... you MUST have PK set on the tables you are replicating.. this...