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 «««12345

Temp table limitations Expand / Collapse
Author
Message
Posted Tuesday, May 27, 2014 12:13 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Wednesday, October 22, 2014 12:34 PM
Points: 31,181, Visits: 15,626
Hugo Kornelis (5/25/2014)
Uwe Ricken (5/25/2014)
Hi Steve,

curious. I've selected "no FK" as one and only option but it gave me "failed" :)
However - local temptable are valid in the sessein and they can have indexes and constraints as well.
What was my "mistake" when I have selected "no fk" as single option?


Hi Uwe,

Your mistake was twofold:
1. You overlooked the "select 2" in the question
2. You didn't realize that Steve wrote "local" but actually meant to wrote "global".


good catch. I was thinking which things weren't valid instead of the other way around.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1574908
« Prev Topic | Next Topic »

Add to briefcase «««12345

Permissions Expand / Collapse