Viewing 15 posts - 38,806 through 38,820 (of 39,466 total)
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
Sorry, for some reason it disappears in the forums. It does, however, exist from the main page.
Steve Jones
November 30, 2001 at 9:36 am
November 29, 2001 at 4:25 pm
Don't know. Can you log in as the SQLAgent account and run it from EM manually?
Steve Jones
November 29, 2001 at 4:23 pm
I think Brian's book is pretty good (from WROX, pro sql server DTS). I've glanced at the New Riders book and it looks ok, but haven't read it.
I'd pick one...
November 29, 2001 at 4:17 pm
I've only done the 229 exam, but knowing the basics of SQL is important. There are questions where you must know the correct syntax, so be sure to pick a...
November 29, 2001 at 4:15 pm
Viewing 15 posts - 38,806 through 38,820 (of 39,466 total)