C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !



Posted By: Abhishek Arya       Member Level: Diamond       Posted Date: 18 May 2006       Category: SQL Server

What should you do if the Merge Agent or Distribution Agent fails on timeout?

Select Answer:

Increase the remote login timeout server option.
Increase the QueryTimeout value in the Merge Agent or Distribution Agent profile.
Increase the remote query timeout server option.





      
Your Test Score: 0 / 0



Next Question: You want to grant Bill permissions to add or remove Windows NT groups, Windows NT users, and SQL Server users in your database. To which fixed database role should you grant Bill membership?
Previous Question: You have a large database partitioned among multiply files and filegroups. You did not specify autogrow feature for the primary filegroup. What would happen if the primary filegroup run out of space?
Related Questions:
  • What is the maximum number of columns allowed for an Index?


  • Which is not the DML statement from following?


  • Query Representation Plan in SQL Server 2005


  • What is the result of select ceiling(8.1)


  • Which statement is true if using NUPIs to accomplish data distribution?


    • Categories

    ASP.NET C# VB.NET 
    .NET Framework SQL Server Other 

    Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program

    Want to prepare for an interview? Try our aptitude tests and standard interview questions first.

    dotNet Slackers   BizTalk Adaptors    Web Design

    Contact Us    Privacy Policy    Terms Of Use