Script to get Server Info

  • Comments posted to this topic are about the item Script to get Server Info

  • when i run this script on SQL 2008 i get an error

    Msg 213, Level 16, State 1, Line 197

    Column name or number of supplied values does not match table definition.

    its happening

    Create table nodes (name varchar (20))

    ==> insert into nodes values (@image_path1)

  • Nice script ... worked fine on SQL server 2005 !

    Thanks for sharing ..

    \\K

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂

  • Good work.This was one of the top 10 use full posting I ever read.Thanks for sharing

  • Not bad! - I like it!

    :hehe:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • shyam.babu (3/2/2010)


    Good work.This was one of the top 10 use full posting I ever read.Thanks for sharing

    The author just gathered things that DBAs normally check into 1 piece, which is a good thing, but if it made your top 10, then the stuff you normally read must be seriously useless 🙂

  • Thanks for the script.

Viewing 7 posts - 1 through 6 (of 6 total)

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