Cannot delete stored procedure

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)

Cannot delete stored procedure

Author

Topic

Ciupaz
Posting Yak Master

232 Posts

Posted - 2012-03-23 : 05:10:34

Hello all,
in my SQL Server 2008 I cannot delete a stored procedure, because I got this error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for StoredProcedure 'app.UnitaEssenziali.Reportistica.GetProveDiLegge'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+StoredProcedure&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

INSERT failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. (Microsoft SQL Server, Error: 1934)

Why this happens?

The stored procedure was created by myself.

Thanks a lot.

Luigi

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2012-03-23 : 05:51:02

There is probably some audit procedures logging your delete, which can't cope with your procedure.

N 56°04'39.26"
E 12°55'05.63"