Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Getting Error while adding column in stored proced

Author  Topic 

pavansql2005
Starting Member

1 Post

Posted - 2014-09-18 : 12:47:27
Hi Team,

i am adding one new column into stored procedure, iam getting below error.here i am adding "MIS Project Code" is column name.
error:
Msg 6522, Level 16, State 1, Procedure usp_EnablonWebService_ExportData, Line 0
A .NET Framework error occurred during execution of user-defined routine or aggregate "usp_EnablonWebService_ExportData":
System.Web.Services.Protocols.SoapHeaderException: Unknown XML Tag "MIS Project Code".
System.Web.Services.Protocols.SoapHeaderException:
at StoredProcedures.usp_EnablonWebService_ExportData(String Url, String EnaUserName, String EnaPassword, String Table, Int32 FolderId, String Fields, String Filter, Int32 CSVSeparator, Int32 FormatOptions, Int32 FormatType, Int32 ExportOptions)
.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-18 : 14:12:20
Are you getting that error from SSMS or some other client tool? Try adding the column in SSMS. Also post the code if you want us to help.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -