Thursday, September 17, 2015

Linked Server Transaction error Msg 7395, Level 16, State 2, Line 273

If you are using nested transaction in your stored procedure you will get the same error. Solution to this error is to SET XACT_ABORT  TO ON;  in your stored procedure.

Tuesday, May 05, 2015

SQL Server 2016 public preview

SQL Server 2016 public preview coming this summer and most important feature Real-time Operational Analytics & In-Memory OLTP

http://blogs.technet.com/b/dataplatforminsider/archive/2015/05/04/sql-server-2016-public-preview-coming-this-summer.aspx