On 2/20/06, Snake <[EMAIL PROTECTED]> wrote:
> Login with enterprise manager, look at the tables.
> Who doe sit say is the owner of the tables, DBO or a specific user.
> If it is a specific user, then that means the tables were created as that
> user, and thus why you have to prefix all queries wit
On 2/20/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> > If I delete the user first, the site will stop working completely and
> > all hell will break loose, no?
>
> does it work now? do you have backups? if you do, take the db off-line &
> drop the user from the db (not from the logins) then try a
Login with enterprise manager, look at the tables.
Who doe sit say is the owner of the tables, DBO or a specific user.
If it is a specific user, then that means the tables were created as that
user, and thus why you have to prefix all queries with that user name.
Russ
~~
Kay Smoljak wrote:
> Actually, I logged in with my Windows user and tried it anyway... and got:
i guess you're in the admin group on that server. i wouldn't have
expected that.
> Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 47
> The proposed new database owner is alread
Kay Smoljak wrote:
> I don't have the SA password on that box... I have my own login to the
> server (not administrator). If I open Query Analyser and log in with
> Windows authentication that won't work, will it?
no.
~|
Message
On 2/20/06, Kay Smoljak <[EMAIL PROTECTED]> wrote:
> I don't have the SA password on that box... I have my own login to the
> server (not administrator). If I open Query Analyser and log in with
> Windows authentication that won't work, will it?
>
> > EXEC sp_changedbowner 'that_user_name'
Actuall
On 2/20/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> lets try kicking it where the sun don't shine:
>
> login as SA w/query analyzer & connect to that db
I don't have the SA password on that box... I have my own login to the
server (not administrator). If I open Query Analyser and log in with
Wi
Kay Smoljak wrote:
> Through Query Analyzer using that user/pass, I cannot query the table
then that user cannot be in the DBO for that database.
> Is there a chance that something like this could happen if the
> database was had to be restored from a backup? The client didn't reply
> when I aske
On 2/19/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> if you can only access that table using a user name as a qualifier then
> that user's not the DBO. can you query the unqualified table using query
> analyzer using that user/password?
Through Query Analyzer using that user/pass, I cannot query
Kay Smoljak wrote:
> Been through that - the dbo role has the user in question listed first
> on both servers.
> I'm really stuck!
if you can only access that table using a user name as a qualifier then
that user's not the DBO. can you query the unqualified table using query
analyzer using that
On 2/19/06, Paul Hastings <[EMAIL PROTECTED]> wrote:
> not really. while that table might "belong" to that user name (as seen
> in EM), if they aren't the DBO you'll always *have* to supply the user
> name when accessing the table. pop open that user or the roles in that
> db & see what's what.
Be
Kay Smoljak wrote:
> Is there anything else it could be?
not really. while that table might "belong" to that user name (as seen
in EM), if they aren't the DBO you'll always *have* to supply the user
name when accessing the table. pop open that user or the roles in that
db & see what's what.
~~
> trust the sql server box. that table is owned by that db user which is not the
> DBO and/or the DSN is setup w/another user.
Well, I'm remote-desktopped into the live box right now, I'm staring
at both the CF Administrator DSN setup screen AND the database table
listing in Enterprise Manager and
Kay Smoljak wrote:
> up the dbo user owning all tables. The DSN set up in the CF
obviously not.
>
> SELECT *
> FROM [db_user].sometable
>
trust the sql server box. that table is owned by that db user which is not the
DBO and/or the DSN is setup w/another user.
~~
This goes beyond my understanding of SQL Server (2000, Standard
Edition, SP3, running on windows 2003 with CFMX 7 and FarCry 3 if that
matters at all).
I have a dev box set up which is as close to identical to my client's
server as I can make it. On both servers, the FarCry database is set
up the
15 matches
Mail list logo