Renamed Views Bug

Documents SQL Server 2000, 2005 and 2008 databases.


Moderators: David Atkinson, david connell, Charles Brown

Renamed Views Bug

Postby eakolb » Tue Jun 17, 2008 9:13 pm

I've stumbled upon a bug of sorts. When a view is created as one name but then changed using the Rename ability in SQL Server Management Studio, the documentation will still have the original creation name attached to it. This also affects SQL Packager.

I don't know if it's been reported on before and it's really more a result of SQL Server Management Studio being sloppy with that operation.
eakolb
 
Posts: 1
Joined: Tue Jun 17, 2008 9:04 pm

Postby David Atkinson » Wed Jun 18, 2008 12:43 am

Hi,

This is a bug with the rename functionality and not with SQL Doc. However, there is a workaround to fix it. If you use SQL Compare to synch to your database, it will detect and automatically fix this issue for you by correcting the offending table in your database.

Let me know how you get on.

David Atkinson
Red Gate Software
David Atkinson
 
Posts: 1124
Joined: Mon Dec 05, 2005 4:54 pm
Location: Twitter: @dtabase


Return to SQL Doc 1

Who is online

Users browsing this forum: No registered users and 0 guests

cron