Reverse engineering

[Former Member]

Hi all,

Sorry for my bad English and if the topic is not good but I have a problem with reverse Engineering. I have a script from sql server 2012 (wich work fine) and tried to import that on powerdesigner for generate report. My problem is that only 4 stored procedure are find in powerdesigner but I have more than 50 in database and I really don't understand why they don't word on Powerdesigner...

Thank for help

Have a good day

[Former Member]

Hi dirk and thank for your answer

I tried the first part, with user, is the same for all

I copied your sql request on sql server, but don't have any result...

[former_member185199]

Hi,

Check if the stored procs are owned by another user,

eventuallly Switch to the other User(s) or try to reverse with admin role

HTH

PS: it is also possible that the SP´s are in the db only in compliled form

you might try this query:

select 'STOREDP', *  from syscomments where id in ( select    tr.id from    dbo.sysobjects tr where    tr.type = 'SP' )

i originally wrote it for sybase 12.5 but should run on msssqlserver

if you dont see there all of your stored procs, the the proceduretext is droped/deleted and you cant find them anymore