Procedure Creation Problem - SQL Server Forums

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)

Procedure Creation Problem

Author

Topic

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2010-01-21 : 07:34:06

Hi,
I have restored one sql 2008 database dump (both source and destination were sql2008) .when i try to
create a new Stored procedure the below error is thrown:


Msg 208, Level 16, State 1, Procedure Trace_Create_procedures, Line 17
Invalid object name 'live_prfdb..Trace_Create_table'.

can anyone help me?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-21 : 07:59:45

And this:
Invalid object name 'live_prfdb..Trace_Create_table'
says nothing to you?
We cannot see anything from here...

No, you're never too old to Yak'n'Roll if you're too young to die.

Kristen
Test

22859 Posts

Posted - 2010-01-21 : 08:02:14

There is no table (well, object, but I presume you are trying to access it as a table?) called Trace_Create_table in the database "live_prfdb"

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2010-01-21 : 09:26:35

Thanks for your reply..

even when I tried to create one sampe procedure as shown below ,the same error only thrown


create procedure test
as
begin
set nocount on

select 'Test'

set nocount off
end

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-21 : 09:33:17

Have a look at database triggers!

No, you're never too old to Yak'n'Roll if you're too young to die.

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2010-01-21 : 09:43:58

quote:
Originally posted by webfred

Have a look at database triggers!

No, you're never too old to Yak'n'Roll if you're too young to die.

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2010-01-21 : 09:47:35

through profiler tool i have checked, no trace were coming..

Database collation is different,might be due to this the error thrown?

quote:
Originally posted by sent_sara

quote:
Originally posted by webfred

Have a look at database triggers!

No, you're never too old to Yak'n'Roll if you're too young to die.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-21 : 10:02:16

I don't know if you can see a database trigger via profiler...
But you can do the following:

expand the '+'-sign at your database in object explorer
expand the '+'-sign at Progammability
then have a look if there is a database trigger that was fired by your create statement.
maybe this trigger needs some objects which are not part of your restored database.

No, you're never too old to Yak'n'Roll if you're too young to die.

Peter99
Constraint Violating Yak Guru

498 Posts

Posted - 2010-01-21 : 16:46:51

open a new query window and run your script.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-01-21 : 16:56:59