hi Gila, thanks that did work. could you plaese help me lil more.....

i m trying to make search on binary data stored in the database using keyword "contains" and "like"....

Thanks a lot that was the exact answer i required......

yes, thats true but again while installation what should be the setting to achieve the collation. because there is no straight forward collation as "Latin1_General_CI_AS". In the dropdown while installation...

Thanks for the reply that worked. But yet i wanted to know why database go in these modes(single user/recovery/suspect) and how to get rid of these situation.

Any information is...

Replication is a feature of MSSQL using which you can replicate\transfer data across different database servers.

Few Imp. terminologies are:

Publisher: The server which contains the data to be replicated.

Distributer: A server...

Hi Sir, I am using SQL 2005 enterprise edition. I cud not get the option you

mentioned. However there were options in set article properties as "Drop existing object and...

Please tell me can i install 64 bit SQLserver2005 on 32 bit operating system

Thanks sir. Actually (Intel X86) comes using @@version also but i was not knowing that it means 32bit thanks a lot.

try sp_who it will give the list of the databases and processes attached with it.

Hi mohan thanks for the reply. But i have deleted the publication and the susbsciption databases also which are parameters to the SPs. yet the name of the replication appears...