code thinks deleted stored procedure still exists

[gib99]

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:

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.

 

[adamroof]

Hmm, try the simple stuff... are you sure you are hitting the right database? Not a test copy somewhere else?
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!

 

[gib99]

Turned out I was creating them in the wrong database. Problem solved.