I see a connect item has been logged

http://connect.microsoft.com/SQLServer/feedback/details/850260/sql-2014-sp-send-dbmail-64kb-query-result-limit

Try this article for using SSIS

http://code-remind.blogspot.com/2013/03/ssis-sql-query-output-into-excel-tabs.html

Welsh Corgi (6/28/2014)

---

Sean Pearce (5/21/2014)

---

Welsh Corgi (5/20/2014)

---

You are right you can't set the Identity Property to true.

You can set the identity property to false by simply going into design mode...

Lynn, only in the context of "Question of the Day" should we assume default settings, and yes, this includes 1Mb growth on data files and 10% growth on log files....

Now I have a process on each database in the development, test, and production servers that creates custom indexes just for that database and gets rid of indexes that aren't...

No, it would be better to assume the default collation applies.

Mighty (6/20/2014)

---

Raghavendra Mudugal (6/20/2014)

---

Well... the exchange of thoughts on collation is been going on from very long back, but at the end we all kind of nodded that if the...

erwin.oosterhoorn (6/20/2014)

---

There is nothing indicating if the database setting is case sensitive, our databases are. Therefore I went for different answers than the one seen as correct.

Would I have been...

I got it from the Interwebs, I have no copyright.

mod: removed dead link

I found the question good and I had no problem understanding the author's intent.

There are only two valid answers, Azure and 2000. Being told the company only uses 2012 on-site...

Good question, and I agree with Koen. The help page at http://technet.microsoft.com/en-us/library/ms188014.aspx does tell you that dbo is returned for members of sysadmin.

Here is the result set for a user...

ramana3327 (6/4/2014)

---

Ok.

If we forget about mine and come to the general situation. In usually what could be the possible reasons causes of high execution time if we execute SP immediately...

Those are features of the database engine...

I use a custom script to set this up for myself which you are welcome to use. It is commented but you can ask for more info if you have...