Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Invalid object name 'DDLTriggerTest..EventTableData'.


Invalid object name 'DDLTriggerTest..EventTableData'.

Author
Message
Feebie
Feebie
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
Points: 41 Visits: 51
hi,

when u tried to modify the procedure then it gives me error like this...

Procedure tr_ProcedureEvents, Line 6
Invalid object name 'DDLTriggerTest..EventTableData'.


please let me know what causes this error and how to resolve that.
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14973 Visits: 38993
Feebie (11/2/2009)
hi,

when u tried to modify the procedure then it gives me error like this...

Procedure tr_ProcedureEvents, Line 6
Invalid object name 'DDLTriggerTest..EventTableData'.


please let me know what causes this error and how to resolve that.


someone has put a DDL trigger on your database, and it's trying to update a table 'EventTableData' in the database 'DDLTriggerTest'
I'd guess that both the database and thus the table are missing, so the trigger errors out.

in SSMS go to your Server and browse to ServerObjects>>Triggers.

you'll need to disable or drop the trigger in question.

If it's not there, it might be at the database level...Specific Database>>Programmability>>Database Triggers

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Feebie
Feebie
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
Points: 41 Visits: 51
hi,

thank you for quick reply.

so that is not a system default trigger?
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14973 Visits: 38993
lol no, MS does not issue any default system triggers, that's for sure...also you can kind of tell by the name:'DDLTriggerTest'

definitely some trying out some code.

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Feebie
Feebie
SSC Rookie
SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)SSC Rookie (41 reputation)

Group: General Forum Members
Points: 41 Visits: 51
Smile thank you for your help.

i am new to SQL...
shaundwyer
shaundwyer
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 12
Can someone please help me with this in the objectname column I am getting this getting this "IFTSAutonested"

I have done a lot of searching and cannot find the meaning of it. I have a reason to believe it is causing my database to freeze.
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14973 Visits: 38993
Select from sys.triggers and sys.server_triggers. based on the brief description you gave plus the fact the.name contains "nested " you might have a trigger that blocks itself as well as other transactions, post the trigger in a new thread and we can offer suggestions to fix the design glitch that is locking things up

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shaundwyer
shaundwyer
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 12
can you give me the description on how to disable this? As its causing issues on the Master instance.
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14973 Visits: 38993
more details from you before we can help, i think.

you really need to analyze the trigger itself, and fix the issue;

for example, if there is a trigger on a table that is calling itself in a nested fasion, that trigger needs to be rewritten; simply dropping the trigger might have unintended side affects, like wher the trigger is inserting data the application expects to exist...if the data doesn't get added.


If it's a database or server level trigger, then you again need to analyze the trigger, and either modify or disable the trigger

ie
DISABLE TRIGGER [TR_DB_NO_DROPPING_OBJECTS] ON DATABASE
--or if it was a server trigger
DISABLE TRIGGER logon_trigger_not_from_SSMS ON ALL SERVER



Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

shaundwyer
shaundwyer
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 12
the example I have is that. when a simple copy command is been sent to the file server it gets blocked and the communication between SQL and file server gets fails causing a que on the rest of the nodes which then is forcing the software we are working on to freeze. From looking at the profiler on SQL this AutoNested was showing up in the time frame from which this the whole process froze. It was only happening in the Master database.

then it seems to unblock its self after about 10 minutes on the both occasions its happened.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search