Thank you very much for prompt reply.

Jeff,

I didn't see any solution in the link provided.

Bhushan

thank  you all folks. Its great idea. But how to change the text data type to nvarchar(MAX). I found something interesting and happy to share with you. When I use...

Thank you for your reply.

HI Adrian,

Why we have to execute SP_ADDPUBLICATION stored procedure on server2 which is scriber. As far as I know sp_addpublication can be executed on only at publisher.

Even I pressume that id column means identity column and it is a good idea. If the table is really big and millions of rows then be sure the data type to hold big numbers...

I will try this and let you know how it goes.

Thank you very much for the reply

I have similar problem; the scheduled job is taking 45 min to complete though it scheduled to run for every 10 minutes. I haven't find any solution so far but...

There will be a performance hit if field length is not choosen properly. Because deletes, inserts and updates cause lot of page breaks and data/index pages will be scattered. The database engine...

Thank you folks. It really helped me.

BK

Hi Yelena,

Thanks for your reply and there is a other way around to fix this issue. We have to give physical node at virtual server name because the SQL server...

It's really awesome article for the beginners in SQL Server 2005 security.

Bhushan

Thanks to all of you. Database mirriong and snapshot should not statisfy my database requirements because the data should be more than 2 minutes latency. Some one suggested me to...

Thank you very much Paul.

Bhushan

Hello Guys,

Litespeed is a great back-up and restore tool but their customer service sucks. The tool considerably shrinks the back-up files and also less restore time. But some times the transaction log...