Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase «««12345

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



Group: Administrators
Last Login: Yesterday @ 3:36 PM
Points: 34,362, Visits: 18,572
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