code thinks deleted stored procedure still exists
code thinks deleted stored procedure still exists
(OP)
Hello,
I'm writing some code to create stored procedures in a database. In order to test it out, I deleted a stored procedure (right clicking in
SQL Server 2008 and clicking on delete) and then ran my code to see if it would create it.
My code looks like this:
database.GetProcedure(node.name) basically gets a string containing the SQL script to create the stored procedure.
command.ExecuteNonQuery() throws an SqlException that says: "There is already an object named 'SecuritySession_DeleteSessionById' in the
database." But I deleted it! Why does it think it's still there?
Thanks for any help.
I'm writing some code to create stored procedures in a database. In order to test it out, I deleted a stored procedure (right clicking in
SQL Server 2008 and clicking on delete) and then ran my code to see if it would create it.
My code looks like this:
CODE
SqlCommand command = new SqlCommand(); SqlConnection conn = database.TypeLibraryDatabaseConnection; command.Connection = conn; // create the command to create the stored procedure command.CommandText = database.GetProcedure(node.Name); // create the stored proc in the database try { command.ExecuteNonQuery(); } catch { } command.Dispose();
database.GetProcedure(node.name) basically gets a string containing the SQL script to create the stored procedure.
command.ExecuteNonQuery() throws an SqlException that says: "There is already an object named 'SecuritySession_DeleteSessionById' in the
database." But I deleted it! Why does it think it's still there?
Thanks for any help.
RE: code thinks deleted stored procedure still exists
Does 2008 tombstone deletions? I've been using 2008 mgmt studio, but not 2008 server so I dunno about that.
When you are looking at your connection, double check you arent hitting master, look in master database procedures to see if its in there?
If GetProcedure is a script that creates the proc, are you sure that its not actually creating the proc already?
Good luck!
RE: code thinks deleted stored procedure still exists