Instanace Info

• shiv-356842

  SSCarpal Tunnel

  Points: 4310

  More actions

  August 3, 2011 at 4:52 am

  #241176

  Hi Team,

  I need instance information

  below output i want

  InstanceID InstanceName EnvironmentSpec LastRefreshDate

  please help me on the script.

  Tx

• Mike John

  SSCertifiable

  Points: 7216

  More actions

  August 3, 2011 at 6:08 am

  #1362958

  In order for anyone to give you any meaningful help you need to provide much more details of your problem. What table(s) store this data that you need, if possible the full defiition (DDL) of those tables, and some sample data.

  It MAY be that you are referiing to a SQl Server "Instance" although if so I am not sure what some of the other columns may be referring to.

  Can you explain more?

  Mike

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  August 3, 2011 at 7:54 am

  #1363057

  Simple:

  SELECT InstanceID, InstanceName, EnvironmentSpec, LastRefreshDate

  FROM TableWhereItIsStored

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]