Got it. Someone had changed the Server. It is a dev box.

the Production box is fine. All is well.

Thank You Lowell!

No Sybase installed.

Thanks Lowell,

I changed the query to read like this:

DECLARE @Filename VARCHAR(100)

DECLARE @sql VARCHAR(4000)

SET @Filename = 'C:\Event.xml'

SET @sql = 'EXEC AllEvents.dbo.USP_EventXML'

SET @sql= 'bcp "' + @sql +'" queryout ' + @filename...

Thank You all for your comments. I will use your posted tips, and pitfalls to expand on my knowledge. This is a learning experience for me.

this way uses sp_executesql.

use pubs

GO

declare @fnam varchar(20);

declare @sqlstring nvarchar(4000);

declare @Parm nvarchar(4000);

set @sqlstring =

N'SELECT fname,lname FROM pubs.dbo.employee WHERE fname= @empname';

set @Parm = N'@empname varchar(20)';

set @fnam...

I use a slightly different approach in that I have the db's do a differential backup for 6 days and then a full backup on Sunday. That in combination with...

You could try a statement like this.

Update tableA set

zipcode = b.zipcode

from

tableB b

Inner join

tableA a

ON

b.zipcode = a.zipcode

Where

[Add reason for update condition here]