KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
So, not sure what is happening. But I have stored procedure and it keeps disappearing out of my DB in SQL 2k. I can add it again and then try to execute it from my web app and i get an exception saying the stored procedure cant be found. So then ill go back to management and refresh and its gone again !?! here is the config for the stored proc: set ANSI_NULLS OFF set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[USP_Equipment_Delete] @EquipmentID int AS DELETE FROM [dbo].[Equipment] WHERE [EquipmentID] = @EquipmentID None of my other stored procedure disappear. This is the only one. I have easily 100 in there. They all use the same SQLHelper class. This one just keeps disappearing!!!??!! Any help or suggestions are appreciated! Thanks so much!
Tags (comma-separated)
Save Edits
Cancel