« Fehler bei collection_set_3_upload
Wartungspläne und Local Server Connection »

A lot of bugs in SQL Server 2012 SP1

Especially SSMS has lost some functionality through SP1. I've found some bugs and a friend in sweden could reproduce them on swedish clients, too! Thanks Erland. Falk Krahl has confirmed that the bugs still exists with CU1. Thanks Falk.

Show Errorlog

When showing the errorlog in SSMS you can select additional logs like SQL Server Agent. This work fine. But when selecting 'Windows NT' as an additional log, I receive (with SP1) the error : 'The given key was not present in the dictionary.'

Please look at my connect item.

Export Data

When I try in SSMS the task "Export Data" with a query, not the table itself and the table has colunns of type varchar, an error occurs.
Error is e. g.:
Found 2 unknown column type conversion(s)
You are only allowed to save the package

The version of the sql server database does not matter. The client makes the difference.

Please look at my connect item with the repro-script.

USE <MyDatabase>
GO
CREATE TABLE SSIS_Source(PK INT, F1 VARCHAR(10), F2 VARCHAR(400));
CREATE TABLE SSIS_Destination(PK INT, F1 VARCHAR(10), F2 VARCHAR(400));

INSERT INTO SSIS_Source(PK, F1, F2) VALUES (1, 'a', 'b');

SELECT PK, F1, F2
FROM SSIS_Source;

Try in SSMS the task "Export Data" with the query above, not the table itself. Destination is the table SSIS_Destination.

Activity Monitor

After the installation of SP1 for SQL Server 2012 you can not use the activity monitor against instances with SQL Server 2008 R2.
But instances with 2008 and 2012 are working fine.

Please look at my connect item.

Update 11/23/2012

I have to modify my first statement. It occurs with SQL Server 2008 and SQL Server 2008 R2, too. But I can use activity monitor with some servers without any problem. The working servers are SQL Server 2008 and SQL Server 2008 R2, too.
It is a mixture of Enterprise and Standard Editions.
All of the servers not working have OS Microsoft Windows NT 5.2 (3790).

bug, connect, service pack, sql server 2012
SQL Server
 Print article This entry was posted by cmu on 2012-11-22 at 08:15:00 . Follow any responses to this post through RSS 2.0.