Deployment error with oddly named stored procedure.


Author
Message
Aaron Young
Aaron Young
StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)StrataFrame User (439 reputation)
Group: StrataFrame Users
Posts: 277, Visits: 1.1K
Hi,

I get the following error when deploying a package. Apart from the error message, the database appears to deploy correctly. The error refers to a stored procedure called [dbo].[] and I do indeed have two odd looking stored procedures in among the automatically generated security stored procedures. The attached screenshot shows them and you can see they were generated nearly 4 minutes after the security procedures.

As they have no names I assume they are a corruption. Is it safe to delete them?

Thanks in advance.

X 04/06/2008 01:09:09 -> An error occurred while creating the stored procedure [dbo].[].
X 04/06/2008 01:09:09 -> SqlException       
X 04/06/2008 01:09:09 ->   An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.        
X 04/06/2008 01:09:09 ->        
X 04/06/2008 01:09:09 -> Source     : .Net SqlClient Data Provider       
X 04/06/2008 01:09:09 ->        
X 04/06/2008 01:09:09 -> Stack Trace:        
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()       
X 04/06/2008 01:09:09 ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)       
X 04/06/2008 01:09:09 ->        
X 04/06/2008 01:09:09 -> An error occurred while creating the stored procedure [dbo].[].
X 04/06/2008 01:09:09 -> SqlException       
X 04/06/2008 01:09:09 ->   An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Add a name or single space as the alias name.        
X 04/06/2008 01:09:09 ->        
X 04/06/2008 01:09:09 -> Source     : .Net SqlClient Data Provider       
X 04/06/2008 01:09:09 ->        
X 04/06/2008 01:09:09 -> Stack Trace:        
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)       
X 04/06/2008 01:09:09 ->    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()       
X 04/06/2008 01:09:09 ->    at MicroFour.StrataFrame.DBEngine.SQL.DatabaseMigrator.DeploySprocsOfPriority(Database parent, DatabaseInfo dbInfo, Int32 priority)       
X 04/06/2008 01:09:09 ->        

Attachments
Capture.JPG (199 views, 42.00 KB)
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search