alternate to query analyser

Question

alternate to query analyser

hephzibah

Newbie

Points: 3
More actions
August 7, 2007 at 5:18 am

#69041

Hi,
Some how there is no query analyzer inmy sqlserver in my sys...
I want to change the owner of the table using sp_changeobjectowner
i dont know how to write it....or how to run it
can you please help me
Thank you
Hepsi

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

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

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

Hi

Did you check your installation. I think you can reinstall client tools so you will get query analyser. You can use osql utility to execute sql queries/ procedures from command prompt. Check out BOL for this.

"Keep Trying"

hephzibah Newbie Points: 3 More actions · Answer 2

ya i got it

by opening a table and clicking show/hide sql pane and running the query /sp there

Jeff Moden SSC Guru Points: 1004648 More actions · Answer 3

That's Enterprise Manager... look for ISQLW.EXE in the MSSQLServer directory.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

SQLBill SSC Guru Points: 51440 More actions · Answer 4

Which SQL Server version are you running? With 2005, QA is not separate. You need to open SSMS, right click on a database and select NEW QUERY. Or conversely, in SSMS, there is a New Query menu item.

-SQLBill

hephzibah Newbie Points: 3 More actions · Answer 5

Thank You

I'm using 2000 version only which has QA..

But some how the QA in my sys is not there (some files must have been uninstalled)

But i opened the table and clicked the show/hide sql pane and i'm able to use that as QA..

Thank You