Thanks, that seemed to do it.  I just never thought about that possibility.

The problem seems to be with running the sp_databases SP in the stored procedure.  I changed my SP to populate the temp table with just some of the databases and...

The job step is a Transact-SQL Script type and the command is:

EXEC dbo.swn_sp_regular_backups

(This SP is made of the code you see above.)

I also noticed something else after I posted this.  I...

Yes, I did both and got the same results.  I admit I had not thought of racosta's method but it works.

Thanks to both of you.

Thanks, I thought I had tried it before but I tried it again.  I must have had "fat fingers" the first time.

Thanks again.

Thanks Steve.  Because of the types of (multiple) fields I have that make up the PK, the Outer Join option is what I was looking for.

I wrote it that way...

phanikk,

This won't work because there is not enough space to do this. 

Kari, you might implement a combination of the two solutions.  First, NULL the values of the blob then...

Yeah, thanks to both of you.  I immediately realized the answer with Prasad's response.  I just got myself pigeon-holed and missed figuring it out on my own.

Thanks again.

D'oh!  I had a Homer moment!

It makes sense.  I just got stuck in one train of thought and I couldn't see the answer right...

When you say make the RAID 1 bigger, I assume you are talking about disk size or number of disks.  Is that correct?

Even if I made it into 2 logical...

I'm not exactly sure how you are running these queries but if you are running them in a stored procedure you might also consider using a temp table.  The overhead...

I haven't tried it on Win2003 but you might also try running the following command:

DBCC TRACEON(1807)

This allows SQL Server to recognize UNC notation.

I did this before I setup a maintenance...

Update:  It started working.  I did make changes with assigning rights to individuals and groups and back again just for testing but it never worked right yesterday.  I put all...

I have been trying a linked server but the problem with this is the system database.  According to Microsoft, a linked server that is access is going to use the...

Sorry for not replying sooner but anyway, ThomasH's suggestion did not work.  The problem was that he didn't address the system database (mdw) requirement.

I have gotten my query to work...