InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 05:11:39 GMT20http://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxGood 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!Sun, 01 Aug 2010 15:38:53 GMTHugo Kornelishttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxAs 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....Thu, 29 Jul 2010 08:16:35 GMTJohn McChttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxGood question, with a nice twist.really had to stretch the grey matter arround the "execute as" bit.Thu, 29 Jul 2010 00:08:11 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxNice questions from which i learned more about schemas.. Never knew Schema has this much to do..Thu, 29 Jul 2010 00:01:19 GMTYuvaraj S-467280http://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxI'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. :-DI guess I'm just lucky.And maybe the "EXECUTE AS LOGIN" deserve an article?Thanks a lot. Very tricky.:hehe:Wed, 28 Jul 2010 20:20:08 GMTcodebyohttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxGreat 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.Wed, 28 Jul 2010 13:14:02 GMTRob Schripsemahttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxI did not notice the Sysadmin role. Gotta' read the whole question I guess.Wed, 28 Jul 2010 10:07:59 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxVery 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. :-)Wed, 28 Jul 2010 09:37:09 GMTwbeaton-664441http://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxI 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.DanWed, 28 Jul 2010 09:19:55 GMTDan Guzman - Not the MVPhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxthat was a real thinker, got it wrong, but learned someth9ing new. thanks!Wed, 28 Jul 2010 08:39:38 GMTforjonathanwilsonhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxGood 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.Wed, 28 Jul 2010 07:57:39 GMTSanjayAttrayhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxSoon 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 questionWed, 28 Jul 2010 07:57:04 GMTBrnbnglshttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxCindy, glad to hear that you got something out of the qotd even if you knew the answer to the actual question :-)Wed, 28 Jul 2010 07:02:52 GMTNils Gustav Stråbøhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxThanks 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 [b]execute as login='qotd'[/b] 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.CindyWed, 28 Jul 2010 06:46:22 GMTCavyPrincesshttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxGood question. I was wondering if the admin role had an impact. Apparently it did. Thanks.:-)Wed, 28 Jul 2010 06:45:48 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxnice question. got to know something new today... thanks :-)Wed, 28 Jul 2010 00:32:38 GMTziangijhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxThanks for the question.Tue, 27 Jul 2010 22:51:35 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxNice 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. ;-)Tue, 27 Jul 2010 22:09:51 GMTUMG Developerhttp://www.sqlservercentral.com/Forums/Topic959815-2749-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/70405/">default schema trouble</A>[/B]Tue, 27 Jul 2010 22:05:31 GMTNils Gustav Stråbø