To Cathy Liu and Kelly Chen,
Thanks for the response…
I am going with address both issues at the same time for they are related.
Kelly, thanks I see that you understand the problem…
Cathy,
n Reference : http://www.toadworld.com/products/toad-for-sql-server/f/14/p/22482/48382.aspx#48382
n The problems are related, because of the Characters in the fully qualified database and table name.
o The syntax generated by the ALTER command using Toad SS 6.1 generates an error.
o Look at the table below my signature and in the attached file to see the error
o Use the attached file to recreate the problem on dropping the table default value
§ This is clearly reproducible and IT SHOULD BE NOTED that the brackets are present on the ADD default value but NOT the DROP syntax.
Kelly Chen
Cathy.Liu
From: Kelly.Chen [mailto:bounce-KellyChen@toadworld.com]
Sent: Thursday, August 14, 2014 11:10 PM
To: toadss@toadworld.com
Subject: RE: [Toad for SQL Server - Discussion Forum] Import Wizard not handling Ddatabase name where there are special characters.
RE: Import Wizard not handling Ddatabase name where there are special characters.
Reply by Kelly.Chen
Hi,
Thank you very much for your support. This is really a issue. And we have create TSS-638 for it.
Best regards,
Kelly
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for SQL Server - General notifications altogether.
Toad for SQL Server - Discussion Forum
Flag this post as spam/abuse.
From: Cathy.Liu [mailto:bounce-CathyLiu@toadworld.com]
Sent: Thursday, August 14, 2014 11:06 PM
To: toadss@toadworld.com
Subject: RE: [Toad for SQL Server - Discussion Forum] Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name
RE: Toad SQL Server Alter command Not creating proper Drop syntax. Missing brackets on object name
Reply by Cathy.Liu
Hi,
I can’t reproduce this issue, Here is my step:
1.I have create a table named DailyReportData_REL_3.2.2_LastCSV ,
2.add constraint for it(Alter table| Constratint tabe).
No matter I create constraint or drop it ,I can see the brackets.
Please point out if I do somthing different with your step?
Thanks,
Cathy.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or Unsubscribe from Toad for SQL Server - General notifications altogether.
Toad for SQL Server - Discussion Forum
Flag this post as spam/abuse.
The Table below had a default value associated with a column.
The TableName has special characters in the name “Rel_3.3.2” which need to be put into brackets.
TABLE[dbo].[DailyReportData_REL_3.2.2_LastCSV]
DROP CONSTRAINT DF_DailyReportData_REL_3.2.2_LastCSV_ACN_Number
–The above syntax is incorrect and fails on the Drop Constraint due to the 'Rel_3.2.2" or periods.
