Hi it sounds like the user that you are connecting with does not have sufficent permissons. SQL Data Generator uses the Same object model as SQL Compare so will need the permissions as are suggested in this knowledge article
If having more permissions doesn't fix the problem then please let me know and I will suggest something new. I will add a bug to our bug tracking system that we should give a much better error message in that area as that message is awful!
on one sql server:
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
Microsoft SQL Server 2005 - 9.00.3228.00 (Intel X86) Feb 9 2008 09:47:16 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
Both of them the same problem on application adatabases
I do not receive the same error on a new created database with only a few tables.
Thanks a lot. I have found the problem and have emailed you a fix. If anyone else has this problem then please email firstname.lastname@example.org and they will give you a patch. The fix will apear in SQL Data Generator 1.1.