|
|
-
Jacob Sebastian Liked 1 Days ago through Blogs | 1 Point
Changing database options to make it read-only, or taking a database offline? If you are using sp_dboption, your code will not work with SQL Server 2012. Use ALTER DATABASE...SET statement instead....
|
|
|
-
Jacob Sebastian Liked 3 Days ago through Blogs | 1 Point
In SSIS Transactions, Not Supported does not always work the way we expect it to. Let us see what is the case and how do we overcome the scenario....
|
|
|
|
|
-
Jacob Sebastian Liked 5 Days ago through Blogs | 1 Point
Starting SQL Server 2012, the WITH APPEND option in the CREATE TRIGGER statement has been deprecated. This option was used for compatibility levels 65 or lower to create another trigger of the same type on any given table....
|
|
|
|
|
-
Jacob Sebastian Liked 8 Days ago through Blogs | 1 Point
AWE (address windowing support) is no longer available for SQL Server 2012. Today, I attempt to highlight the requirements & behaviour around 64-bit editions of SQL Server/operating systems....
|
|
|