Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ronie
Starting Member
2 Posts |
 Posted - 2008-09-02 : 21:14:57
|
| Dear experts,I have one pending issues with regards to stored procedure in SQL 2000 environment. My management requested that I find out the root cause of this so-called "phenomena". A bit weird, and I tried to find from the internet as well, still inconclusive. Hope someone can help me out.Thanks.Description of Issue: Users encountered the following error when they clicks on one of the hyperlink within the system:“Could not find stored procedure ‘tasklist_process’” Observation:It seems that only this stored procedure cannot be found by the JDBC driver. However, the stored procedure can be seen in the SQL Server Enterprise Manager view. This rules out that the stored procedure was removed by anybody. It is also not the application process error or driver error. How we restore the service:Script and execute the stored procedure ‘tasklist_process’. The execution removes and adds the object into the SQL Server database. The scripting was done from the same production database. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ronie
Starting Member
2 Posts |
Posted - 2008-09-03 : 04:16:01
|
| Tara,No they are not using objectowner.table_name. may I know what's the impact if we are not using the objectowner.table_name. It's good if I have the rationale..Thanks |
 |
|
|
|
|
|
Questions with stored procedure