Hi All,

I'm trying to drop an sqlserver database from c# but can't because it is
claiming it is in use. As I don't have a connection to it it must be
connection pooling that is causing the problem. I can test this by disabling
connection pooling and the database can be dropped. Is there any way to
clear out the connection pool? I can't disable connection pooling as my app
uses it. Some sample code is below

Thanks
Michael

       private void DoIt()
       {
           Execute("CREATE DATABASE ABC");
           //remove this next line and it works
           Execute("SELECT * FROM sysobjects", "ABC", false);
           Execute("SELECT * FROM sysobjects", "ABC", true);
           Execute("DROP DATABASE ABC");
       }

       private void Execute(string SQL)
       {
           Execute(SQL, "", false);
       }

       private void Execute(string SQL, string Database, bool NoPooling)
       {
           string connect = "Data Source=(local);Integrated
Security=SSPI;";
           if (Database.Length > 0) connect += "Initial Catalog=" +
Database + ";";
           if (NoPooling) connect += "Pooling=False;";
           SqlConnection connection = new SqlConnection(connect);
           connection.Open();
           SqlCommand command = new SqlCommand(SQL, connection);
           command.ExecuteNonQuery();
           command.Dispose();
           connection.Close();
       }