<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Nils Gustav Stråbø
»
default schema trouble
19 posts, Page 2 of 2
««
1
2
default schema trouble
Rate Topic
Display Mode
Topic Options
Author
Message
Dan Guzman - Not the MVP
Dan Guzman - Not the MVP
Posted Wednesday, July 28, 2010 9:19 AM
Say Hey Kid
Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708,
Visits: 660
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
wbeaton-664441
wbeaton-664441
Posted Wednesday, July 28, 2010 9:37 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Tuesday, February 12, 2013 3:20 PM
Points: 528,
Visits: 399
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
Cliff Jones
Cliff Jones
Posted Wednesday, July 28, 2010 10:07 AM
Hall of Fame
Group: General Forum Members
Last Login: Yesterday @ 2:31 PM
Points: 3,418,
Visits: 3,438
I did not notice the Sysadmin role. Gotta' read the whole question I guess.
Post #960177
Rob Schripsema
Rob Schripsema
Posted Wednesday, July 28, 2010 1:14 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 1,654,
Visits: 10,864
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
codebyo
codebyo
Posted Wednesday, July 28, 2010 8:20 PM
SSC Eights!
Group: General Forum Members
Last Login: Tuesday, June 04, 2013 8:50 AM
Points: 862,
Visits: 1,440
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
Yuvaraj S-467280
Yuvaraj S-467280
Posted Thursday, July 29, 2010 12:01 AM
Grasshopper
Group: General Forum Members
Last Login: Monday, May 13, 2013 8:27 PM
Points: 15,
Visits: 59
Nice questions from which i learned more about schemas.. Never knew Schema has this much to do..
__________________________________________________________
Yuvaraj
Post #960502
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Thursday, July 29, 2010 12:08 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164,
Visits: 4,344
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
John McC
John McC
Posted Thursday, July 29, 2010 8:16 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Thursday, February 21, 2013 6:30 AM
Points: 562,
Visits: 1,404
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
Hugo Kornelis
Hugo Kornelis
Posted Sunday, August 01, 2010 3:38 PM
SSCertifiable
Group: General Forum Members
Last Login: Today @ 8:11 AM
Points: 5,296,
Visits: 7,237
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 »
19 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
