query analizer issue

• sivark1

  SSCrazy

  Points: 2654

  More actions

  September 4, 2009 at 4:03 am

  #214719

  my query analizer is corrupted/disabled how to retain back without installing again whole s/w in sqlserver 2000

  earlier it was running fine suddenly it is corrupted

  pls let me know the path of the query analyzer in sqlserver 2000.

  Thanks in advance

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 4, 2009 at 4:12 am

  #1049280

  sivark1 (9/4/2009)

  ---

  my query analizer is corrupted/disabled how to retain back without installing again whole s/w in sqlserver 2000

  earlier it was running fine suddenly it is corrupted

  pls let me know the path of the query analyzer in sqlserver 2000.

  Thanks in advance

  isqlw is the name of the query analyser in 2000

  and depending on your installation, it is normally located in

  C:\Program Files\Microsoft SQL Server\80\Tools\Binn

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• sivark1

  SSCrazy

  Points: 2654

  More actions

  September 4, 2009 at 4:15 am

  #1049282

  hi some more information pls

  After clicking the QA, it searches for the exe file and then asks for the password

  PFA.. follwing error it is showing

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 4, 2009 at 4:29 am

  #1049285

  sivark1 (9/4/2009)

  ---

  hi some more information pls

  After clicking the QA, it searches for the exe file and then asks for the password

  PFA.. follwing error it is showing

  ok, looking at your screenshots, looks like you are referencing the wrong file.

  on your 1st screen shot when you see query analyser in the menu. right click and select properties. it should be like the following.

  Target: "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\isqlw.exe"

  Start in "C:\Program Files\Microsoft SQL Server\80\Tools\BINN"

  it looks like you are trying to run ISQL.exe and not isqlw.exe

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• sivark1

  SSCrazy

  Points: 2654

  More actions

  September 4, 2009 at 4:57 am

  #1049295

  Thank u verymuch for quick reply

  if .exe file corrupts then my doughts is can we repair/install only query analyzer components

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 4, 2009 at 5:05 am

  #1049299

  sivark1 (9/4/2009)

  ---

  Thank u verymuch for quick reply

  if .exe file corrupts then my doughts is can we repair/install only query analyzer components

  if you try and run query analyser through windows explorer by double clicking the file and it doesnt run, then just replace the file. if you still cannot get it to work, then reinstall the client components again

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]

• sivark1

  SSCrazy

  Points: 2654

  More actions

  September 4, 2009 at 6:03 am

  #1049315

  Thanks for replying

  pls clarify this dought

  is it possible to UN install only client components

  if possible what r the precautions to take care before uninstalling

  If i install client components again will it effect any existing databases in the server

  or what happened to existing client componetnts

  Thanks in advance

• Silverfox

  SSC-Insane

  Points: 23150

  More actions

  September 4, 2009 at 7:25 am

  #1049349

  sivark1 (9/4/2009)

  ---

  Thanks for replying

  pls clarify this dought

  is it possible to UN install only client components

  if possible what r the precautions to take care before uninstalling

  If i install client components again will it effect any existing databases in the server

  or what happened to existing client componetnts

  Thanks in advance

  Just out of curiosity have you actually tried any of the things that I have suggested. reinstalling client tools will have no visible effect, as they are client tools and not server. can you actually run isqlw from either the command line or even change your shortcut to see if you actualy have an issue with isqlw. as previously you are trying to run isql.exe

  --------------------------------------------------------------------------------------
  [highlight]Recommended Articles on How to help us help you and[/highlight]
  [highlight]solve commonly asked questions[/highlight]

  Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
  Managing Transaction Logs by Gail Shaw[/url]
  How to post Performance problems by Gail Shaw[/url]
  Help, my database is corrupt. Now what? by Gail Shaw[/url]