August 7, 2007 at 5:18 am
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
August 7, 2007 at 5:54 am
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"
August 7, 2007 at 6:00 am
ya i got it
by opening a table and clicking show/hide sql pane and running the query /sp there
August 7, 2007 at 6:45 am
That's Enterprise Manager... look for ISQLW.EXE in the MSSQLServer directory.
--Jeff Moden
Change is inevitable... Change for the better is not.
August 8, 2007 at 1:00 pm
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
August 8, 2007 at 11:05 pm
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
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply