Results 1 to 2 of 2

Thread: Error Thrown

  1. #1
    Join Date
    Nov 2006
    Posts
    34

    Red face Unanswered: Error Thrown

    Hi All,

    Stored procedure '"$monTables"' not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).
    Msg: 2812, Level: 16, State: 5
    Server: loopback, Line: 1 


    i got the above error when i try to execute the following query

    select * from master..monTables

    can you help

    the below is the output from sysobjects table.

    name
    ----------------------
    ijdbc_function_escapes
    jdbc_function_escapes
    monCachePool
    monCachedObject
    monCachedProcedures
    monDataCache
    monDeadLock
    monDeviceIO
    monEngine
    monErrorLog
    monIOQueue
    monLocks
    monNetworkIO
    monOpenDatabases
    monOpenObjectActivity
    monProcedureCache
    monProcess
    monProcessActivity
    monProcessLookup
    monProcessNetIO
    monProcessObject
    monProcessProcedures
    monProcessSQLText
    monProcessStatement
    monProcessWaits
    monProcessWorkerThread
    monState
    monSysPlanText
    monSysSQLText
    monSysStatement
    monSysWaits
    monSysWorkerThread
    monTableColumns
    monTableParameters
    monTables
    monWaitClassInfo
    monWaitEventInfo
    mon_authorize_non_sa
    mon_rpc_attach
    mon_rpc_connect
    sp_aux_getsize
    sp_configure
    sp_dboption
    sp_dbupgrade
    sp_dropdevice
    sp_getmessage
    sp_loaddbupgrade
    sp_procxmode
    sp_prtsybsysmsgs
    sp_validlang
    spt_ijdbc_conversion
    spt_ijdbc_mda
    spt_ijdbc_table_types
    spt_jdbc_conversion
    spt_jdbc_table_types
    spt_jtext
    spt_limit_types
    spt_mda
    spt_monitor
    spt_values
    syblicenseslog
    sysalternates
    sysattributes
    syscertificates
    syscharsets
    syscolumns
    syscomments
    sysconfigures
    sysconstraints
    syscurconfigs
    sysdatabases
    sysdepends
    sysdevices
    sysengines
    sysgams
    sysindexes
    sysjars
    syskeys
    syslanguages
    syslisteners
    syslocks
    sysloginroles
    syslogins
    syslogs
    syslogshold
    sysmessages
    sysmonitors
    sysobjects
    syspartitions
    sysprocedures
    sysprocesses
    sysprotects
    sysqueryplans
    sysreferences
    sysremotelogins
    sysresourcelimits
    sysroles
    syssecmechs
    syssegments
    sysservers
    syssessions
    syssrvroles
    sysstatistics
    systabstats
    systestlog
    systhresholds
    systimeranges
    systransactions
    systypes
    sysusages
    sysusermessages
    sysusers
    sysxtypes


    Thanx n advance
    Arun

  2. #2
    Join Date
    Nov 2006
    Posts
    34

    error thrown

    Hi All,
    Im checked in the machine where sybase installed by using sql advantage it s working but if i use a java code or any other remote tool to execute the same query it throws the above error

    pls help..........

    bye
    Arun

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •