Viewing 15 posts - 3,736 through 3,750 (of 6,216 total)
We're a pretty good natured crowd. No one minds a little fun here as long as we dont stray too far off track (you did not) - one of our...
July 18, 2002 at 11:25 am
SQL creates a set of procs for each replicated table on the subscriber. You seem to be missing the update one. You can replace it manually, just follow the syntax...
July 18, 2002 at 9:59 am
You can replace xp_sendmail with your own proc - sp_sendmail or whatever, that uses CDO. Probably have a script here on the site.
Andy
July 18, 2002 at 8:41 am
July 18, 2002 at 8:40 am
Totally understand. We've separated our data here by client as well, but we have more than 200, which rules out unions! Right now we run a process at night to...
July 18, 2002 at 8:30 am
I think 10+ db's is a lot to union. If you have real reasons for keeping it separate it's that or Steve's note about just doing it in code. It's...
July 17, 2002 at 10:51 pm
Have to ask - why do you care? If you just want to send the minimum data over you can let ADO do the work for you with a recordset,...
July 17, 2002 at 10:48 pm
As long as it's not an indexed view then the storage used is very small, just what it takes to describe the view.
I believe that views can and should be...
July 17, 2002 at 10:47 pm
Or you can do the update in a proc and explicitly return the record count via an output parameter. Either way I think the count is the number of rows...
July 17, 2002 at 5:29 pm
Batch size is a param of the distribution agent. It's a bandaid fix unless you have a really slow link. Im doing ok with defaults over a 256k line. Have...
July 17, 2002 at 5:26 pm
Doesnt have to be same server, you just have to have a linked server set up pointing to whereever it is.
Andy
July 17, 2002 at 2:49 pm
One other thing, have you updated all your stats since upgrading?
Andy
July 17, 2002 at 2:48 pm
Blocking on the subscriber? Heavily indexed and timing out because of it? Might try adjusting your batch size...after you research further. Lots of changes up front make it even harder...
July 17, 2002 at 2:48 pm
Antares, can you tell me more about how/why set rowcount is faster? My preference is for Top N constructs unless I have a situation where N is variable, not often...
July 17, 2002 at 2:46 pm
Can you post the code? No reason the file you retrieved shouldnt be exactly what it was when you stored it.
Andy
July 17, 2002 at 2:44 pm
Viewing 15 posts - 3,736 through 3,750 (of 6,216 total)