Hello sahoong,

To change the collation at database level you can do it with the following statement.

ALTER DATABASE MyDB COLLATE MyCollationDesired

To check the entire list of collations:

select * from...

Hello Gedeon,

I see in Replication the Best Solution to accomplish your request.

You can use Transactional / Snapshot Replication.

It replication model allow you define the set of table...

Hello srikanth.katta1,

Details.

http://msdn.microsoft.com/en-us/library/ms190355.aspx

The following are the system tables used by log-shipping.

log_shipping_monitor_alert (Transact-SQL)

Stores alert job IDs for log shipping.

log_shipping_monitor_error_detail (Transact-SQL)

Stores error detail for log shipping jobs....

Hello Sashikanta,

Will be very helpfull if you put the complete error message you got.

You are mentioning the following error : "Transaction can not be complete because of insufficient...

Hello mahesh.vsp,

Only Dev and evaluation editions runs over XP. So, perhaps the SQL Server that you see over XP is an MSSQL 2008 Enterprise Evaluation.

See:

Microsoft® SQL Server® 2008 Enterprise...