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»»

default schema trouble Expand / Collapse
Author
Message
Posted Tuesday, July 27, 2010 10:05 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 5:56 AM
Points: 1,839, Visits: 3,421
Comments posted to this topic are about the item default schema trouble
Post #959815
Posted Tuesday, July 27, 2010 10:09 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 16, 2014 9:38 AM
Points: 2,163, Visits: 2,189
Nice question, I knew it wasn't as simple as I first thought, and while I chose the correct answer I didn't want it to be correct.
Post #959817
Posted Tuesday, July 27, 2010 10:51 PM


SSC-Insane

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

Group: General Forum Members
Last Login: Yesterday @ 9:07 PM
Points: 21,351, Visits: 15,032
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 #959823
Posted Wednesday, July 28, 2010 12:32 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, June 30, 2014 2:51 AM
Points: 1,977, Visits: 369
nice question.
got to know something new today... thanks
Post #959849
Posted Wednesday, July 28, 2010 6:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:41 AM
Points: 2,818, Visits: 2,553
Good question. I was wondering if the admin role had an impact. Apparently it did. Thanks.
Post #959988
Posted Wednesday, July 28, 2010 6:46 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:46 AM
Points: 634, Visits: 1,528
Thanks for the question. I've done a lot work with schemas, so I was confident in my selection of the answer. The interesting part of this QoD for me was the execute as login='qotd' statement. Didn't know this one and I'm now kicking myself for how much time I could have saved in the past if I had known this. This one is going in my personal "tips" cheat-sheet.

Cindy
Post #959990
Posted Wednesday, July 28, 2010 7:02 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 29, 2014 5:56 AM
Points: 1,839, Visits: 3,421
Cindy, glad to hear that you got something out of the qotd even if you knew the answer to the actual question
Post #960005
Posted Wednesday, July 28, 2010 7:57 AM


SSC-Addicted

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

Group: General Forum Members
Last Login: Wednesday, July 24, 2013 2:32 PM
Points: 454, Visits: 172
Soon as I hit the submit button, knew I was wrong. I've been working alot lately with schema specific tables and when I saw that the select statement had no schema prefix, of course I thought I'd get an error.

Stupid. Oh well. Good question


The distance between genius and insanity is measured only by success.
Post #960049
Posted Wednesday, July 28, 2010 7:57 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 10:56 AM
Points: 3,924, Visits: 1,607
Good one.

execute as Login is new to me. Hadn't tried as of yet, but would definitely suggest developers to use this while working with multiple schemas.


SQL DBA.
Post #960051
Posted Wednesday, July 28, 2010 8:39 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, September 14, 2010 8:24 AM
Points: 69, Visits: 33
that was a real thinker, got it wrong, but learned someth9ing new. thanks!
Post #960082
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse