Hi People,

Can any one tell me if I have to leave the connection open when reusing a prepared statement or if I can close the connection completely and destroy all objects to the database and then later the compiled statement is still available to me?

Do I have to keep the SqlCommand object alive and the reuse that specifically?

How long does SQL server remember this precompiled statement for me or to put it another way when does it know that it can delete this prepared statement?

I'm working with .NET 2.0.

Thanks for your time,

Delboy