CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011
    Posts
    63

    [RESOLVED] code thinks deleted stored procedure still exists

    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:

    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.

  2. #2
    Arjay's Avatar
    Arjay is offline Moderator / EX MS MVP Power Poster
    Join Date
    Aug 2004
    Posts
    13,490

    Re: code thinks deleted stored procedure still exists

    How are you connecting to the database? By file? Connection string? Are you pointing to the same database in code as you are when you deleted the sproc?

  3. #3
    Join Date
    Nov 2011
    Posts
    63

    Re: code thinks deleted stored procedure still exists

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured