Hugo Kornelis (3/27/2012)

---

palotaiarpad (3/27/2012)

---

I'm a bit confused.

BOL: If a view is not created with the SCHEMABINDING clause, sp_refreshview should be run when changes are made to the objects underlying the...

I'm a bit confused.

BOL: If a view is not created with the SCHEMABINDING clause, sp_refreshview should be run when changes are made to the objects underlying the view that affect...

Thanks for the easy point! 😀

According to BOL (upward from 2005): The SQLAgentReaderRole and the SQLAgentOperatorRole are automatically members of the SQLAgentUserRole.

So it's only a typo.

The good thing in ANY or SOME is that you can make all kind of comparison not only equality or inequality.

I thought it would be too easy, without any trick, and i answered 5. I hoped, DATE fields have a time offset 12:00, but they haven't. 😀

Please correct the typo!

But there is a documentation that it must be uppercase: ms179899 🙂

Nice question, i learned something again.

Nice question, the 4. option fooled me. :w00t:

In my reading, you can't reference a column, you can reference an UDF only. :angry:

Thanks a lot! My points are back! 😎

I have not as mutch points to just loose one! 😀 😛

That's a good question, thanks!

Yes, it's possible, but the second operation will wait for the first to finish.