Post reply

General queries regarding SQL Server

  • June 12, 2008 at 9:28 am

    #187090

    Hi all,

    I am a newbie to SQL Server. I have just installed SQL Server 2005 Enterprise Edition and I am unable to make any sense out of it. Sorry if I may sound really stupid at some points.

    I have configure System Center Configuration Manager (SCCM) 2007 for which I need the SQL server name and the instance name. I executed the query "SELECT @@SERVERNAME AS 'Server Name'" in the Microsoft SQL Server Management Studio & I got result as "OEMSBSCN-3935\SBSMONITORING". This value is not being accepted by the SCCM saying that "invalid NetBIOS hostname".

    So my first query is how do I get the SQL server name ? Or is it that what I have pasted here is an incorrect query ?

    Secondly, under Registered Servers, I can see "computername\sbsmonitoring" , "computername\sharepoint" and "computername\wsus". What are all these engines and how is the SQL server related to these engines ?

  • June 13, 2008 at 5:01 am

    #828364

    mate if you cant make any sense of it get a book first before you lose the company a lot of money or if you company has a kitty bag for training go for one. you are playing with fire

    Everything you can imagine is real.

  • June 13, 2008 at 5:12 am

    #828368

    Is there anyone who knows SQL there?

    What @@Servername returns is the full name of the SQL instance. In your case, you have a named instance.

    "OEMSBSCN-3935" is the server name

    "SBSMONITORING" is the instance name

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply