Thanks for the Tip but I add those 3 lines to the code

and it execute sucessfully BUT STILL NO E-MAIL

the e-mail application is outlook

Nelson

Hi I did this way:

CREATE PROCEDURE send_cdomail

AS

declare @From varchar(100)

declare @to varchar(100)

declare @cc varchar(50)

declare @Subject varchar(100)

declare @Body varchar(500)

declare @Attachment varchar(150)

DECLARE @iMsg int,

@Att_Methode_Object     varchar(50)

SET @Att_Methode_Object = 'AddAttachment ' + '("'...

I'm running it as 'sa'

this one

alter table billable_transactions alter column country char(30)

I fix already from the enterprise manager, works thanks alot

Nelson

Yes it's not for replication anymore, and I can change the column now from Entreprise Manager, but i wont let me change from the script.

thanks

Nelson

getting this:

Invalid object name 'sysarticles'.

thanks

Nelson

getting this

Invalid object name 'sysarticles'.

ok now the replinfo is 0

and I run this

alter table billable_transactions alter column country char(30)

and I'm getting this error:

Cannot alter column 'country' because it is 'REPLICATED'.

wherelse I need to change?

Thanks

I did run this

select replinfo from sysobjects where name = 'billable_transactions"

and I got return  128

How do I change it to 0

thanks

Nelson

well , I did drop the replication I drop the jobs I disable the server as replicator, restart the server and when I try to modify that field it still...

there is data on it, you mean drop the replication fix the table and do the replication again?

Thank you !!! works

I just need the file names into to a table

this helps but I need in horizontal position not in vertical ex:

day 1 2 3 4...