default schema trouble

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

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 1 of 2

1 2 »»

default schema trouble

Rate Topic

Display Mode

Topic Options

Author

Message

Nils Gustav Stråbø

Posted Tuesday, July 27, 2010 10:05 PM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:52 AM
Points: 1,788, Visits: 3,327

Comments posted to this topic are about the item default schema trouble

Post #959815

UMG Developer

Posted Tuesday, July 27, 2010 10:09 PM

SSCrazy

Group: General Forum Members
Last Login: Monday, May 13, 2013 11:21 AM
Points: 2,163, Visits: 2,148

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. Wink

Post #959817

SQLRNNR

Posted Tuesday, July 27, 2010 10:51 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 10:25 AM
Points: 18,754, Visits: 12,337

Thanks for the question.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

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

ziangij

Posted Wednesday, July 28, 2010 12:32 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,530, Visits: 359

nice question.
got to know something new today... thanks Smile

Post #959849

Daniel Bowlin

Posted Wednesday, July 28, 2010 6:45 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 1:10 PM
Points: 2,673, Visits: 2,418

Good question. I was wondering if the admin role had an impact. Apparently it did. Thanks. Smile

Post #959988

CavyPrincess

Posted Wednesday, July 28, 2010 6:46 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 6:40 AM
Points: 596, Visits: 1,437

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

Nils Gustav Stråbø

Posted Wednesday, July 28, 2010 7:02 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 8:52 AM
Points: 1,788, Visits: 3,327

Cindy, glad to hear that you got something out of the qotd even if you knew the answer to the actual question Smile

Post #960005

Brnbngls

Posted Wednesday, July 28, 2010 7:57 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 4:11 PM
Points: 449, Visits: 168

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

SanjayAttray

Posted Wednesday, July 28, 2010 7:57 AM

Hall of Fame

Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924, Visits: 1,554

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

forjonathanwilson

Posted Wednesday, July 28, 2010 8:39 AM

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

19 posts, Page 1 of 2

1 2 »»

Permissions