That's awesome and thank you.

I can get the rest from here 🙂

I took out the EXEC and inserted a PRINT.

The SP within the job ran just fine. I then put the exec back and the 1st step for the job...

Sorry about the comment lines. I already ran that before (and it succeeded), I just forgot to take them out when i posted to the forums.

I can pull data...

ServerA and ServerB were just place holders I put in for this post.

Call me paranoid 😛

Here is the SP without my place holders.

USE [DBA]

GO

SET ANSI_NULLS ON

GO

SET...

Thank you both for your help.

I am now able to run job's against that database. I am now having a different issue that will need to be resolved in...

I shall give that a go and give you an update when i'm done.

Thank you 🙂

After more research and getting other people's help I was able to determine it's a NIC congestion problem.

What i need to do is just add a 2nd dedicated NIC...

Hey Joie,

The backups did work when I did move them from the SAN to the NAS for several months. But due to increasing traffic on the NAS (which from...

What you have made clear is: Transactional Replication existis between a table in Database A (which I will refer to as Table A) database and a table in databaser...

Thank you Sean. I will give that a go.

Yeah that's what I initially thought a restore but no Data (then what's the point), I just didn't know of a...

Hey Gazareth,

Thank you for the help. That is exactly what i needed. I gave the info to a programmer and he new exactly what the problem was.

Thanks again.