UPDATE TABLE_NAME SET COLUMN_NAME=REPLACE(REPLACE(COLUMN_NAME, ' ', ''), '-', '')

WHERE TABLE_NAME IS THE NAME OF THE TABLE

COLUMN_NAME IS THE NAME OF THE CCOLUMN WITH IN THE TABLE WHICH U...

SELECT     REPLACE(REPLACE(COLUMN_NAME, ' ', ''), '-', '') ASCOLUMN_ALIAS

FROM         TABLE_NAME

i have tried running  both the command at the same time (arp -a), still i couldn't find a matching

But for most of the entries in net_address column there is no matchin entry in app -a command

Hi Homeberw01,

Snapshot/ Transactional replicaiton  if you enable updatable subscribers(immediate/queued) , subscriber can update the publisher ....

Regards

SKv

ok, thankz.

Do i have to do anything at subscriber side ?

pls help

skv

Yes, Since Immediate/queued updating is enebled, subscriber will be able to update the publisher.

But this is not happening for the newly added article(table)

please

help

Steve,

Any idea what this status=4194320 and  status2=1090650112

is it an indication of database is in critical state ?

On more thing, it was showing "Error Recovering Database" at SQL server logs. when i restarted the service .

Now the DB is working without any problem.. but let me know any issue...

Hai,

Ok, this can be the reason.....

thanks a lot

If it on a different instance/server,

1. Create the login name

2. Restore the DB

3. Attach DB user with the Login name using

SP_CHANGE_USERS_LOGIN 'UPDATE_ONE', 'DB USER NAME','SQL SERVER LOGIN NAME'

SUBHAH

Dear Srinivas,

Are u restoring the datbase on the same instance or different instance ?

i have executed dbcc tracestatus(-1), it is giving:

'Trace options() not enabled for this connection. use DBCC TRACEON()'

No, am not using any third party software for monitoring.

The server is having 8 GB of memory available

Ok, thanks

is there any seperate log for Cluster ?