thanks.

UPDATETEXT will update the part of the text but I want something different.

say my text column has a string 'abcdefghijklmnopqrstuvwxyz'

I need  add 'STIRNGCHANGE' in place of 'fgh' of the original...

Yes,

It's a non-printabla character and can only be viewed in EM not in query analyzer.

Whatcan we call that number?

What would be the ascii number for that character.(its neither char(10) not...

Its a contact table and we will store contact info and the contact's email content will be stored in thsose 10 columns as email1,email2...email10.

Thanks.

they all store notes from the contact.

Description: Cannot find table 0.

User Login: aaaaa@bbbbbbbb.com

User Id: 0

File: http://xxx_demo/application1/messages.aspx

Server: Server1

Source: System.Data

TargetSite: System.Data.DataTable get_Item(Int32)

This is the message I got.

But When I run the same SP in query analyzer...

Unfortunately the login page is not showing any error. Its just showing the same login screen again and again.

Thanks.

Both of them are on same domain and I have tried to connect to the application by turn off the firewall. But still unable to login from a different machine...

My PC is running windows 2000 and using sql server authentication and It's ADO not ODBC.

Thanks.

Thanks for your help. It helped me a lot.

Database 'new_db' cannot be opened. It is in the middle of a restore.

This is the error I am getting when I try to open or query the DB.

Thanks.

Server: Msg 947, Level 16, State 1, Line 1

Error while closing database 'new_db' cleanly.

Server: Msg 5069, Level 16, State 1, Line 1

ALTER DATABASE statement failed.

sp_dboption command failed.

This is the message I...

Both are sql server 2000 and same service packs

and the tables have primary key and MSDTC is running on both the servers and I haven't boot the serverB in recent...

No,Both of them are on windows NT.

Thanks.