[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


srvstatus Column Values

Posted on 2004-10-28
Medium Priority
Last Modified: 2011-04-14
Can anyone tell me what the srvstatus column from the sysservers table means for the following values :

srvstatus = 1088
srvstatus = 1089

Question by:rgregor6
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 32

Accepted Solution

Brendt Hess earned 750 total points
ID: 12436014
The srvstatus value is a bitmapped flag value, and not all of the bits are publicly defined.  The difference between the two is a '1' bit set. this bit is for RPC only and won't let you do any replication.  (Note:  This information is from SQL7, and may not apply to 2K, 2003, etc.)

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question