Strange Msg 208, Level 16... output

Question

Strange Msg 208, Level 16... output

jerry-621596

SSCertifiable

Points: 6096
More actions
July 28, 2010 at 1:54 pm

#223842

I have a stored procedure create script that works on a database. I am trying to recreate the DB schema locally and get the following error when I run the script:
Msg 208, Level 16, State 1, Procedure ddl_SchemaModified, Line 5
Invalid object name 'SchemaAudit..DDLInfo'.
I cannot find a reference to ddl_SchemaModified or SchemaAudit..DDLInfo anywhere, including Microsoft.com AND Google.
Anyone else see this before and maybe even solved the issue?
Thansk!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Sounds like someone's written a custom DDL trigger, either as a database-level trigger in the DB you're recreating or as a server-level trigger.

It's not a built-in object, it's something specific to your instance.

select * from sys.server_triggers

SELECT * FROM sys.triggers WHERE parent_class_desc = 'DATABASE'

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 2

I will look into that. Inherited the db a couple of months ago and haven't found everything yet.

Thansk!

Jerry

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 3

Wow! The ddl_SchemaModified one is a database trigger. Good call!

Thanks for the help.

Jerry