Thanks for the question, I learned something new. Very useful article about this topic

can be studied here: https://www.simple-talk.com/sql/sql-tools/registered-servers-and-central-management-server-stores/

Thanks Lesole for an interesting topic.

In MSDN https://msdn.microsoft.com/en-us/library/ms187745.aspx is stated that

"Integer constants greater than 2,147,483,647 are converted to the decimal data type, not the bigint data type."

But...

Quite useful question, thanks Steve. But I was groping a while in the article "Looking at views, Close Up",

Dropping Views paragraph until I figured out that here is described the...

I used this article in MSDN: https://msdn.microsoft.com/en-us/library/hh213536.aspx

Interesting question and very good explanation, thanks Steve.

+1 😉

Good question with a perfect explanation, thanks Junior 🙂

Version SQL Server 2014 would be enough. Inline specification of indexes

was introduced in version SQL Server 2014, see my link...

Thanks Steve for this question. I learned something new about the inline indexes. I found a good description in MSDN here:

https://msdn.microsoft.com/en-us/library/bb510411(v=sql.120).aspx

Good question, thanks Steve. To answer, I used this link:

https://books.google.cz/books?id=SbwLJTD-UuYC&pg=PA723&lpg=PA723&dq=DROP+SERVER+AUDIT&source=bl&ots=3sfsk4v65o&sig=OtdEj_y98YnQHkOOJ3UekKMW9aY&hl=cs&sa=X&ved=0ahUKEwjFj7Xy__3PAhWBuRoKHXT2At4Q6AEIPDAE#v=onepage&q=DROP%20SERVER%20AUDIT&f=false

+1

I was interested that the anonymous is default, but I guess it's better created

a new table with the name of the history table explicitly defined.

Thanks Steve for this interesting question and cleverly constructed combination of the answers... 😉

+1

Thanks Henrico for this question.:-)

James Lean (10/20/2016)

---

The answer is not quite correct. As written, it will run successfully but will not actually drop the trigger.

For logon triggers you need to use:

DROP TRIGGER IF...

+1 😉

Yes, easy one. Thanks Steve for this question.

I had a lot of search in my memory about working with xml documents.:satisfied:

Thanks Steve for this question good explanation and useful links. The series "Stairway to XML" by Robert...