Viewing 15 posts - 38,791 through 38,805 (of 39,456 total)
November 30, 2001 at 8:44 pm
I noticed this too. I think this is an MS bug with the system. It seems that it will only restart SQLAgnet if then service fails for some reason, not...
November 30, 2001 at 1:18 pm
November 30, 2001 at 1:13 pm
I apologize. I ran this through DTS and didn't see any problems. I am stumped here.
Is there any chance of BCP out BCP in to a new table?
Steve Jones
November 30, 2001 at 1:12 pm
November 30, 2001 at 1:11 pm
Sorry I don't have a better answer. I actually don't have any SQL 7 desktops anymore to test it. Let me ask around if someone else can test.
Steve Jones
November 30, 2001 at 10:25 am
What versions of SQL?
I run SQL 2000 profiler from my W2K Pro desktop and it works fine against my SS2K servers. I have some problems with my SQL 7 server....
November 30, 2001 at 10:00 am
What about creating permanent tables instead of temp tables and clearing them every night? Might save some work.
Steve Jones
November 30, 2001 at 9:56 am
November 30, 2001 at 9:54 am
That book was horrible for DTS. I'd not recommend you waste your money.
The 2000 books should be ok. They cover additional items in 2000, but I think this is a...
November 30, 2001 at 9:52 am
I've had this problem and solved it by doing the email in the second step of the job rather than the DTS package.
Steve Jones
November 30, 2001 at 9:51 am
November 30, 2001 at 9:49 am
November 30, 2001 at 9:47 am
November 30, 2001 at 9:45 am
If you have a table,
MyTable( MyID, MyDate, Source)
that has some data:
MyID MyDate Source
------ ...
November 30, 2001 at 9:43 am
Viewing 15 posts - 38,791 through 38,805 (of 39,456 total)