It helps me in moving to destination server but its not available on source server,But i need that database on source server too.How can i do that.

Thanks.

Thank you very much

Can anyone help me in this issue?

Thanks.

Hi,

I have added a column to a table in the publication database using the Enterprise manager in my sql server 2000.But the column didn't affect in my subscription.Mean time I...

How should i do the same with Enterprise manager.

Thanks all for the help.

I have a table a with these values.

Number Name

1 ee,ed,ff,er,fsd

2 rr,kk

I want store these values as below into other table...

hey whats dtore, can u please explain me in detail.

Thanks

Hi Marc,whatz with ties in the first query,what does it do.

Too many columns found in the current row.non-whitespace characters foundafter the last defined column's data.

I could not fine that row exactly because my text file row consistf of 3 to...

You can try this user defined function

CREATE FUNCTION PROPERCASE

(

--The string to be converted to proper case

@input varchar(8000)

)

--This function returns the proper case string of varchar type

RETURNS varchar(8000)

AS

BEGIN

IF @input IS NULL...

I dont have a ID column,I have only one column each on the two tables.

Thnks to all of you.

when i try to use xp_cmdshell,i am getting an error that could not find the stored procedure 'xp_cmdshell'.

What should be the reason,how could i come across this one,

Thanks

thank you very much