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).

No feedback yet
Leave a comment

You must be logged in to leave a comment. Log in now!

If you have no account yet, you can register now...
(It only takes a few seconds!)

  • Christoph Muthmann
    Trackback from: Christoph Muthmann
    2013-02-01 @ 12:33:01

    Activity Monitor Bug is Fixed
    Thanks to Vladimir Svidersky, for fixing this issue with Windows 2003 servers

    After building the same environment as I have, Vladimir could repro the bug and tell us the hotfix for our Windows 2003 servers. It works like a charm. We had to fix WMI to&...

  • Christoph Muthmann
    Trackback from: Christoph Muthmann
    2013-05-06 @ 09:25:18

    Export Data Bug is Fixed
    So langsam geht es voran! Nun wurde auch das Fix für diesen Fehler beim Export per Query erstellt. Das dauert noch etwas bis zur Verfügbarkeit, aber es gibt mittlerweile zwei Workarounds.

    Workaround 1 - Create View
    Anstelle des Exports per Q...