Bug 261153 - Cannot display MSSQL stored procedures in Data Source Explorer
Summary: Cannot display MSSQL stored procedures in Data Source Explorer
Status: RESOLVED FIXED
Alias: None
Product: Data Tools
Classification: Tools
Component: Connectivity (show other bugs)
Version: 1.6.1   Edit
Hardware: PC Windows XP
: P3 critical (vote)
Target Milestone: 1.7M5   Edit
Assignee: dtp.connectivity-inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on: 250302
Blocks:
  Show dependency tree
 
Reported: 2009-01-15 02:48 EST by lihuang CLA
Modified: 2009-01-16 10:02 EST (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description lihuang CLA 2009-01-15 02:48:38 EST 
Build ID: Build id: M20071023-1652

Steps To Reproduce:
1.create a sql server connection profile and connect it.
2.open SQL Scrapbook against the created profile
3.execute the below SQL scripts in Scrapbook
create procedure proc1 
as 
print 'test'

4. Refresh Data Source Explorer view, there is no any stored procedure.

More information:
Comment 1 Brian Fitzpatrick CLA 2009-01-15 09:29:40 EST 
This has not been fixed for 1.6.2, but there are many fixes that have gone into Galileo for SQL Server. Can you try the latest Galileo (1.7) build to see if that fixes the problems?
Comment 2 Brian Fitzpatrick CLA 2009-01-15 10:58:32 EST 
The only other question is whether it shows up after you disconnect and reconnect the profile.
Comment 3 lihuang CLA 2009-01-16 02:21:57 EST 
I tried dtp-sdk-1.7.0M5-200901160500 drop. Stored procedure can be shown in Data Source Explorer. 
Thanks.
Comment 4 Brian Fitzpatrick CLA 2009-01-16 10:01:51 EST 
Closing as fixed, as this has been addressed in Galileo