Viewing 15 posts - 1 through 15 (of 17 total)
Questions -
February 7, 2005 at 11:56 am
I must agree with Frank, you might want to consider another tool. When I used to work in junk mail, er...Direct Marketing...we'd get millions of names a week to process...
December 30, 2004 at 11:14 am
I will agree that OPENQUERY is quicker on the first read only. If you are performing multiple OPENs, you will see much worse performance, imho.
They are good for reading...
October 8, 2004 at 7:55 am
I recommend against using SQLMail altogether for this reason, the requirement of an active mailbox. Try POSTIE.EXE ( http://www.infradig.com/index.html 
A detailed usage example -->...
May 7, 2004 at 10:57 am
I've been looking for this too...but I remember seeing a SELECT...INTO that allowed output to a text file. Hallucination?
February 13, 2004 at 8:16 am
Worked...
OK, so I added the other alerts and observed the following:
EM -> delete domain login = 15485
EM -> add domain login = 15481
QA -> drop domain login (domain\loginID) with sp_droplogin...
December 3, 2003 at 3:40 pm
As to "what does the account need to run this" The following appears to be a problem in both SQL7 and SQL2000
"PRB: Need to Map to Default Admin Account...
November 18, 2003 at 8:26 am
OPENROWSET is slooooooow. Comapred to a linked server at least. The connection has to be established each time you run the query, kind of an ad-hoc linked server....
October 3, 2003 at 10:00 am
http://www.xceedsoft.com/products/ZipNet/
http://www.chilkatsoft.com/dotNetZip.asp
http://www.example-code.com/vb/default.asp
FREE!
http://www.organicbit.com/zip/
http://www.winimage.com/zLibDll/
-------
at us, very deafly, a most stares
collosal hoax of clocks and calendars
eecummings
August 22, 2003 at 11:59 am
That's normally Visual Basic error indicating an unitialized object variable, not a permission issue.
dim o as object
set o...
August 11, 2003 at 7:24 am
quote:
This error happens when more than one record is in the Inserted table. This can easily happen on an Update trigger.
July 31, 2003 at 3:07 pm
It was my understanding that the Post Office updated the zipcode file once a quarter, but that's not all you're buying when you get a geo zipcode.
One question...a...
July 30, 2003 at 8:05 am
To clarify...
quote:
But...I'm not a DBA. App programmmer (c/c#/vb/SQL/asp/php) since 1989.
Not a speller either. Note...
June 25, 2003 at 1:47 pm
Viewing 15 posts - 1 through 15 (of 17 total)