SQL Server Performance Forum – Threads Archive
deleting column from E.M.
why do i get an error when try to delete a non-keyed column from Enterprise Manager? "incorrect syntax near ‘fieldname’"The message is the same using EM from different PC?
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
yes. also same from Query Analyzer.
I suggest to wait others oppions, what came to my mind is reinstall SP.
Luis Martin …Thus mathematics may be defined as the subject in which we never know what we are talking about, nor whether what we are saying is true.
Bertrand Russell
what command are you using for the delete from QA?
yes, without knowing the statement, all advice would be like a shot in the dark Frank
http://www.insidesql.de
http://www.familienzirkus.de
using Enterprise Manager, go to table, design, click on column, delete. gets error.
Refer to this KBAhttp://support.microsoft.com/default.aspx?scid=/servicedesks/bin/kbsearch.asp?Article=273813 to fix the issue. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
I would use sp_rename <your_table>,<new name>,’column’ to first rename that column to something simple and then try to delete that column. Frank
http://www.insidesql.de
http://www.familienzirkus.de
There are sometimes other, tiny little ‘gotchas’ like the one in the MS article,which is why I wanted the exact statement you used in QA or your entire table structure. I know the process for deleting a column from EM, so that wasnt the issue.
This would let us know if any of your field names, or something else in your table itself managed to find one of the neat little ‘features’ in sql. Also, what version of sql including service pack. Its better to give too much information, than not enough. chris
Yes, as a basic information atleast mentioning SQL & SP version will always help to give right answer. Otherwise it takes bit long to assume/provide solution. But its better to use TSQL for such administrative tasks rather than depending on EM, but few times its compulsory to use GUI tool. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
same error when using T-SQL to drop the column.
WHat is the MDAC version and Service pack level? _________
Satya SKJ
Moderator
SQL-Server-Performance.Com
What is the actual column name? Is it a reserved keyword? Tom Pullen
DBA, Oxfam GB
bfarr, please post your T-sql delete query in its entirety along with your full table struture, indexes and foreign keys. Otherwise we are just guessing. chris
Well, now the only chance we have is when you post DDL of your table and the T-SQL you used to drop the column. Reminds me of some strange issue a while back with a column name starting with a # Frank
http://www.insidesql.de
http://www.familienzirkus.de
]]>