Hello,

Thank you for your response. After all of this... to make it very easy, I'll just create a job on my second server that will poll a table for...

Hello,

Do I need to enter a provider string? I've been doing this all morning without a provider string and I always receive the error that the SQL Server does...

Hello,

Thank you very much for everyone's help. I ended up creating new jobs, a new trigger, and a new table. To make a long story short, the owner...

Hello,

Are you recommending changing the linked server's login permissions? Or the owner of the jobs?

Thanks!

Melanie

Hello,

Thank you for your response.

Last night, I created a stored procedure on Server A that contained the INSERT statement and that would be called by the job on Server A....

Hello,

The login used by the linked server used to be a system administrator on both servers and the job worked well with these permissions.

Since the password has become known, I...

Hello,

Thank you for your reply. I actually ran this DBCC command (after doing a helpful search through SQLServerCentral.com) and couldn't quite understand what was returned.

I have since discovered a...

Hello,

Thank you for your response. I figured that I needed to export, but I was told that the table could be burned itself.

Thank you very much.

Hello,

Thank you for your replies. I guess I should have mentioned that the job has run successfully for four days. I ran it again after it failed and...

Hello,

Thank you for your response. The database isn't shrunken before the backup is performed.

The next time I perform a restore, I'll take note as to exactly how much space...

Hello,

Thank you for your reply. I took a look at the KB article and that does not describe my problem.

I have a database that is 6.9 GB. The...