I have dataset in vb.net code that I want to figure out its stored proc. help!

I have a dataset (pfn_cie_sys_fg) what I want to find out the stored proc that gets data into it. how do I search that in the sql server mgmt?

If it is, indeed, a stored procedure it will be listed in the "Stored Procedures" section under "Programmability"

How is this different then this post:

http://www.vbforums.com/showthread.p...red-proc.-help!

Other than the name of the dataset.

Maybe it would help if you were clearer about what you mean by dataset. Are you talking about in a VB .Net sense? A SQL server report dataset, etc.

Once agin you may find this tool invaluable and it is free:

http://www.red-gate.com/products/sql...nt/sql-search/