srvstatus Column Values

Posted on 2004-10-28
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
    1 Comment
    LVL 32

    Accepted Solution

    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.)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

     Java Android Coding Bundle

    Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    Introduced in Microsoft SQL Server 2005, the Copy Database Wizard ( is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

    884 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now