Viewing 15 posts - 1 through 15 (of 41 total)
Oh! Okay, running that did show me the other object and it is indeed on another database.
I see exactly what happened now. When these databases were created on the new...
August 16, 2011 at 1:10 pm
Thanks for the input. I am running the query now and of course it's taking a while. In the meantime, however, it's probably worth noting that I had already done:
SELECT...
August 16, 2011 at 1:00 pm
Thanks very much. I actually did end up deleting the subscription and publication, disabling publication/distribution, and setting everything up from the beginning again. Then it worked.
August 4, 2011 at 12:54 pm
Perhaps I am missing something, but this seems to handle everything on the database level. I am looking for server-level scripting as well.
June 27, 2011 at 2:37 pm
Thanks so much for the input everyone. As it turns out, it didn't like the table variable I was putting my parameter values into. I decided that before I declared...
June 9, 2011 at 7:53 am
Skott Shores (6/9/2011)
SELECT t.FieldId, t.FieldDescription
FROM dbo.Table AS t WITH (NOLOCK)
WHERE t.Active = -1
ORDER BY t.FieldD
could be bringin back dupes....
June 9, 2011 at 7:37 am
Thank you so much for your feedback. But I think I'm confused. I was trying to make sense of this in your previous posting, but I'm not sure it applies...
June 9, 2011 at 6:38 am
Can I bring this topic back to life? I'm trying to figure out if any of these suggestions will work for me since I'm having the same problem, but it...
June 8, 2011 at 12:46 pm
Ninja's_RGR'us (5/26/2011)
Vicki Peters (5/26/2011)
Ninja's_RGR'us (5/26/2011)
Vicki Peters (5/26/2011)
If it's a UNION of several inserts, then wouldn't it all have to be inserted at once?
Union or union all? That could make...
May 26, 2011 at 2:29 pm
Elliott Whitlow (5/26/2011)
My first thought was locking/blocking do you see anything in the Activity Monitor?Having increased the DB sizes tends to take growth waits out of the equation.
CEWII
Oh my God,...
May 26, 2011 at 1:00 pm
I will look into both options. It seems, though, at this point, the problem is bigger than a single sproc. This job is hanging at every step, even though I've...
May 26, 2011 at 12:33 pm
Ninja's_RGR'us (5/26/2011)
If it gets stuck as you say make sure you're not waiting on db growth (could be tempdb too).2M is not a big insert for sql server!
I did check...
May 26, 2011 at 12:05 pm
Elliott Whitlow (5/26/2011)
May 26, 2011 at 12:01 pm
Ninja's_RGR'us (5/26/2011)
Vicki Peters (5/26/2011)
If it's a UNION of several inserts, then wouldn't it all have to be inserted at once?
Union or union all? That could make a hell of...
May 26, 2011 at 12:00 pm
If it's a UNION of several inserts, then wouldn't it all have to be inserted at once?
May 26, 2011 at 11:25 am
Viewing 15 posts - 1 through 15 (of 41 total)