Posted by Erland Sommarskog on 04/06/06 10:33

(jim_geissman@countrywide.com) writes:
> Two real limitations/bugs --
>
> 1. Can't edit table-valued function.

If it's on SQL 2000. Actually, Mgmt Studio is partly innocent. There is a
bug in SQL 2000, so that objectproperty incorrectly reports status for
QuotedIdentifier and AnsiNulls for multi-statement functions.

> 2. Can't get nulls to be missing (blank) in text output pane

Personally, I would not call that neither bug nor limitation. Just
different.


> 3. DB->All Tasks->Import Data->Load CSV file (exported from Excel) ->
> garbled table as some rows end up being extra columns. The same
> spreadsheets load okay from XLS format.

I've stayed away from the Import/Export wizard, so I cannot comment on
that one.

> 4. SET NOCOUNT OFF has no effect after SET NOCOUNT ON

Do you have an example?


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Download image datatype to Jpegs or GIF's
• Prev in forum: Re: Transport Level Error has occured
• Thread view: Re: SQL 2005 Management Studio Bugs

[Reply to this message]