Wednesday, June 10, 2009

SqlPubWiz Fail

I didn't think I'd talk so much about Sql Server features, but I'm stuck on that topic at the moment because of a current project. Nonetheless, I'm sure countless people need help with such things.

I was attempting to script out a blank database, so that I could get the delete order of the many tables correctly. SqlPubWiz is great in that it does this all for you, by putting the tables in the correct delete sequence based on foreign key constraints. Certainly not something you'd want to do in your spare time!

Anyway, I kept getting the following error:
Timeout expired. The timeout period elapsed prior to obtaining a connection form the pool. This may have occured because all pooled connections were in use and max pool size was reached.
Sorry? I've been in the pool too long and I'm pruning? All that's going on is that it's unhappy that you don't have any data in tables. Simple as that. It doesn't like the empty tables. But when you take a look at your output script, you'll see that it has nicely added the delete portion in the right order.

Resolution: Another error message fail.

3 comments:

  1. Did you manage to find a workaround for this behaviour?

    ReplyDelete
  2. I have this problem too. Tried everything, nothing works

    ReplyDelete
  3. if anyone is still watching, you can add Max Connections=200 to your connection string. I am looking for a way to change the default of 100 but I have thus far been unsuccessfull

    ReplyDelete