Changing the owner of a table

Hi,
I have a table in SQL Server 2000, say its called: "tblName". When
I right mouse click on it and select "Properties" from the menu I see
that beside the "Owner" label is companyName\Administrator.
I want to change this to sa as I'm having problems creating an
index (I think its got to do with this). So my question is: how do you
change the owner of a table please?
Any comments/suggestions/advice greatly appreciated.
Thank you,
Al.
<almurph@.altavista.com> wrote in message
news:1e70ec60-b12a-49dc-b8d4-f070f15d739b@.j20g2000hsi.googlegroups.com...
> Hi,
> I have a table in SQL Server 2000, say its called: "tblName". When
> I right mouse click on it and select "Properties" from the menu I see
> that beside the "Owner" label is companyName\Administrator.
> I want to change this to sa as I'm having problems creating an
> index (I think its got to do with this). So my question is: how do you
> change the owner of a table please?
> Any comments/suggestions/advice greatly appreciated.
> Thank you,
> Al.
Take a look at the sp_changeobjectowner stored procedure. There are some
caveats to this process however. You may impact other views and stored
procedures that depend on that table having the
companyName\Administrator.Table1 name.
You cannot change the ownership to sa. You can change it to dbo.
As for your index, if you are the sa in the database, you could create your
index by specifying the qualified name of the table.
Example:
CREATE NONCLUSTERED INDEX IX_SomeIndex ON companyName\Administrator.Table1
(column list)
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Changing the owner of a table

Hi,
I have a table in SQL Server 2000, say its called: "tblName". When
I right mouse click on it and select "Properties" from the menu I see
that beside the "Owner" label is companyName\Administrator.
I want to change this to sa as I'm having problems creating an
index (I think its got to do with this). So my question is: how do you
change the owner of a table please?
Any comments/suggestions/advice greatly appreciated.
Thank you,
Al.<almurph@.altavista.com> wrote in message
news:1e70ec60-b12a-49dc-b8d4-f070f15d739b@.j20g2000hsi.googlegroups.com...
> Hi,
> I have a table in SQL Server 2000, say its called: "tblName". When
> I right mouse click on it and select "Properties" from the menu I see
> that beside the "Owner" label is companyName\Administrator.
> I want to change this to sa as I'm having problems creating an
> index (I think its got to do with this). So my question is: how do you
> change the owner of a table please?
> Any comments/suggestions/advice greatly appreciated.
> Thank you,
> Al.
Take a look at the sp_changeobjectowner stored procedure. There are some
caveats to this process however. You may impact other views and stored
procedures that depend on that table having the
companyName\Administrator.Table1 name.
You cannot change the ownership to sa. You can change it to dbo.
As for your index, if you are the sa in the database, you could create your
index by specifying the qualified name of the table.
Example:
CREATE NONCLUSTERED INDEX IX_SomeIndex ON companyName\Administrator.Table1
(column list)
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Changing the owner of a table

Hi,
I have a table in SQL Server 2000, say its called: "tblName". When
I right mouse click on it and select "Properties" from the menu I see
that beside the "Owner" label is companyName\Administrator.
I want to change this to sa as I'm having problems creating an
index (I think its got to do with this). So my question is: how do you
change the owner of a table please?
Any comments/suggestions/advice greatly appreciated.
Thank you,
Al.<almurph@.altavista.com> wrote in message
news:1e70ec60-b12a-49dc-b8d4-f070f15d739b@.j20g2000hsi.googlegroups.com...
> Hi,
> I have a table in SQL Server 2000, say its called: "tblName". When
> I right mouse click on it and select "Properties" from the menu I see
> that beside the "Owner" label is companyName\Administrator.
> I want to change this to sa as I'm having problems creating an
> index (I think its got to do with this). So my question is: how do you
> change the owner of a table please?
> Any comments/suggestions/advice greatly appreciated.
> Thank you,
> Al.
Take a look at the sp_changeobjectowner stored procedure. There are some
caveats to this process however. You may impact other views and stored
procedures that depend on that table having the
companyName\Administrator.Table1 name.
You cannot change the ownership to sa. You can change it to dbo.
As for your index, if you are the sa in the database, you could create your
index by specifying the qualified name of the table.
Example:
CREATE NONCLUSTERED INDEX IX_SomeIndex ON companyName\Administrator.Table1
(column list)
HTH
Rick Sawtell
MCT, MCSD, MCDBA

Changing Results View in Query Analyzer

A w ago, I had to change my view to 'Results in Text' in SQL Query
Analyzer. All I did was choose 'Results in Text' from the menu and ran my
query. Now, whenever I open SQLQA, it always puts the results in text,
instead of results in grid (which is what I want). I've looked in the
options window, but see nothing. I've also tried to set the proper option
and save the query I'm working on, but to no avail. Does anybody know how
to get Results in Grid back to the default view option?
Thanks,
BradTools | Options | Results tab | Default results target
These settings apply to the current connection and future connections.
The last connection window closed determines the default when Q/A is
next opened.
To make sure you have the desired default settings, close all session
windows first, then set the options before closing Q/A.
footyplayer wrote:
> A w ago, I had to change my view to 'Results in Text' in SQL Query
> Analyzer. All I did was choose 'Results in Text' from the menu and ran my
> query. Now, whenever I open SQLQA, it always puts the results in text,
> instead of results in grid (which is what I want). I've looked in the
> options window, but see nothing. I've also tried to set the proper option
> and save the query I'm working on, but to no avail. Does anybody know how
> to get Results in Grid back to the default view option?
> Thanks,
> Brad
>|||Hi
Under the tools/options/results menus and tables there is a default results
option which you can choose from a combo.
John
"footyplayer" <anonymous@.discussions.microsoft.com> wrote in message
news:u1WM3G$sFHA.3252@.TK2MSFTNGP10.phx.gbl...
>A w ago, I had to change my view to 'Results in Text' in SQL Query
>Analyzer. All I did was choose 'Results in Text' from the menu and ran my
>query. Now, whenever I open SQLQA, it always puts the results in text,
>instead of results in grid (which is what I want). I've looked in the
>options window, but see nothing. I've also tried to set the proper option
>and save the query I'm working on, but to no avail. Does anybody know how
>to get Results in Grid back to the default view option?
> Thanks,
> Brad
>|||Thanks Trey!
"Trey Walpole" <treypoNOle@.comSPAMcast.net> wrote in message
news:esp6wZ$sFHA.4080@.TK2MSFTNGP12.phx.gbl...
> Tools | Options | Results tab | Default results target
> These settings apply to the current connection and future connections. The
> last connection window closed determines the default when Q/A is next
> opened.
> To make sure you have the desired default settings, close all session
> windows first, then set the options before closing Q/A.
> footyplayer wrote: