"Rick Razzano" <rick.razz***@gmail.com> wrote in message
news:1137858289.726552.51480@g14g2000cwa.googlegroups.com...
> If I execute the following DDL:
>
> CREATE VIEW testvw
> AS
> SELECT employee_id, employee_id
> FROM emp_master
>
> The server *should* return the following error:
> Server: Msg 4506, Level 16, State 1, Procedure testvw, Line 3
> Column names in each view or function must be unique. Column name
> 'employee_id' in view or function 'testvw' is specified more than once.
>
> However, with the SQL Server 2005 Management Studio against a SQL 2000
> server, the results pane only shows the second line, and the status bar
> indicates that the query executed successfully.  This means that if you
> run a long DDL script against 2000 server using 2005 Mgt Studio, you
> might think that it ran successfully when it really did not, and be
> missing objects.
>
> I tested with both QA and MS, against 2000 and 2005 sql server, with
> the following results:
> SQL 2005 Management Studio + SQL 2005 Server: error
> SQL 2000 Query Analyzer + SQL 2005 Server: error
> SQL 2000 Query Analyzer + SQL 2000 Server: error
> SQL 2005 Management Studio + SQL 2000 Server: *does not show error*
>
> Is this a known bug in Managment Studio?
>
> Based on this, I am no longer allowing the DBA staff to use 2005 MS to
> perform our production database promotions, as we can no longer
> guarantee that the tool will report errors properly.
>
> Rick
>