Is the data type for the field in question the same throughout all your databases, as you move this data through each? 

I will assume you checked out the Execution Plan to look for performance issues.   Well, since you do get data in Query Analyzer, we know the stored procedure is works.  

You...

SinLam,

The first thing that popped into my head was that you have a run-away loop or an inefficent query.  How is the performance of the stored proc in Query Analyzer? 

JR

Although, this is for SQL 7, it may be helpful for setting up log shipping for the first time: http://support.microsoft.com/default.aspx?scid=kb;en-us;275146

Rachel,

I agree with Noeld and Ferguson. It is much easier with DTS. The DTS package designer has a Send Mail Task that makes this a snap.

JR

...

FNG: F***ing New Guy

I assume you are exporting from a table to a text file using a Transform Data Task. If so, try using Disconnected edit. Set up your connection to...

abaig,

Are you trying to restore a database to different server ("the standby server")? Please give me a little more detail on your procedures.

JR

Matt,

First off, here is the code and article 252987: http://support.microsoft.com/default.aspx?scid=kb;en-us;252987

(Scroll down, the page's html is messed up)

Simon is right. I struggled with this some time ago, which...

kelvin,

Without knowing more detail about your package steps or more about the VB app, this sounds like a permissions issue. As you know, security has changed quite a bit...

..Oops. I meant Access, not Assess.

k2,

Since you are using workgroup security, this info may be wrong, but give it a try. I think the username and password in the connection properties is for the...