"Generate scripts" pins CPU @ 100% RRS feed

  • Question

  • Does anyone know why this is happening or how I can avoid it?  When I generate scripts for a db (on my local machine, developer edition, 2005 SP2), I choose the default options (right click db, generate scripts), and just table objects, and when I hit finish, it takes 5-10 seconds per table, and my CPU utilization shoots to 100% and stays there for the duration.  Very annoying as it takes about 5-10 minutes to generate scripts.  On other machines I've worked with, this has not been the case, so I'm wondering what I'm doing wrong here on this particular machine.  Anyone else had this happen?

    Monday, August 20, 2007 1:20 PM