Solved

Auto-generate Dummy Records (SQL Server)

Posted on 2006-11-21
7
719 Views
Last Modified: 2012-05-05
I need to populate a SQl Server 2005 table with dummy records.  My boss says this is a new 2005 feature, and I cannot use SQL statements. Any Ideas???
0
Comment
Question by:servicegroup
  • 4
  • 3
7 Comments
 
LVL 8

Accepted Solution

by:
drydenhogg earned 500 total points
ID: 17988323
If the feature exists, I have never come across it, I would ask your boss to substanciate his claim. What makes it even more bizarre is to suggest it is a SQL Server feature, but that you are not to use SQL Statements to do it.

I'd be a very happy man if it existed, that's for sure.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 17988566
She assured me that this feature exists, and a coworker witnessed the presentation.
0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 17988683
Sounds like the 'presentation' is possibly from someone (vendor) with a product.

Thinking outside of SQL Server, I can't remember the datadude ctp's having it, and Im trying to think whether perhaps they are thinking of something from visual studio team studio - test edition, there are test generation tools in that, in terms of creating code coverage through automatic parameter generation. Possibly they have seen a dmeonstration of something in that?



0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 3

Author Comment

by:servicegroup
ID: 17988815
It was a microsoft conference, and they assured me it was done on SQL Server, not VS.
0
 
LVL 8

Expert Comment

by:drydenhogg
ID: 17988858
Drawing a blank then, nothing in SP2 added to do this that I have seen, not seen it as a base feature of 2005 - be a very happy man if it exists as a current feature, or is due in sp2 etc.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 17988894
Thanks. I will post any good news.
0
 
LVL 3

Author Comment

by:servicegroup
ID: 18028180
SQLIS.com has a record generator for use in the Business Intelligence Development Studio, but it only creates string and numeric fields.  I guess it might be useful if you were not creating tables for the real world.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now