Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Visual Studio Database Tools Expand / Collapse
Author
Message
Posted Wednesday, March 02, 2011 11:28 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:03 AM
Points: 877, Visits: 185
Comments posted to this topic are about the item Visual Studio Database Tools

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson
Post #1072354
Posted Wednesday, March 02, 2011 11:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 12:28 AM
Points: 2,170, Visits: 3,583
Another good question. Questions are getting tough to crack these days

Mohammed Moinudheen
Post #1072355
Posted Thursday, March 03, 2011 2:04 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378, Visits: 6,473
Good question Jamie.
I got it correct because I found your issue on Connect:

https://connect.microsoft.com/VisualStudio/feedback/details/595443/datadude-data-generation-need-a-way-to-set-identity-insert-on-in-a-dgen-plan

(I voted on it)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1072387
Posted Thursday, March 03, 2011 5:34 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 6:14 AM
Points: 592, Visits: 1,423
Same place I found it!

-Ki


-Ki
Post #1072460
Posted Thursday, March 03, 2011 6:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:23 AM
Points: 1,331, Visits: 433
One point.

it was a 50/50 guess because I could not setup a dataplan in my VS, I have it available but it pulls back no tables, even if I create the table script first.
Post #1072475
Posted Thursday, March 03, 2011 8:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679
Another good Question ,i am learning new things based on this.
Post #1072582
Posted Thursday, March 03, 2011 8:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
blah blah self serving blah
Post #1072612
Posted Thursday, March 03, 2011 9:52 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337
Thanks for the question.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1072672
Posted Thursday, March 03, 2011 10:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148
Thanks for the question.
Post #1072725
Posted Thursday, March 03, 2011 11:54 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 12:25 PM
Points: 7,110, Visits: 7,184
Nice question.

I managed to get it wrong. There are some cases where unique constraints are pretty hard to cope with in data generation plans, so I went for that - and didn't even notice that the question said "identity insert" rather than "identity column". Must read more carefully and think more carefully.


Tom
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.
Post #1072778
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse