Thanks for the question. I got it right only because I've seen it work. Not sure why it is allowed, though.

- webrunner

wtren (10/11/2016)

---

normally you should ask vmware about the licenses choice and cost, generally sql server virulization it will have some negative performance effect, but you also got administration flexibility...

Thanks very much for your feedback. We are going to enlist help from Microsoft in addition to my own assessment of our current environment.

- webrunner

Sean Lange (7/23/2012)

---

To add to Capn's response, the following script can be tweaked to generate the sql you need.

declare @login VARCHAR(30) = 'UserID'

SELECT 'Grant View Definition ON ' + schema_name(schema_id)...

Wow, that's some crazy SQL! Thanks for the cool question, though. 🙂

- webrunner

Thanks, great question.

- webrunner

P.S. I see the following code returns false, true.

SELECT CASE

WHEN (9999 IS NULL)...

Eric M Russell (9/23/2016)

---

Yet Another DBA (9/23/2016)

---

It is narrow-AI and not general-AI (which is what WATSON is trying to be).

If we have problems with developers running feral in the...

+1 Great point. In fact, I realize I should not have posted 'Skynet' because 'Skynet' could very...

No love for Skynet in this editorial? :hehe:

Thanks for the script!

- webrunner

Thanks for the question, Igor!

I learned something.

- webrunner

Gary Varga (9/20/2016)

---

webrunner (9/20/2016)

---

That's a fairly egregious breach of duty for some IT personnel in this case. The system was installed in 2009, and this event apparently occurred during a...

That's a fairly egregious breach of duty for some IT personnel in this case. The system was installed in 2009, and this event apparently occurred during a software upgrade in...

Thanks - interesting question.

- webrunner

Thanks.

I do prefer the simplicity of simply disallowing divide by zero, instead of treating it as NULL. The usual argument from looking at division as the inverse of multiplication is...