Hi,

How to make log-shipped database to be available for queries.

I have MyDB in one Server which is used for Log-shipping and in the other Server MyDB is getting Logshipped....

I would like to know how to AutoTrace for a specific database, if i have 5 databases in the server and i need to enable the trace or autotrace to...

Hey,

I am sorry as i was new to this i asked about this. Please dont mind and sorry again if my question turned a silly one.

With Regards

Dakshina Murthy

Hey All,

Sorry to trouble you again,

will there be any problem if i change the -EXCHANGETYPE 2 using merge replication. Because i need to implement this in the Live Systems....

Hey All,

Thanks a lot, it was really a great help for me from u all. I tried and it is working fine.

With Regards

Dakshina Murthy

Hey,

Thanks for the information.

But how do i change the

ExchangeType value to 2 using User Interface for an existing subscriber or while creating a new subscriber, where in the...

Ok thanks a lot

Hey Thanks a lot it works,

rather if we try to insert in the subscriber it wont allow us and if we try to delete or update the same will not...

Hi,

I tried with right clicking the article and unchecking it, but we cant uncheck the article.

With Regards

Dakshin

Hi Perry Whittle,

Thanks a lot, it worked and now i am able use sql trace automatically.

With Regards

Dakshina

Thanks a lot, so i can delete the existing subscribers from the old replication aspect and push all the servers in the new replication set up right.

With Regards

Hi,

Ok i will try to make use of SSIS, can we make use of copy database wizard, do the same.

With Regards

Ok fine, thanks a lot. Now the DBs which are used for replication, i have already pushed the dbs , so should i delete them, and reseed for all...

Ok, thanks a ton. If i create an alias in the client utility will i be able to login to the local server with the alias name and will i...

Hi,

Ok thanks a lot. It was really usefull

With Regards