#10750: Quote identifier missing in trigger source body for table name in sql server 2005.

nileshhmali reported 2013-11-12T12:58:55Z · swissarmyknife(*) last modified 2014-06-23T17:47:21Z

Dev	JohnLH
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	App - Visual Editing
Version	Future - 0.1

Database version: Ms sql server 2005

ADS version : ads-windows-x64-15.0-dev-34

Connect sql server 2005

Create trigger

CREATE TRIGGER [dbo].[Test_trigger]

ON dbo.Table_1

FOR INSERT

INSERT INTO [dbo].[Table_2]([col1],[col2],[col3])

VALUES (1,'nil','mumbai')

Go to trigger node->Right click on [dbo].[Test_trigger]->select alter trigger.->open alter window.

Now you will observe that quote identifier missing for table name and schema name(dbo.Table_1)

Reference : For reference screenshots are attached(screenshot-1)

CREATE TRIGGER [dbo].[Test_trigger1]

ON [dbo].[Table_2]

FOR INSERT

INSERT INTO [dbo].[Table_1]([col1],[col2],[col3])

VALUES (11,'sachin','pune')

Go to trigger node->Right click on [dbo].[Test_trigger1]->select alter trigger.->open alter window.

Now you will observe that quote identifier is missing for schema name(dbo.Table_2)

Reference : For reference screenshots are attached(screenshot-2)

All Comments (0) Change History