Drop Me? No, I Don't Think So

Question

Post reply

Drop Me? No, I Don't Think So

Andy Warren

SSC Guru

Points: 119902
More actions
May 13, 2014 at 8:17 pm

#307940

Comments posted to this topic are about the item Drop Me? No, I Don't Think So
Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter

Viewing 15 posts - 1 through 15 (of 28 total)

You must be logged in to reply to this topic. Login to reply

chriztoph SSC Veteran Points: 205 More actions · Answer 1

Great question and that explanation is always a must for every QotD.

rhythmk SSCertifiable Points: 7271 More actions · Answer 2

Nice question with very good explanation.Thanks Andy.

--rhythmk
------------------------------------------------------------------
To post your question use below link

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

Good one, thanks.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

Ford Fairlane SSCertifiable Points: 7664 More actions · Answer 4

Nice question, thanks -

Hope this helps...

Ford Fairlane
Rock and Roll Detective

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 5

Found good explanation in the below link

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-permission-s.aspx">

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-permission-s.aspx

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 6

i am not sure if the above link is taking to the proper page or not , but pls copy the below

http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-

permission-s.aspx

Eirikur Eiriksson SSC Guru Points: 182901 More actions · Answer 7

Eirikur Eiriksson

SSC Guru

Points: 182901

May 14, 2014 at 1:40 am

#1713334

Good question, thanks!

😎

paul s-306273 SSChampion Points: 10730 More actions · Answer 8

paul s-306273

SSChampion

Points: 10730

May 14, 2014 at 3:24 am

#1713352

Really good QOTD and explanation.

Thanks Andy.

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

Great question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Hany Helmy SSChampion Points: 13921 More actions · Answer 10

pmadhavapeddi22 (5/14/2014)
i am not sure if the above link is taking to the proper page or not , but pls copy the below
http://blogs.msdn.com/b/sqlserverfaq/archive/2010/02/09/drop-failed-for-login-since-it-has-granted-one-or-more-
permission-s.aspx

Yes, the 2nd one worked, thanx 4 sharing!

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Hany Helmy SSChampion Points: 13921 More actions · Answer 11

Really good question, enjoyed reading, searching, answering it & the explanation is great too.

Thanx Andy 🙂

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Ed Wagner SSC Guru Points: 287026 More actions · Answer 12

Excellent question, Andy. Thanks.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Thomas Abraham SSChampion Points: 10761 More actions · Answer 13

Great question, as usual from Andy. Thanks! Went for what seems to be the popular answer (permissions in offline DB's) after initially thinking permissions granted was the answer.

I think Andy should do a QotD calendar! 😉 Except, who uses a paper calendar any more?

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

OCTom SSChampion Points: 11785 More actions · Answer 14

What!?!? You mean Powershell is NOT the answer to everything?

I'm shocked!

:Wow: