Viewing 15 posts - 3,796 through 3,810 (of 6,216 total)
Declaring it as inputoutput should work. Have you verified that your proc is working by adding a print after the set? Also, if you have SQL2K a better method is...
July 12, 2002 at 5:44 am
Adding the columns using a standard alter wont affect your pub at all. Trigger works as Robert describes regardless of how many rows it modifies.
Andy
July 12, 2002 at 5:31 am
Sorry, how is that better? By declaring as object you're late binding AND you lose intellisense??
Andy
July 12, 2002 at 4:55 am
I've used it like that with no problems. Sure the service is still running? Is it installed as the default instance or named? On the default port? How about running...
July 11, 2002 at 4:27 pm
Normal way is to use insert into ...exec proc, where the target is a temp table. I think you can also open the proc via openrowset and treat it as...
July 11, 2002 at 4:25 pm
Stored procs can return multiple recordsets, using ADO pretty easy to loop through them and use. Only thing is that you have to refer to the recordsets by ordinal position,...
July 11, 2002 at 3:11 pm
Havent seen it. App breaks or the grid control? Which grid are you using?
Andy
July 11, 2002 at 2:28 pm
July 11, 2002 at 2:27 pm
Once you've built the string should just be a simple call to msgbox, like this:
Msgbox strError
Andy
July 11, 2002 at 2:25 pm
Try http://www.vb2themax, http://www.fawcette.com (VS Magazine), http://www.codehound.com. Probably the MS newsgroups too.
Andy
July 11, 2002 at 2:24 pm
Replication in mysql sucks. Subscriber has to have access to the transaction log. I can certainly understand the cost factor. Agree with Steve on the rest. Paying per processor is...
July 11, 2002 at 2:24 pm
Yes, you should normally have the -continuous flag on. Im confused about the rest. You're saying its the subscriber log that is unshrinkable? That shouldnt have anything to do with...
July 11, 2002 at 2:22 pm
In general there is no reason for the log reader not to complete. Is it stopping due to timeouts, or getting behind because of large or large numbers of transactions?...
July 11, 2002 at 10:51 am
Is the log reader running continuously? Transactions cant be cleared from the log until the log reader processes them.
Andy
July 11, 2002 at 9:45 am
July 11, 2002 at 9:21 am
Viewing 15 posts - 3,796 through 3,810 (of 6,216 total)