Posted by Ian Bell on 02/07/06 16:54

Hi All

I have just upgraded to SQL2005 and found an annoying problem. Whenever
I add a new view or amend an existing one (created in SQL 2000
Enterprise Manager) it inserts TOP 100 Percent into the SQL query. Even
if I delete the clause from the SQL query it puts it straight back in
again. This is a problem as there are some queries where I just don't
want this clause there (ADO.NET cannot update a view with a TOP clause)

Any ideas anyone?

Many thanks

Ian Bell


*** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: REPLACE function doesn't work with null-bytes
• Prev in forum: Re: Views vs Stored Procedures, whats the difference?
• Thread view: Why does SQL2005 automatically insert TOP 100 PERCENT in views?

[Reply to this message]