SQL Server

SQL Server administration and BI development with SSIS and SSAS

This SQL Server Handbook gathers the best SQL Server database administration and development publications from Dataprix, and posts about SQL Server Integration Services and SQL Server Analysis Services.

How to disable autocommit in SQL Server Management Studio

9

Disable autocommit on SQL Server Management Studio

Have you ever wondered how to disable autocommit in the Sql Server Management Studio?

Well the answer is quick. You can change it by activating the check in the menu..

 

 

Business Intelligence Forum 2010

6

On Wednesday May 12 celebrated the 10th Forum of Business Intelligence, which has been Dataprix Media Partner and I had the opportunity to attend.

The event was quite interesting, and it was a good opportunity to learn first-hand opinions and impressions of deployments responsible for business intelligence projects.

I find it very appropriate that most of the interventions were responsible for the area of IT or business data warehouse, as the vision and how to communicate to the person who runs a project internally is often the most realistic and that can best explain the needs, problems and what actually can be considered at the level of business success or failure of a technology project.

 

SQL08: How to disable autocommit in SQL Server Management Studio

6

Have you ever wondered how to disable autocommit in Sql Server Management Studio? The answer is quick.

Change it selecting in the menu

Tools> Options> Execution of the query> SQL Server> Ansi: SET IMPLICIT_TRANSACTIONS.

Syndicate content