Re: Strange Exception!
- From: "Gav" <spam@xxxxxxxx>
- Date: Mon, 12 Sep 2005 09:49:12 +0100
I eventually managed to login as 'sa' but the table in question is only in
there once.
So that rules that out, unfortunatelly.
Thanks for the replys
Gav
"Nick Malik [Microsoft]" <nickmalik@xxxxxxxxxxxxxxxxxx> wrote in message
news:W92dnZq2_tQWg7zeRVn-vg@xxxxxxxxxxxxxx
> "Gav" <spam@xxxxxxxx> wrote in message
> news:u7$$zpJtFHA.3188@xxxxxxxxxxxxxxxxxxxxxxx
>> Thanks for the reply...
>>
>> I'm not sure how you login to enterprise manager as a different account?
>>
>> When I go in as normal it says that all the tables are owned by dbo.
>>
>> Regards
>> Gav
>>
>
> Hi Gav,
>
> In SQL EM, register a new connection to the database. Log in as the
> account that is mapped to dbo or log in as 'sa'. Another alternative is
> to make your account the dbo account.
>
> Only the dbo sees the tables owned by other people.
>
> --
> --- Nick Malik [Microsoft]
> MCSD, CFPS, Certified Scrummaster
> http://blogs.msdn.com/nickmalik
>
> Disclaimer: Opinions expressed in this forum are my own, and not
> representative of my employer.
> I do not answer questions on behalf of my employer. I'm just a
> programmer helping programmers.
> --
>
>
.
- References:
- Re: Strange Exception!
- From: Nick Malik [Microsoft]
- Re: Strange Exception!
- From: Gav
- Re: Strange Exception!
- From: Nick Malik [Microsoft]
- Re: Strange Exception!
- Prev by Date: Monitoring Directories
- Next by Date: How to set WUApiLib.UpdateSearcherClass.ClientApplicationID to get Updateinfos o
- Previous by thread: Re: Strange Exception!
- Next by thread: StreamWriter.Flush/Close guarantees? Was: System.IO.StreamWriter Close or Flush method to shut down the computer in such a way that just part of the file is written? or an empty file is written? Also if the Close or Flush is to a streamwriter writing to a network share, is it possible for the netw
- Index(es):
Relevant Pages
|
