Renaming Views

[Philip]

Hi,

I created a view in SQL Server. Later using the Enterprise manager I renamed
the view. When I script this view, the script includes the old name and not
the new one.

Any solutions to this problem?

Philip

[Gianluca Hotz]

"Philip" <philip.morley@bmb.com.bh> wrote in message
news:3b0fc406$1@news.devx.com...
>
> Hi,
>
> I created a view in SQL Server. Later using the Enterprise manager I
renamed
> the view. When I script this view, the script includes the old name and
not
> the new one.
>
> Any solutions to this problem?

Hi Philip,
this is a known issue
http://support.microsoft.com/support/kb/articles/Q243/1/98.ASP
AFAIK there's no solution to it.

HTH,
--
Gianluca Hotz
Backoffice MVP (SQL Server) MCP SQL Server and MCP Windows
Founding member of the Italian User Group for SQL Server
http://www.ghotz.com
http://www.ugiss.org