I was having a bit of a hard time reading your screen shots so I'm takign a few stabs in the dark.  I noticed you have a bunch of connections.  Are they...

Unfortunately, testing in our environment is mostly human based as well. 

Developer test in Development environment.

Then test users test in a testing/training environment

Then a release to production....

It depends on which level of AD you have.  If you are in 2003 native you can use a universal group which if I remmeber correctly can pass domain boundries...

Don't just brain dump for this test.  Actually spend a few hours studying.  Try actually learning something instead of just memorizing things for the test.  They can teach a monkey...

You want to talk about geek cars/bikes... I think the DOLMETTE has got to be the king.  A 24 cylinder power bike powered by Dolmar Chainsaws.

http://www.dolmar.com/755.php

Without knowing a bit more about your data and why you need to create the temp table first it's somewhat difficult to help but here goes anyhow...

Why not create a...

My current employer is OK, you can take training courses but they have to be at night or on weekends.  They pay for the course, not the travel.  I am...

use something like this...

ftp -s:MyCommands.txt --the -s specifies you will use a text file containing your ftp commands.

The Text file should look like this.

open http://ftp.downloads.co

username --sends username

password --sends password

cd...

Couple of things...

First, Do you have any restrictions on who can get to the internet?  If so does your SQL Server Agent user have such a privledge.

Second, I've never been...

Thanks I think that will be just the ticket.

-Luke.

Another problem beyond permissions I had once was that the account for the SQLAgent couldn't find DTSrun, and I had to specify "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\DTSRun.exe" in the edit step...

In EM, expand Management, then SQL Agent, then jobs.  Your job should be listed in there.  At that point you can right click on your job and choose disable, delete...

For me it's a chance to get out on the links and get in a round of golf when the weather is nice.  Also taking long jogs/walks with my dog...

Ok, so using a .bat files to do this isn't the best way for error checking and such, but it you really want to call the access apps the same...

If you're just looking for the current system date you can use this wherever you wanted to use your variable...

convert(char, DATEADD(dd, DATEDIFF(dd,0,getdate()), 0), 111)