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 2, 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: Sunday, November 10, 2013 11:52 AM
Points: 877, Visits: 188
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 2, 2011 11:29 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, September 8, 2014 6:15 PM
Points: 2,278, Visits: 3,793
Another good question. Questions are getting tough to crack these days

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 3:15 PM
Points: 13,731, Visits: 10,692
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 3, 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: Thursday, June 19, 2014 8:00 AM
Points: 592, Visits: 1,425
Same place I found it!

-Ki


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

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:11 AM
Points: 1,393, Visits: 480
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 3, 2011 8:04 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 10:39 AM
Points: 1,194, Visits: 787
Another good Question ,i am learning new things based on this.
Post #1072582
Posted Thursday, March 3, 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 3, 2011 9:52 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 3:27 PM
Points: 21,750, Visits: 15,447
Thanks for the question.



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


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 3, 2011 10:46 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,163, Visits: 2,191
Thanks for the question.
Post #1072725
Posted Thursday, March 3, 2011 11:54 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 8:47 AM
Points: 8,832, Visits: 9,389
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
Post #1072778
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse