What is New - What is new in SQL Server 2012 - Denali

Getting Started with Adobe After Effects - Part 6: Motion Blur

Liked


	What is New

Upload Image

Close it

Select File

Find out the new features and enhancements added into SQL Server 2012, codenamed "Denali"

Moderators


	Like

Invite Friends

Top Categories · View All

TSQL Enhancements	28
Discontinued Features	16
SSIS Enhancements	10
SSMS Enhancements	10
Database Engine	10
Database Administration	8
Security	3
Full Text Search	2
DataTime	1
Breaking Changes	1

Browse by Tags · View All

Denali	82
SQL Server 2012	79
SSIS	9
SSMS Enhancements	9
Analytic Functions	8
Usability Enhancements	5
SQL11	4
TSQL	4
Security	3
Database Engine	3
Datetime	3
Query Hints	2
OVER Clause	2
DMV	2
Groups	2
Dynamic Management Functions	2
DMF	2
System stored procedures	2
DBA	2
FTS	2

Browse by Release · View All

All	58
RC0	20
SQL Server 2012 Denali	2
CTP3	2
SQL Server Denali	1

What is new in SQL Server 2012 - Denali

Features · Categories · Submit a feature · Most Liked · Most Discussed · Info · News · Fans (73) · Preferences

1
Liked

0
Comments

SQL Server 2012 Denali - sp_configure 'user instance timeout' and 'user instances enabled' are discontinued

The following configuration options are discontinued from SQL Server 2012 (Denali). 1. `sp_configure 'user instance timeout'` 2. `sp_configure 'user instances enabled'`...

Jacob Sebastian Posted on Dec 1 2011 7:01AM
Profile · Blog · Facebook · Twitter

1
Liked

0
Comments

SQL Server 2012 Denali - 80 compatibility level is not supported

SQL Server 2012 (Denali) does not support 80 compatibility level. The database should be at least compatibility level 90...

Jacob Sebastian Posted on Dec 1 2011 6:58AM
Profile · Blog · Facebook · Twitter

1
Liked

0
Comments

SQL Server 2012 Denali - RESTORE WITH DBO_ONLY is not supported any more

SQL Server 2012 Denali discontinued support support for the following `RESTORE` options 1. RESTORE DATABASE WITH DBO_ONLY 2. RESTORE LOG WITH DBO_ONLY ...

Jacob Sebastian Posted on Dec 1 2011 6:55AM
Profile · Blog · Facebook · Twitter

1
Liked

0
Comments

SQL Server 2012 Denali - The Active Directory Helper service and the related components has been removed

The Active Directory Helper service and the related components has been removed from SQL Server 2012 (Denali). The following system stored procedures are not available any more. 1. `sp_ActiveDirectory_Obj` 2. `sp_ActiveDirectory_SCP` 3. `sp_ActiveDi...

Jacob Sebastian Posted on Dec 1 2011 6:33AM
Profile · Blog · Facebook · Twitter

1
Liked

0
Comments

SQL Server 2012 Denali does not support SQL Server Distributed Management Objects (SQL-DMO)

SQL Server 2012 Denali does not support SQL Server Distributed Management Objects (SQL-DMO) any more. SQL Server Management Objects (SMO) is the recommended alternative....

Jacob Sebastian Posted on Dec 1 2011 12:00AM
Profile · Blog · Facebook · Twitter

1
Liked

0
Comments

SQL Server 2012 Denali - BACKUP WITH PASSWORD is not supported anymore

SQL Server 2012 (Denali) no more supports the following backup commands. - BACKUP DATABASE WITH PASSWORD - BACKUP LOG WITH PASSWORD - BACKUP DATABASE WITH MEDIAPASSWORD - BACKUP LOG WITH MEDIAPASSWORD However, RESTORE { DATABASE | LOG } WITH [...

Jacob Sebastian Posted on Nov 29 2011 8:34AM
Profile · Blog · Facebook · Twitter

Previous 1 | 2 Next