# Strange problem with Data Generator **URL:** \ **Category:** Toad for SQL Server\ **Created:** [January 3, 2018, 2:40am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415 "2018-01-03T02:40:35Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 3, 2018, 2:40am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/1 "2018-01-03T02:40:35Z")
I use Toad for SQL Server 6.8.1.204 (32 bit). I open it and without connect to any DB’s I select menu voice - TOOLS - DATA GENERATOR - .At this point I select create a new project from database. I attach a screenshot for details : ![toad_add_db.jpeg](https://global.discourse-cdn.com/quest/original/2X/3/334634d94451872f99bc424e40011bf7aed415ae.jpeg) I insert a valid credential and I select refresh button, but nothing to do. I can’t select a DB. How can I use a tool like this ? In past I open other request/bug about Data Generator, but today I have the same problem. I stay tune for your consideration, Best regards, Sergio ---
**Author:** ![Martin.Wild](https://avatars.discourse-cdn.com/v4/letter/m/e56c9b/32.png) [@Martin.Wild](https://forums.toadworld.com/u/Martin.Wild)\ **Post date:** [January 4, 2018, 7:43am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/2 "2018-01-04T07:43:01Z")
Have you tried connecting to the database and selecting a table in Object Explorer, right click and data generator? ---
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 4, 2018, 7:52am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/3 "2018-01-04T07:52:22Z")
Hi Martin, many thank's for your answer. This is the results after follow your suggestions. I attach a screenshot of the result : ![toad_error_data_gen.jpeg](https://global.discourse-cdn.com/quest/original/2X/d/d2b7e087b5bcb6965d465691f2db970cd188ebd5.jpeg) As you can see I obtain an error. Have you some others idea ? Best regards, Sergio ---
**Author:** ![Martin.Wild](https://avatars.discourse-cdn.com/v4/letter/m/e56c9b/32.png) [@Martin.Wild](https://forums.toadworld.com/u/Martin.Wild)\ **Post date:** [January 4, 2018, 8:17am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/4 "2018-01-04T08:17:54Z")
If you right click on the table and perform View Details, does that work? What are the details of the table, number of columns and data types? What version of SQL Server are you connected to and if SQL 2017 what OS? ---
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 4, 2018, 8:23am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/5 "2018-01-04T08:23:15Z")
Hi Martin, yes I can right click on the table and view details without problems. I attach a script of the table. As you can see itìs a simple table : CREATE TABLE [dbo].[Price] ( [ProductID] int NOT NULL, [LastUpdate] date NOT NULL, [Price] smallmoney NULL, [Qty] int NULL, CONSTRAINT [PK\_\_Price\_\_B40CC6EDEF1FA2F8] PRIMARY KEY CLUSTERED ([ProductID] ASC) WITH ( PAD\_INDEX = OFF, FILLFACTOR = 100, IGNORE\_DUP\_KEY = OFF, STATISTICS\_NORECOMPUTE = OFF, ALLOW\_ROW\_LOCKS = ON, ALLOW\_PAGE\_LOCKS = ON, DATA\_COMPRESSION = NONE ) ON [PRIMARY] ) ON [PRIMARY]; GO ALTER TABLE [dbo].[Price] SET (LOCK\_ESCALATION = TABLE); GO I use SQL Server 2012 with service pack 4 Developer edition at 64 bits and my operating system is windows 7 professional at 64 bits with service pack 1 plus last windows update in italian language. Best regards, Sergio ---
**Author:** ![Martin.Wild](https://avatars.discourse-cdn.com/v4/letter/m/e56c9b/32.png) [@Martin.Wild](https://forums.toadworld.com/u/Martin.Wild)\ **Post date:** [January 4, 2018, 1:07pm UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/6 "2018-01-04T13:07:47Z")
Hi Sergio, yes there is a problem, we are looking into it. I will respond when I get a resolution for you. Thanks, Martin ---
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 4, 2018, 1:57pm UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/7 "2018-01-04T13:57:19Z")
Hi Martin, I hope to see my problem solved. Every time I try to use data generator tool I can’t use it. I hope to see more usability and stability in data generator for the future. Last year I’ve signaled another annoying bug and now is still present… I stay tune for your consideration. Best regards, Sergio ---
**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\ **Post date:** [January 4, 2018, 6:03pm UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/8 "2018-01-04T18:03:35Z")
Hi Sergio, Yes, there was problems in Data Generator. we have create defectID TSS-1494 for this, it should be fix soon. Michael ---
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 4, 2018, 11:33pm UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/9 "2018-01-04T23:33:46Z")
Hi Michael, it’s from 2 years that I can’t use Data Generator tool. In the past, January 2016, I’ve open another case. This is the link : [http://www.toadworld.com/products/toad-for-sql-server/f/14/t/27259](http://www.toadworld.com/products/toad-for-sql-server/f/14/t/27259) I test it with new version of beta version of TOAD SS 6.9 and the problem is still present. Every time I want to use it I can’t. It’s not normal… Why do you release a tool if I can’t use it ? Initially I can understand some problems. It’s normal with new feature… But not after 2 years. It’s from 2 years that I wait to a fix for my problem with data generator… I stay tune for your consideration. Best regards, Sergio ---
**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\ **Post date:** [January 5, 2018, 1:29am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/10 "2018-01-05T01:29:26Z")
Hi Sergio, Have you try our new beta build for v6.9 ? you can download from : [http://www.toadworld.com/products/toad-for-sql-server/toad\_for\_sql\_server\_beta\_program/](http://www.toadworld.com/products/toad-for-sql-server/toad_for_sql_server_beta_program/) Michael ---
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 5, 2018, 2:05am UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/11 "2018-01-05T02:05:29Z")
Hi Michael, I try to new beta of TOAD SS 6.9. Now I can connect to data generator without problems, but the problem that I’ve singled 2 years and underline 2 years ago - [http://www.toadworld.com/products/toad-for-sql-server/f/14/t/27259](http://www.toadworld.com/products/toad-for-sql-server/f/14/t/27259) - is still present !!! For me is important to solve this… I appreciate too much your interesting in my problem but for use Data Generator Quest’s developers must solve my problem. I stay tune for your consideration, Best regards, Sergio ---
**Author:** ![michael](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@michael](https://forums.toadworld.com/u/michael)\ **Post date:** [January 7, 2018, 7:24pm UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/12 "2018-01-07T19:24:24Z")
Hi Sergio, We found TSS-1226 for this issue, and i have set High Priority for you. it will be fix soon. Thanks, Michael ---
**Author:** ![s.bertolotti](https://avatars.discourse-cdn.com/v4/letter/s/dc4da7/32.png) [@s.bertolotti](https://forums.toadworld.com/u/s.bertolotti)\ **Post date:** [January 7, 2018, 11:55pm UTC](https://forums.toadworld.com/t/strange-problem-with-data-generator/40415/13 "2018-01-07T23:55:08Z")
Hi Michael, many thank’s for set the TSS-1226 to high priority. Best regards, Sergio