Viewing 15 posts - 151 through 165 (of 205 total)
Excellent, so close yet so far.
Also, in my actual code I had not propogated the Header Id into the other parts of the union, it din't actually know what the...
March 14, 2006 at 1:09 pm
Another ooption for turning off the triggers is to use the settings for each article in the replication property pages
Right click the publication and select properties
Select the articles...
February 10, 2006 at 10:54 pm
If collation is the same on all databases, then that shuold not be an issue.
Filtering is set up in the actual publication. If you right click the publication and select...
February 9, 2006 at 2:08 pm
I had to play around a little, but substitue your table and column names appropriately and away you go
select
Zeros.[name]
...
February 9, 2006 at 1:10 pm
I believe most of the informatino you need to query exists in the Distribution database. Not that I have any ready made scripts available for you, but in a previous...
February 9, 2006 at 12:36 pm
If I were you I would double check the data filtering you have in place for that subscriber. Typically, SQL Server replication does not get the ordering wrong (at least...
February 9, 2006 at 12:27 pm
I'd be inclined to move the select statment as I mentioned before
something like
CASE WHEN Len(c.FeeSchedule) 3 THEN
...
February 2, 2006 at 4:25 pm
Yo ushould be able to Nest you CASE WHEN statements in a similar fashion that that below.
Hopefully I've provided you with enough of an example to allow you to get...
February 2, 2006 at 2:22 pm
How important it was to find the actual error. That just makes it so much easier to resolve the problem - provided you don't get one of those really ambiguos...
January 23, 2006 at 2:20 pm
Well, now the boss has pulled me away from this issue.
However, the DTC stuff I mentioned just seems to be around ensuring permissions are correctly setup in a multi machine...
January 22, 2006 at 1:18 pm
Yeah, I have all of that from getting it to work on a BTS 2K4 to SQL 2000 setup.
Someone mentioned something about DTC and that has rung a few...
January 19, 2006 at 4:52 pm
I would assume that this failure comes with some error message - but it doesn't appear to be reported.
Have you looked in the SQL logs or the event viewer?...
January 19, 2006 at 1:01 pm
And once it is installed, you connect to it like any other "server" in your management studio. Took me a little while to work this out - doh!
January 19, 2006 at 12:53 pm
Because we don't know what complicated (or not) calculation is in the usp_generate_purchase_order stored procedure, it is difficult to guess at a more efficient solution.
However, if that generation code is...
January 17, 2006 at 2:32 pm
Is it possible that when you went through the wizard, you made the WC column datatype specific?
What I mean is, at some stage do you indicate that WC is anything...
January 16, 2006 at 12:59 pm
Viewing 15 posts - 151 through 165 (of 205 total)