I don't know what's your problem,

This works for me :

Declare @data varchar(20)

set @data = 'St.Mary''s County'

insert into test VALUES (@data)

Are you using dynamic sql ? --> take a look at QUOTENAME 

I would suggest you to create Two Computed Columns

1 On  CCP_NCR.dbo.NCR_Master 

 CompColName1 AS  (Actionlocation + '-' + ActionNum + '-' + CurrentYear + '-' + LTRIM(RTRIM(ABS(Revision)))

2.  On CCP_NCR.dbo.bdr_ncr

 CompColName2 AS (actionlocation...

You have Duplicates OrderIds on your "order_old" table or on your "order1" table

 HTH

I Firmly believe that xp_sendmail IS NOT the tool for that job!

I've  had a lot of problems of this kind and the workarounds didn't work pretty well. My advice is...

Use the SaveToRepository Method!

How about:

SELECT U.ORDINAL_POSITION, U.COLUMN_NAME FROM

 INFORMATION_SCHEMA.KEY_COLUMN_USAGE U

 INNER JOIN 

 INFORMATION_SCHEMA.TABLE_CONSTRAINTS  C

ON U.CONSTRAINT_NAME = C.CONSTRAINT_NAME

WHERE  C.CONSTRAINT_TYPE = 'PRIMARY KEY' AND U.TABLE_NAME = 'YOUR TABLE NAME'

Ramesh,

You have to use either Windows Integrated (Trusted Connection) or SQL Server Authentication NOT Both!!

Please Replace this:

Exec @hr = sp_OAMethod

@obj, -- refers to the object that was created

'SaveToSQLServer', -- the method...

I don't know if I should even say anything else but everytime I have found a WRONG answer NOTHING has happened!

I had that Problem before and JellyRoll  IS ON THE MONEY

Passive FTP is required for some sites and the ftp client that comes by default does...

you are welcome!

You may want to check This 

YOU NEED LOCAL SYSADMIN PERMISSIONS ON THE REMOTE SQL BOX

HTH

Dave,

1. Your Statement is Missing the Destination Table and Fields!

CREATE TRIGGER cps_customer_tg ON company FOR INSERT

AS

INSERT

DETINATIONTABLENAME ( FIELD1,FIELD2,......)

           SELECT NULL, registration_id, inserted.Company_Name,

          inserted.Address_1, inserted.Address_2,

          inserted.Address_3, inserted.Country, inserted.City,

         ...

I don't have SQL 7 here but I tryed this on 2000 and it works  

DECLARE @in   varbinary(20),

 @strOut varchar(20)

SET @in = 0x00000E0000120002

EXEC master..xp_varbintohexstr @in, @strOut...

Just to add a little more to David Solution. Be careful with what you consider ALPHANUMERIC because some systems may need to use signs other characters and All you have...

I am interested!

I sent you my Resume and I am willing to relocate on my own (it's  relatively close!)

No replies received though.