This is interesting, I think my problem is that I am entering the instance name when I should be entering the virtual SQL Server name.  Somehow when I installed the...

Correction to post, I can not connect to the instance from a remote box.

I quit being a pharmacist 9 years ago to become a programmer and now am a DBA.  Pharmacy, at least for me, is more stressfull than IT.

My dream job...

SSC has been my favorite web site since I became a DBA in 2002.  Congratulations!  Thanks also for taking the time to nuture along new authors!  Look forward to seeing...

Are you on SQL Server 2005?  If so, try converting the ntext column to

nvarchar(MAX).  Or, better yet, change the actual column to nvarchar(MAX) if you can.

Thanks!

I just found out from Microsoft that this version does support SQL Server 2000.  They said that a previous version worked with SQL 2005 beta and this version was updated...

Oh, and I'm glad you like the book!  Thanks!

Usually problems like this relate to security -- the job running in a different account than running manually.  But, it doesn't sound like it since it is the FTP part...

Good point.

I would first try running it manually, possibly from VS2005 on the production server first.  Be sure to check the FTP connection manager properties once it is there. 

Was there...

In SQL Server 2000, from Enterprise Manager you can script out objects to individual files.  This might be an acceptable work-around for you.

Unfortunately, in SQL Server 2005, this functionality disappears...

The following answer assumes that this is a T-SQL stored procedure, not a CLR stored procedure:

The stored proc is saved in the database.  So, you create a stored procedure by running...

You can not use "USE" in a stored proc unless you employ dynamic SQL.

You can fully qualify, for example:

exec master.dbo.xp_sendmail

Use caution here, you are not actually grouping by the entire ntext column, only the first 30 character! 

Brian Larson's book "SQL Server 2005 Reporting Services" (Osborne) has a section on custom authentication using the RS security extension. He says that you need the Enterprise edition to do...