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
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, October 8, 2014 9:11 AM
Points: 719, Visits: 695
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: Monday, October 20, 2014 9:45 AM
Points: 534, Visits: 511
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: Monday, November 10, 2014 12:05 PM
Points: 3,969, Visits: 3,648
I did not notice the Sysadmin role. Gotta' read the whole question I guess.
Post #960177
Posted Wednesday, July 28, 2010 1:14 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 12:51 PM
Points: 2,010, Visits: 10,969
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: Monday, November 10, 2014 3:37 AM
Points: 904, Visits: 1,491
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: Friday, November 21, 2014 9:42 PM
Points: 16, Visits: 70
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


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 3:48 PM
Points: 4,111, Visits: 5,480
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 @ 2:36 AM
Points: 568, Visits: 1,608
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: Today @ 1:49 PM
Points: 6,098, Visits: 8,364
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