Viewing 15 posts - 16 through 30 (of 284 total)
Uggg.. I made a mistake and was connecting to the wrong QA server... works now.
October 27, 2017 at 1:15 pm
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...
May 3, 2017 at 2:56 pm
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...
November 21, 2016 at 12:52 pm
Ok, thanks will try that.
David
November 9, 2016 at 8:16 am
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.
October 29, 2016 at 9:28 am
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 =...
October 25, 2016 at 2:51 pm
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,...
October 25, 2016 at 11:31 am
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 ...
October 17, 2016 at 11:27 am
After an hour I just killed it.. so do not know... I did try three times.
July 5, 2016 at 9:18 am
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...
June 20, 2016 at 11:55 am
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...
May 26, 2016 at 8:46 am
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...
May 24, 2016 at 12:36 pm
Reading through this .. so we can set up replication from the data warehouse to the various app db servers. Once question that jumps out at me is the effect...
May 24, 2016 at 12:32 pm
I have not set it up yet.. so the type could be any... what I am looking to do is to kick off a pull, then move forward with all...
April 18, 2016 at 2:18 pm
if you are needing a Pull.. is there a way to tell when the data is now up to date, so that other jobs can now run? (that process the...
April 13, 2016 at 12:49 pm
Viewing 15 posts - 16 through 30 (of 284 total)