Viewing 15 posts - 4,861 through 4,875 (of 6,216 total)
Could also do a clean up operation using the FileSystemObject and a little VB Script. Another option might be to generate separate files and then combine using the standard copy...
February 23, 2002 at 9:20 am
Interesting, though I'd like to see more detail - what a deadlock looks like in the error log and how to decipher it would be good. Ultimately you cannot avoid...
February 22, 2002 at 4:07 am
Both Wrox & Apress have some good material on ADO, or MSDN for free help. We probably have some related stuff here on the site (I have a couple on...
February 22, 2002 at 4:03 am
Outside my experience...unfortuneately!
Andy
February 21, 2002 at 5:19 pm
Hey Steve,
Thanks for the feedback, though it wouldn't hur to give Brian the benefit of the doubt! I agree with your comment that the lead for the article didn't really...
February 21, 2002 at 5:17 pm
Did this in VB6 with a reference set to ADO 2.6. Got the same when I set a reference to ADO 2.7. Haven't looked at Leon's code yet..curious!
Dim cn As...
February 21, 2002 at 5:11 pm
Bravo! Great job of running it down AND documenting how you get there.
Andy
February 21, 2002 at 5:04 pm
Sounds like a disk permission problem - snapshots bcp the data out to disk, then bcp back in on the subscriber.
Andy
February 21, 2002 at 5:02 pm
Are you starting and stopping the mail a lot? I leave mine running always. I'd log the line before the xp_sendmail with all the params, may find that one ends...
February 21, 2002 at 5:00 pm
I made use of an instance for a while to do testing - needed to test changes being made on the real hardware that would be used in production but...
February 21, 2002 at 4:59 pm
You would write a script (heck, we might have one in the library) that would query sysprocesses and figure out which spids to kill. Before you do that I think...
February 21, 2002 at 4:57 am
To make sure visit http://www.microsoft.com/data/ and download the component checker tool.
Andy
February 21, 2002 at 4:54 am
Yes, you can do it in a stored procedure and while the result will be dynamic, the implementation will not. You'll end up with something like this:
create proc usp_GetHeadlines as
set...
February 21, 2002 at 4:50 am
I agree - insert a record into your queue, then either poll the table until status shows complete or just tell the user that they will get an email (with...
February 20, 2002 at 8:24 pm
Viewing 15 posts - 4,861 through 4,875 (of 6,216 total)