<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 Steve Jones
»
Contained Database users
32 posts, Page 1 of 4
1
2
3
4
»
»»
Contained Database users
Rate Topic
Display Mode
Topic Options
Author
Message
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Wednesday, April 11, 2012 11:43 PM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
Comments posted to this topic are about the item
Contained Database users
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1282134
Henrico Bekker
Henrico Bekker
Posted Wednesday, April 11, 2012 11:52 PM
SSCommitted
Group: General Forum Members
Last Login: Monday, June 10, 2013 11:15 PM
Points: 1,878,
Visits: 2,704
Good one on 2012 range of QOTD...havent seen too many yet.
----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1282139
Koen Verbeeck
Koen Verbeeck
Posted Wednesday, April 11, 2012 11:52 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:30 AM
Points: 9,410,
Visits: 6,495
Nice question, always good to learn something new.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1282140
Stewart "Arturius" Campbell
Stewart "Arturius" Campbell
Posted Thursday, April 12, 2012 2:36 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 3,164,
Visits: 4,344
Good question, thanks, Steve.
Learned something new.
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1282193
DugyC
DugyC
Posted Thursday, April 12, 2012 2:57 AM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:49 AM
Points: 1,182,
Visits: 745
Wasn't aware of Contained Databases, so learned something new again today.
Great questions, thanks Steve.
_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1282202
Stuart Davies
Stuart Davies
Posted Thursday, April 12, 2012 4:00 AM
SSCrazy
Group: General Forum Members
Last Login: Today @ 8:53 AM
Points: 2,499,
Visits: 2,200
Another question from Steve on contained databases. I wonder what he has been playing around with?
-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1282219
Thomas Abraham
Thomas Abraham
Posted Thursday, April 12, 2012 5:40 AM
Ten Centuries
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 5:11 AM
Points: 1,168,
Visits: 1,470
Thanks for giving me a reason to do some digging this morning. Learned a lot.
But, it's hard to concentrate, as I'm waiting for Steve to hit 30,000 points - kind of like waiting for your odometer to roll over.
Please don't go. The drones need you. They look up to you.
Post #1282281
mtassin
mtassin
Posted Thursday, April 12, 2012 7:23 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 3:14 PM
Points: 3,250,
Visits: 65,561
I was aware of what contained databases are...
At first I thought this was a trick question, because if you can't use AD credentials against a contained database then what good are they? After all the best practices recommendation is to use Windows authentication for everything SQL related.
Then I was like, ok so if it's a trick question, why would anybody want to use this? And then I was like, why in the world would you be able to only use groups or users but not both?
Finally I went with my original answer and got it right :) Yay me?
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1282354
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Thursday, April 12, 2012 8:13 AM
SSC-Dedicated
Group: Administrators
Last Login: Today @ 5:09 AM
Points: 31,526,
Visits: 13,864
The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication takes place there first, which makes sense. So if you move a partially contained database to a server that has a matching login, the login isn't contained.
Not a big deal, but interesting.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #1282408
OzYbOi d(-_-)b
OzYbOi d(-_-)b
Posted Thursday, April 12, 2012 8:29 AM
Ten Centuries
Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176,
Visits: 778
tks Steve
Post #1282420
« Prev Topic
|
Next Topic »
32 posts, Page 1 of 4
1
2
3
4
»
»»
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.
