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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 cannot creat stored procedure on existing database

Author  Topic 

liheran
Starting Member

2 Posts

Posted - 2008-05-15 : 11:05:56
Hi, I already got a database and I need to add another stored procedure on it in order to call it from the SSIS package.
But when I execute the sql file to create the procedure, there is a error message popping out like:

"Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'logit'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists."

And I have tried it on another computer, there is the same error. Could you please tell me how to solve the problem. Thanks very very much.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 11:07:56
Does 'logit' table exists in your database?
Go to Top of Page

liheran
Starting Member

2 Posts

Posted - 2008-05-15 : 11:25:37
To sodeep,

Where can I find the logit table.
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 11:28:06
To liheran

Are you using logit table inside SP?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-05-15 : 22:37:03
>> Where can I find the logit table.

Check db where you put the sp into.
Go to Top of Page
   

- Advertisement -