What is Data Provider "MSDASQL"?

I've never heard of this one before.

I'm glad it's working now. Sounds like the filename was kept in a table and re-running might have cleared the cache.

Well that seems to be the problem right there. The job is failing by trying to delete a file that doesn't exist.

Perhaps you should check the job, see if...

Does that file even exist? If so, is it perhaps locked by another process?

Could be several issues. Do you have access to SSMS?

Check to make sure the recovery actually recovered the schema and the objects involved. Check to make sure the user hasn't...

Create an Active Directory security group, add the users to the group, then give the group the necessary permissions. This way, when a user leaves or joins, all you have...

For the purposes of SDLC, Drop and Create gives you a date to which you can trace back changes that broke the proc, if something gets broken. The system tables...

SQL 2k5 has dropped support for a lot of the older or "other" database types in linked server OLE DB availability. Also in SSIS, unfortunately.

If you don't have a Teradata...

If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a bit. But this is...

2cams (4/27/2010)

---

I tried to shrink the database but it wont budge.

Why will it be this side if there is so much free space? Do you need to maintain this DB...

There are probably several folks in Albany that don't frequent this group, so don't allow lack of replies to this thread to deter you from starting a local users group.

The thing that trips most...

The person who posted the question should have specified environment. I didn't have to run the code to know the VALUES statement wouldn't work in 2005. Therefore, I chose "Error"...

Thank you. I greatly appreciate your assistance.

Now all I have to do is make sure I've got space on my HD cleared out. @=)

jcrawf02 (4/16/2010)

---

I wouldn't think writing a blog post would really be different from writing an article? If you're going to write a slop blog, then you'd write a slop article...