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 Wednesday, July 28, 2010 9:19 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, June 27, 2014 1:42 PM
Points: 711, Visits: 677
I thought I might get it wrong, but not only was I wrong, but for the wrong reason. Learned something. Thanks for the question.

I shocked that no one has chimed in with a gripe that the Server Version wasn't mentioned, or any default configurations.


Dan
Post #960121
Posted Wednesday, July 28, 2010 9:37 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: Yesterday @ 9:12 AM
Points: 534, Visits: 501
Very good question. I guess the moral of the story is to always be precise and specify the full path to any object in order to avoid "default" assumptions. Boy, I've made this mistake before.
Post #960142
Posted Wednesday, July 28, 2010 10:07 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 24, 2014 7:30 AM
Points: 3,871, Visits: 3,621
I did not notice the Sysadmin role. Gotta' read the whole question I guess.
Post #960177
Posted Wednesday, July 28, 2010 1:14 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, July 18, 2014 10:48 AM
Points: 1,935, Visits: 10,956
Great question! That's the kind of issue that would cause the loss of much hair if I'd have to figure it out in a production environment.

Rob Schripsema
Accelitec, Inc
Post #960320
Posted Wednesday, July 28, 2010 8:20 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: Thursday, June 26, 2014 5:34 AM
Points: 897, Visits: 1,486
I'll be sincere: I didn't know exactly what to choose.
I got it right after some time thinking but my reason was different from the answer.
I guess I'm just lucky.

And maybe the "EXECUTE AS LOGIN" deserve an article?

Thanks a lot. Very tricky.


Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2
Post #960437
Posted Thursday, July 29, 2010 12:01 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, January 30, 2014 9:03 AM
Points: 15, Visits: 63
Nice questions from which i learned more about schemas.. Never knew Schema has this much to do..

__________________________________________________________
Yuvaraj
Post #960502
Posted Thursday, July 29, 2010 12:08 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: Today @ 7:52 AM
Points: 3,866, Visits: 5,017
Good question, with a nice twist.
really had to stretch the grey matter arround the "execute as" bit.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #960507
Posted Thursday, July 29, 2010 8:16 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: Yesterday @ 3:19 AM
Points: 566, Visits: 1,597
As with Cliff, I glanced over the important bit.

I must read the question completely.
I must read the question completely.
I must read the question completely.
I must read the question completely.
.
.
.


-------------------------------------------------------------------------
Normal chaos will be resumed as soon as possible.
Post #960740
Posted Sunday, August 1, 2010 3:38 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 3:35 PM
Points: 5,930, Visits: 8,179
Good question. I read it twice, thinking it could not be this simple. Then I submitted my answer and found it wasn't.

Thanks for teaching me something new!



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #961942
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse