I use SQL Server 2005 and Visio 2003 Enterprise Architects.
SQL Server 2005 has no trouble with a table name with a single quote in it (like [dbo].[Satriale's Pork Store] for example) but Visio can't get it right when I try to reverse engineer : all tables with single quote fall on error and Visio doesn't seem to put [ ] around tables names.
Is there something I can do ?
(better of course than to rename my table as [dbo].[Satriale_s Pork Store], which is not an option...)
Thanks
SQL Server 2005 has no trouble with a table name with a single quote in it (like [dbo].[Satriale's Pork Store] for example) but Visio can't get it right when I try to reverse engineer : all tables with single quote fall on error and Visio doesn't seem to put [ ] around tables names.
Is there something I can do ?
(better of course than to rename my table as [dbo].[Satriale_s Pork Store], which is not an option...)
Thanks