how to track object dependencies (view, function). granularity - c

There is a way in management studio 2005 to get dependencies on a databse
object, to reproduce what it does is not a big deal.
This report provides object names thwe view or function depends on for me
ust fine.
For darta warehouse analysis I need to track down dependencies of a
particular column / all collumns in the view. And the existing oviews are big
time ugly, pages of code (perform not any nicer either).
SQL parses a view and builds all the dependencies, but is there a way to get
ahold of that information somehow?
I mean I have quite a bit of ugly looking views, and the idea of doung it by
hand does not look good, it is one nasty job to be honest.
I looking for means to automat that e, create a report aout column-column
dependencies of a view/function.
Did anyone here do anything similar, knows a tool that does, any other
ideas are very welcome
Thanks, Liliya
I'm not sure if I understood your question 100% but here;s my answer anyway,
hope it helps. You can use the system stored procedure called sp_depends to
get object dependencies
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org
Atlanta's Business Intelligence and Data Warehouse Experts
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:92770E4B-F9E1-42EB-B68E-6AD50CABA825@.microsoft.com...
> There is a way in management studio 2005 to get dependencies on a databse
> object, to reproduce what it does is not a big deal.
> This report provides object names thwe view or function depends on for me
> ust fine.
> For darta warehouse analysis I need to track down dependencies of a
> particular column / all collumns in the view. And the existing oviews are
> big
> time ugly, pages of code (perform not any nicer either).
> SQL parses a view and builds all the dependencies, but is there a way to
> get
> ahold of that information somehow?
> I mean I have quite a bit of ugly looking views, and the idea of doung it
> by
> hand does not look good, it is one nasty job to be honest.
> I looking for means to automat that e, create a report aout column-column
> dependencies of a view/function.
> Did anyone here do anything similar, knows a tool that does, any other
> ideas are very welcome
> --
> Thanks, Liliya
>
|||Liliya
I think you need to look at RedGate third party compare product
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:92770E4B-F9E1-42EB-B68E-6AD50CABA825@.microsoft.com...
> There is a way in management studio 2005 to get dependencies on a databse
> object, to reproduce what it does is not a big deal.
> This report provides object names thwe view or function depends on for me
> ust fine.
> For darta warehouse analysis I need to track down dependencies of a
> particular column / all collumns in the view. And the existing oviews are
> big
> time ugly, pages of code (perform not any nicer either).
> SQL parses a view and builds all the dependencies, but is there a way to
> get
> ahold of that information somehow?
> I mean I have quite a bit of ugly looking views, and the idea of doung it
> by
> hand does not look good, it is one nasty job to be honest.
> I looking for means to automat that e, create a report aout column-column
> dependencies of a view/function.
> Did anyone here do anything similar, knows a tool that does, any other
> ideas are very welcome
> --
> Thanks, Liliya
>
|||I can pull object dependencies easy, as I have mentioned before. sp_depends
is one way to do it. tracing what management studio does pulling dependencies
is another way. Both are easy. It does not return the level of detail I need.
view1.columnXYZ depends on object1.column1 and so on, entire dependency tree
under to the last table/function.column
Thanks, Liliya
"Knowledgy" wrote:

> I'm not sure if I understood your question 100% but here;s my answer anyway,
> hope it helps. You can use the system stored procedure called sp_depends to
> get object dependencies
> --
> Sincerely,
> John K
> Knowledgy Consulting
> www.knowledgy.org
|||Downloaded the tool, got trial expired immediately. interesting product...
I have one of their products, started wondering, how exactly do keep track
of tier licenses etc...
demo video leaves the impression that all it is a gui on top of sp_depends.
I would not buy the product on that video... I mean, no need to get what ms
management studio already has. I do not believe they parse views and
functions from what i have seen so far.
Hope, their sales rep is going to be quick to answer a question of the
existing customer.
Thanks, Liliya
"Uri Dimant" wrote:

> Liliya
> I think you need to look at RedGate third party compare product
|||the tool tracks dependencies on object level only. not granular enough for my
needs.
Thanks, Liliya
"Uri Dimant" wrote:

> Liliya
> I think you need to look at RedGate third party compare product
|||RedGate third party compare product - provides only object level dependencies
confirmed by the vendor
"
We use our own parser to build a schema representation. Unfortunately, SQL
Dependency Tracker will only go down to table/view level, it will not show
you the dependencies at column level.
This is something that lots of customers ask us for so when there is
development work planned for SQL Dependency Tracker this will be a seriously
considered feature. However, I do not have any kind of timescale on this.
"
Any other vendors?
Thanks, Liliya
|||Investigate CAST. Worked with their stuff about 10 years ago but nothing
came close to their ability to track dependencies. Note that it was an
upper 5 to as much as 7 figure product back then. :-)
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:92770E4B-F9E1-42EB-B68E-6AD50CABA825@.microsoft.com...
> There is a way in management studio 2005 to get dependencies on a databse
> object, to reproduce what it does is not a big deal.
> This report provides object names thwe view or function depends on for me
> ust fine.
> For darta warehouse analysis I need to track down dependencies of a
> particular column / all collumns in the view. And the existing oviews are
> big
> time ugly, pages of code (perform not any nicer either).
> SQL parses a view and builds all the dependencies, but is there a way to
> get
> ahold of that information somehow?
> I mean I have quite a bit of ugly looking views, and the idea of doung it
> by
> hand does not look good, it is one nasty job to be honest.
> I looking for means to automat that e, create a report aout column-column
> dependencies of a view/function.
> Did anyone here do anything similar, knows a tool that does, any other
> ideas are very welcome
> --
> Thanks, Liliya
>

how to track object dependencies (view, function). granularity - c

There is a way in management studio 2005 to get dependencies on a databse
object, to reproduce what it does is not a big deal.
This report provides object names thwe view or function depends on for me
ust fine.
For darta warehouse analysis I need to track down dependencies of a
particular column / all collumns in the view. And the existing oviews are big
time ugly, pages of code (perform not any nicer either).
SQL parses a view and builds all the dependencies, but is there a way to get
ahold of that information somehow?
I mean I have quite a bit of ugly looking views, and the idea of doung it by
hand does not look good, it is one nasty job to be honest.
I looking for means to automat that e, create a report aout column-column
dependencies of a view/function.
Did anyone here do anything similar, knows a tool that does, any other
ideas are very welcome
--
Thanks, LiliyaI'm not sure if I understood your question 100% but here;s my answer anyway,
hope it helps. You can use the system stored procedure called sp_depends to
get object dependencies
--
Sincerely,
John K
Knowledgy Consulting
www.knowledgy.org
Atlanta's Business Intelligence and Data Warehouse Experts
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:92770E4B-F9E1-42EB-B68E-6AD50CABA825@.microsoft.com...
> There is a way in management studio 2005 to get dependencies on a databse
> object, to reproduce what it does is not a big deal.
> This report provides object names thwe view or function depends on for me
> ust fine.
> For darta warehouse analysis I need to track down dependencies of a
> particular column / all collumns in the view. And the existing oviews are
> big
> time ugly, pages of code (perform not any nicer either).
> SQL parses a view and builds all the dependencies, but is there a way to
> get
> ahold of that information somehow?
> I mean I have quite a bit of ugly looking views, and the idea of doung it
> by
> hand does not look good, it is one nasty job to be honest.
> I looking for means to automat that e, create a report aout column-column
> dependencies of a view/function.
> Did anyone here do anything similar, knows a tool that does, any other
> ideas are very welcome
> --
> Thanks, Liliya
>|||Liliya
I think you need to look at RedGate third party compare product
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:92770E4B-F9E1-42EB-B68E-6AD50CABA825@.microsoft.com...
> There is a way in management studio 2005 to get dependencies on a databse
> object, to reproduce what it does is not a big deal.
> This report provides object names thwe view or function depends on for me
> ust fine.
> For darta warehouse analysis I need to track down dependencies of a
> particular column / all collumns in the view. And the existing oviews are
> big
> time ugly, pages of code (perform not any nicer either).
> SQL parses a view and builds all the dependencies, but is there a way to
> get
> ahold of that information somehow?
> I mean I have quite a bit of ugly looking views, and the idea of doung it
> by
> hand does not look good, it is one nasty job to be honest.
> I looking for means to automat that e, create a report aout column-column
> dependencies of a view/function.
> Did anyone here do anything similar, knows a tool that does, any other
> ideas are very welcome
> --
> Thanks, Liliya
>|||I can pull object dependencies easy, as I have mentioned before. sp_depends
is one way to do it. tracing what management studio does pulling dependencies
is another way. Both are easy. It does not return the level of detail I need.
view1.columnXYZ depends on object1.column1 and so on, entire dependency tree
under to the last table/function.column
--
Thanks, Liliya
"Knowledgy" wrote:
> I'm not sure if I understood your question 100% but here;s my answer anyway,
> hope it helps. You can use the system stored procedure called sp_depends to
> get object dependencies
> --
> Sincerely,
> John K
> Knowledgy Consulting
> www.knowledgy.org|||Downloaded the tool, got trial expired immediately. interesting product...
I have one of their products, started wondering, how exactly do keep track
of tier licenses etc...
demo video leaves the impression that all it is a gui on top of sp_depends.
I would not buy the product on that video... I mean, no need to get what ms
management studio already has. I do not believe they parse views and
functions from what i have seen so far.
Hope, their sales rep is going to be quick to answer a question of the
existing customer.
--
Thanks, Liliya
"Uri Dimant" wrote:
> Liliya
> I think you need to look at RedGate third party compare product|||the tool tracks dependencies on object level only. not granular enough for my
needs.
--
Thanks, Liliya
"Uri Dimant" wrote:
> Liliya
> I think you need to look at RedGate third party compare product|||RedGate third party compare product - provides only object level dependencies
confirmed by the vendor
"
We use our own parser to build a schema representation. Unfortunately, SQL
Dependency Tracker will only go down to table/view level, it will not show
you the dependencies at column level.
This is something that lots of customers ask us for so when there is
development work planned for SQL Dependency Tracker this will be a seriously
considered feature. However, I do not have any kind of timescale on this.
"
Any other vendors?
Thanks, Liliya|||Investigate CAST. Worked with their stuff about 10 years ago but nothing
came close to their ability to track dependencies. Note that it was an
upper 5 to as much as 7 figure product back then. :-)
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Liliya Huff" <LiliyaHuff@.discussions.microsoft.com> wrote in message
news:92770E4B-F9E1-42EB-B68E-6AD50CABA825@.microsoft.com...
> There is a way in management studio 2005 to get dependencies on a databse
> object, to reproduce what it does is not a big deal.
> This report provides object names thwe view or function depends on for me
> ust fine.
> For darta warehouse analysis I need to track down dependencies of a
> particular column / all collumns in the view. And the existing oviews are
> big
> time ugly, pages of code (perform not any nicer either).
> SQL parses a view and builds all the dependencies, but is there a way to
> get
> ahold of that information somehow?
> I mean I have quite a bit of ugly looking views, and the idea of doung it
> by
> hand does not look good, it is one nasty job to be honest.
> I looking for means to automat that e, create a report aout column-column
> dependencies of a view/function.
> Did anyone here do anything similar, knows a tool that does, any other
> ideas are very welcome
> --
> Thanks, Liliya
>

How to submit a report parameter?

Microsoft® SQL Server� Reporting Services provides a single entry point to the full functionality of the report server: the Reporting Services Web service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP and acts as a communications interface between client programs and the report server. The Web service and its methods expose the functionality of the report server and allow you to create custom tools for any part of the report life cycle, from management to execution.
The application that we have build is using the Web Service and the .NET Framework. We have successfully created the proxy class for the Web service.
We are trying to:
Create a ReportServices control
Create a ReportViewer control
Render a specific Report
To render the Report, we need to pass it a string paramter.
Our status is the following:
We have successfully created the ReportServices control with the following:
ReportingService rs = new ReportingService();
If we don't pass a parameter, we have everthing working fine.
If we pass a parameter, the report does not render. A summary of the error message follows:
"The report parameter 'sDealerId' is read-only and cannot be modified."
The full error message follows:
<detail>
<ErrorCode xmlns="http://www.microsoft.com/sql/reportingservices">rsReadOnlyReportParameter</ErrorCode>
<HttpStatus xmlns="http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
<Message xmlns="http://www.microsoft.com/sql/reportingservices">The report parameter 'sDealerId' is read-only and cannot be modified.</Message>
<HelpLink xmlns="http://www.microsoft.com/sql/reportingservices">http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</HelpLink>
<ProductName xmlns="http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server Reporting Services</ProductName>
<ProductVersion xmlns="http://www.microsoft.com/sql/reportingservices">8.00.878.00</ProductVersion>
<ProductLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
<OperatingSystem xmlns="http://www.microsoft.com/sql/reportingservices">OsIndependent</OperatingSystem>
<CountryLocaleId xmlns="http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId>
<MoreInformation xmlns="http://www.microsoft.com/sql/reportingservices">
<Source>Microsoft.ReportingServices.Processing</Source>
<Message msrs:ErrorCode="rsReadOnlyReportParameter" msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00" xmlns:msrs="http://www.microsoft.com/sql/reportingservices">The report parameter 'sDealerId' is read-only and cannot be modified.</Message>
</MoreInformation>
<Warnings xmlns="http://www.microsoft.com/sql/reportingservices" />
</detail>
Has anyone ever successful passed parameters to a ReportServices and/or ReportViewer control? If so, have you ever seen this type of error message and do you know which specific security issue is causing this?
Thanks,
Robert Baker
ZxytekNot sure, Robert, but this sounds like the error that version 1 gives when
you try to update a parameter that has been rendered "read only". SP1
removed this limitation allowing you to keep a parameter hidden and yet
change it's value via the URL.
"zxytek" <zxytek@.hotmail.com> wrote in message
news:252C34F9-652F-494C-BBE7-807B07073216@.microsoft.com...
> Microsoft® SQL ServerT Reporting Services provides a single entry point to
the full functionality of the report server: the Reporting Services Web
service. The Web service uses Simple Object Access Protocol (SOAP) over HTTP
and acts as a communications interface between client programs and the
report server. The Web service and its methods expose the functionality of
the report server and allow you to create custom tools for any part of the
report life cycle, from management to execution.
> The application that we have build is using the Web Service and the .NET
Framework. We have successfully created the proxy class for the Web
service.
> We are trying to:
> Create a ReportServices control
> Create a ReportViewer control
> Render a specific Report
> To render the Report, we need to pass it a string paramter.
> Our status is the following:
> We have successfully created the ReportServices control with the
following:
> ReportingService rs = new ReportingService();
> If we don't pass a parameter, we have everthing working fine.
> If we pass a parameter, the report does not render. A summary of the
error message follows:
> "The report parameter 'sDealerId' is read-only and cannot be
modified."
> The full error message follows:
> <detail>
> <ErrorCode
xmlns="rsReadOnlyReportParam">http://www.microsoft.com/sql/reportingservices">rsReadOnlyReportParam
eter</ErrorCode>
> <HttpStatus
xmlns="400</HttpStatus>">http://www.microsoft.com/sql/reportingservices">400</HttpStatus>
> <Message
xmlns="The">http://www.microsoft.com/sql/reportingservices">The report parameter
'sDealerId' is read-only and cannot be modified.</Message>
> <HelpLink
xmlns="http://go.microsoft.c">http://www.microsoft.com/sql/reportingservices">http://go.microsoft.c
om/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utili
ties.ErrorStrings.resources.Strings&EvtID=rsReadOnlyReportParameter&ProdName
=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=8.00</HelpLink>
> <ProductName
xmlns="Microsoft">http://www.microsoft.com/sql/reportingservices">Microsoft SQL Server
Reporting Services</ProductName>
> <ProductVersion
xmlns="8.00.878.00</ProductV">http://www.microsoft.com/sql/reportingservices">8.00.878.00</ProductV
ersion>
> <ProductLocaleId
xmlns="127</ProductLocaleId>">http://www.microsoft.com/sql/reportingservices">127</ProductLocaleId>
> <OperatingSystem
xmlns="OsIndependent</Operat">http://www.microsoft.com/sql/reportingservices">OsIndependent</Operat
ingSystem>
> <CountryLocaleId
xmlns="1033</CountryLocaleId">http://www.microsoft.com/sql/reportingservices">1033</CountryLocaleId
> <MoreInformation
xmlns="">http://www.microsoft.com/sql/reportingservices">
> <Source>Microsoft.ReportingServices.Processing</Source>
> <Message msrs:ErrorCode="rsReadOnlyReportParameter"
msrs:HelpLink="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft
.ReportingServices.Diagnostics.Utilities.ErrorStrings.resources.Strings&EvtI
D=rsReadOnlyReportParameter&ProdName=Microsoft%20SQL%20Server%20Reporting%20
Services&ProdVer=8.00"
xmlns:msrs="The">http://www.microsoft.com/sql/reportingservices">The report
parameter 'sDealerId' is read-only and cannot be modified.</Message>
> </MoreInformation>
> <Warnings xmlns="http://www.microsoft.com/sql/reportingservices"
/>
> </detail>
> Has anyone ever successful passed parameters to a ReportServices and/or
ReportViewer control? If so, have you ever seen this type of error message
and do you know which specific security issue is causing this?
> Thanks,
> Robert Baker
> Zxytek