Re: Bug in Visio?
From: Daniel Brodsky (danbrodsky_at_earthlink.net)
Date: 02/26/04
- Next message: Michael Perry: "SQL Server slow w/ Xeon HT Processor"
- Previous message: Kofi: "Distributed Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Date: 26 Feb 2004 08:00:29 -0800
The bug is in Visio's use of the database stroed procedure
sp_MShelpcolumns.
A work around is to modify the stored procedure witht he following
code after the "as":
------------------------------
--Visio Bug Fix db(2/25/2004)
declare @myTableOwner varchar(64)
select top 1 @myTableOwner=u.name from sysobjects s, sysusers u where
s.uid=u.uid and s.name=@tablename
set @tablename = @myTableOwner + '.' + @tablename
------------------------------
Note that it will only work if table names are unique. Otherwise it
will only return information on the first instance of that table.
v-yshao@online.microsoft.com ("Yuan Shao") wrote in message news:<a5ut15g5DHA.4028@cpmsftngxa07.phx.gbl>...
> Hi Inge,
>
> Thanks for your post. According to your description, I understand that you
> want to verify if this issue is a BUG. The issue was reverse engineering a
> SQL database, with objects owned by
> non-dbo users. Visio would then give the following error:
>
> Error! Cannot extract column definition for the table/view 'TestTable'. The
> definition is not available or you may not have sufficient privileges.
> Please check with your database administrator.
>
> If I have misunderstood, please feel free to let me know.
>
> Based on my research, this is a known issue of Visio. The gist of this
> known issue is the tables which are owned by objects other than the DBO
> object are NOT Reverse Engineered by Visio. The resolution of this problem
> is changing ownership of the Tables and other objects (Stored Procedures,
> etc.) so that the DBO is the owner. The cause of this problem is that Visio
> is unable to Reverse engineer Tables which are not owned by the DBO object.
>
> Thanks for posting in the community.
>
> Best wishes,
>
> Michael Shao
> Microsoft Online Partner Support
> Get Secure! - www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
- Next message: Michael Perry: "SQL Server slow w/ Xeon HT Processor"
- Previous message: Kofi: "Distributed Stored Procedures"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
