Viewing 15 posts - 46 through 60 (of 100 total)
You said in your first post that you "restart my agent every day in the morning in the office", but now you're talking about not being there. So, are...
March 25, 2003 at 10:11 pm
Have you checked for Conflicts? Of course this would only be a possibility if the row already existed and was being updated by the subscriber. If these are...
March 25, 2003 at 10:49 am
I get this occassionally and believe it's due to communications failure. Most subscribers are using dialup access. All I do is start the merge agent again and it's...
March 25, 2003 at 6:31 am
On my machine it is C:\Program Files\Microsoft SQL Server\80\Tools\Binn\svrnetcn.exe
Jay Madren
March 24, 2003 at 9:26 pm
Ok, you must have a lot of actual records where RepWeeklyApp.RepID is indeed null. I assumed that it was a PK or FK that would never contain null.
So try...
March 21, 2003 at 2:56 pm
You need the date comparison to limit the rows to those weekends you want. I suspect that you have a logic error in your where clause - probably parenthesis...
March 21, 2003 at 1:54 pm
You need to change the first part of your WHERE clause (before the AND) to this:
(dbo.RepWeeklyApp.RepID = 'CB909B54-7C0F-4908-B059-52B4027326AC' OR dbo.RepWeeklyApp.RepID IS NULL)
Jay Madren
March 21, 2003 at 1:32 pm
At what level are you generating the scripts within EM? If you're doing it for each individual object, then yes that can take a while. But you can...
March 21, 2003 at 12:05 pm
The identity values aren't incremented because of the NOT FOR REPLICATION option. The purpose of this option is to allow the replication agent to specify values for the identity...
March 20, 2003 at 12:05 pm
It sounds like the current identity value needs correcting. Use dbcc checkident('<table>',NORESEED) to check if that is the problem. If it is, use dbcc checkident('<table>',RESEED) to reset it.
Jay...
March 20, 2003 at 10:59 am
Actually, you can simplify this further by using the "Simple" form of CASE. You're currently using the "Searched" form (see BOL). The Simple form of your CASE statement...
February 6, 2003 at 11:02 am
You can generate scripts from your existing publications and subscriptions in EM ("Generate SQL Script..." on the right-click menu). This will give you all the steps to recreate them.
Jay
...
February 5, 2003 at 3:10 pm
I'm sure someone else has a slicker way, but here's mine:
SELECT A.EMPLOYEEID, COUNT_BEFORE_97, COUNT_AFTER_97
FROM (
SELECT EMPLOYEEID, COUNT(ORDERID) AS COUNT_BEFORE_97
FROM ORDERS
WHERE ORDERDATE < '1/1/1997'
GROUP BY EMPLOYEEID
) A FULL OUTER JOIN (
SELECT...
January 21, 2003 at 2:13 pm
Guys, you need to look beyond the problem to what he's trying to do. It's a conversion of # 8KB pages to MB. The final result will always...
January 21, 2003 at 10:36 am
Viewing 15 posts - 46 through 60 (of 100 total)