SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Archive to Table problem

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Archive to Table problem
Author Message
Raymond



Joined: 16 Jan 2006
Posts: 6

Post Archive to Table problem Reply with quote

When I try to use the function -Archive to table, I got the message-"You must select existing schema for the destination table".
The field schema is empty . I have nothing to choose from .
Plateform:SQL2000 SP3


Mon Jan 23, 2006 6:52 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Archive to Table problem Reply with quote

Do you have permissions to select from sysusers? Was the database restoed from backup and db owner not set after that?

: When I try to use the function -Archive to table, I got the message-"You
: must select existing schema for the destination table".
: The field schema is empty . I have nothing to choose from .
: Plateform:SQL2000 SP3

Mon Jan 23, 2006 10:22 am View user's profile Send private message
Raymond



Joined: 16 Jan 2006
Posts: 6

Post Re: Archive to Table problem Reply with quote

: Do you have permissions to select from sysusers? Was the database restoed
: from backup and db owner not set after that?

Yes, I have admin permission . It's not restored form backup and Db ownwer is there.
Any idea what's goin on ?

Wed Jan 25, 2006 9:28 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Archive to Table problem Reply with quote

Yes, what happens is that select from sysusers or sysobjects tables fails. Take a look if you have db_audit.err file in the DB audit installation directory. If it is there open the file in Notepad and check for error messages.

: Yes, I have admin permission . It's not restored form backup and Db ownwer is
: there.
: Any idea what's goin on ?

Thu Jan 26, 2006 12:40 am View user's profile Send private message
Raymond



Joined: 16 Jan 2006
Posts: 6

Post Re: Archive to Table problem Reply with quote

: Yes, what happens is that select from sysusers or sysobjects tables fails.
: Take a look if you have db_audit.err file in the DB audit installation
: directory. If it is there open the file in Notepad and check for error
: messages.

Here is the message in db_audit.err:

*** 1/26/2006 16:29:13

User:

Server: smartit

Database: master

DBCode: 207

SQLCode: -1

SQLErrText: Select error: invalid column name 'suid'¡C

SQL: SELECT name owner FROM sysusers WHERE isNull(suid, 0) > 0 ORDER BY 1

Thu Jan 26, 2006 5:18 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Re: Archive to Table problem Reply with quote

Here you go. Are you connecting to the server as sa? Do you have a non-system view or table with sysusers name?

: Here is the message in db_audit.err: *** 1/26/2006 16:29:13

: User: Server: smartit

: Database: master

: DBCode: 207

: SQLCode: -1

: SQLErrText: Select error: invalid column name 'suid'¡C

: SQL: SELECT name owner FROM sysusers WHERE isNull(suid, 0) > 0 ORDER BY 1

Thu Jan 26, 2006 10:05 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.