Um... That's exactly the problem in the first place. The job has to be run under a user that has SQLAgent credentials.

When called from the stored procedure in question,...

Hi all.

I must admit I haven't read the whole 5 pages of this thread, so apologies if I'm repeating something someone else already said, but I'd be curious to know...

Thanks for the verification.

So as I suspected, the SQL Server is always using the credentials of the login from the computer that sent the processing request when in Windows Authentication...

Thanks a bunch!

In fact, I would go one step further and say that if you are using the 64-bit SQL 2005 version you may not have much luck running an SSIS package...

Thanks Schmuel! I figured it would work something like that. Wasn't quite sure how to reference the variable, or whether I had to pass that back to a...

Hi Chris.

Actually, the FileWatcher looks good, but probably not for what I'm trying to do here.

The .ldb file I referred to has to be ABSENT from the directory in order...

Hi Chris.

Thanks for the tip.

Yes, I haven't started writing the proc to do this yet, so there's still time to throw new ideas at it, and this one sounds good....

Thanks a million Jack. I'll have a look.

A colleague and I were just talking about this and he showed me a script where he's returning records from an sp_cmdshell.exe call...

I'm assuming if it's .Net, that we wouldn't be able to kick it off periodically, like once/hour, from a job.

The reason I want to do this from the SQL Server...

Sorry, what do you mean by a "script task" exactly?

I haven't had this exact issue before, but be aware that many of the 64bit tools seem to be a bit worse for wear.

For instance, when doing imports/exports from a...

I live in Australia, and I travel a half hour by car AWAY from the city, so I don't really have any traffic.

However, I also have permission to spend some...

I'd like to add something here... I think a few people have touched on it, but it's pretty important.

If you are pulling out a very small amount of records, say,...

GilaMonster (7/25/2008)

---

Respectfully, if the indexes you created didn't help then either the code was writen in such a way that SQL couldn't use the index or the index was not...