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

Identity Crisis: Attack of the Clone Expand / Collapse
Author
Message
Posted Thursday, May 12, 2011 9:25 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, May 4, 2014 4:02 PM
Points: 5, Visits: 41
What about the error with the schema
Post #1107815
Posted Thursday, May 12, 2011 2:49 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Another nice question, thanks!
Post #1108071
Posted Friday, May 13, 2011 9:06 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: Friday, June 13, 2014 3:03 PM
Points: 594, Visits: 655
Tom.Thomson (5/11/2011)
WayneS (5/11/2011)
Tom.Thomson (5/11/2011)
Nice question.

One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some of your audience don't know any better. Maybe "pretend" would have been a better choice of word than "assume".


Tom, I think it was referring to the schema "Playground", which the table was created in.

Ah, yes, probably. My mistake. I find it hard at times to remember that MS misuses this particular term so horribly, and my reaction was as it was because I interpreted "schema" as "schema" rather than as what MS calls "schema". Must remember loony MS terminology in future .


True many people are unaware of all the implications of "schema" in SQL as it covers many things "to make SQL databases and objects self-describing". Things like structure and integrity constraints, security and authorization specifications, object identifiers, features and packages, support of features, implementation information and sizing items, and schema is actually divided into "information" and "definition" schemas.

So loony actually applies to the description of schema by many MS DBA's, not Microsoft itself. Unfortunately, many DBA's just never really learn how broadly the term applies and tend to assume the third position of the name resolution process only...

But we're all learning!!


Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Post #1108518
Posted Thursday, May 26, 2011 1:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, June 9, 2014 1:24 AM
Points: 375, Visits: 114
Nice Question, QotD.. keep us bugging like this only
Post #1115206
Posted Saturday, September 3, 2011 8:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 9:33 AM
Points: 355, Visits: 110
Good Question. I had to read the flow of logic twice, but i selected the right option.
Post #1169678
Posted Friday, March 16, 2012 3:36 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, June 19, 2014 10:32 AM
Points: 483, Visits: 243
Easy question. Thanks
Post #1268562
« Prev Topic | Next Topic »

Add to briefcase «««1234

Permissions Expand / Collapse