Question about ReportViewer for ASP.NET Pages

hello masters and gurus,
anyone using the reportviewer control provided for integration with asp.net
webform? what should i do to keep the drilldown report to transfer to the
next report but just on the report viewer control? because when i try to
click one..it opens up on the whole page...which is not what i need..
thanks in advance guys...use the rc:replacementroot parameter to inform your reportviewer to open a
linked report in a specific ASPX web page.
The usage is like this
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
(encode the Replacementroot value with the server.urlencode function)
RS will add the report name at the end of this value, so the "ReportName"
parameter is the parameter passed to the URL filled by RS.
So, when the page "page.aspx" is called, read the ReportName query string
(request("ReportName")) to retrieve the drilled report and all the
associated parameters.
"dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> hello masters and gurus,
> anyone using the reportviewer control provided for integration with
asp.net
> webform? what should i do to keep the drilldown report to transfer to the
> next report but just on the report viewer control? because when i try to
> click one..it opens up on the whole page...which is not what i need..
> thanks in advance guys...
>|||It still didn't solve my problem..sorry i wasn't able to mention this..my
page has a frames..wherein the left pane displays the list of reports that
can be used...the right pane therefore is where my report viewer is
located...when i click the drilldown report on that report..it opens it in
the whole page and not just on that frame and on that specific report viewer
control..
hope you can help me with this problem...thanks in advance..
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> use the rc:replacementroot parameter to inform your reportviewer to open a
> linked report in a specific ASPX web page.
> The usage is like this
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> (encode the Replacementroot value with the server.urlencode function)
> RS will add the report name at the end of this value, so the "ReportName"
> parameter is the parameter passed to the URL filled by RS.
> So, when the page "page.aspx" is called, read the ReportName query string
> (request("ReportName")) to retrieve the drilled report and all the
> associated parameters.
>
> "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > hello masters and gurus,
> >
> > anyone using the reportviewer control provided for integration with
> asp.net
> > webform? what should i do to keep the drilldown report to transfer to
the
> > next report but just on the report viewer control? because when i try to
> > click one..it opens up on the whole page...which is not what i need..
> >
> > thanks in advance guys...
> >
> >
>|||Jéjé,
How did you find the "rc:ReplacementRoot=" URL access command? It is not in the SQL RS documentation that I can find. Did you dig around in the assemblies with Reflector, or did one of the MSFT guys post it here? Are there any other useful undocumented commands? Thanks,
-Josh
"Jéjé" wrote:
> use the rc:replacementroot parameter to inform your reportviewer to open a
> linked report in a specific ASPX web page.
> The usage is like this
> http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> (encode the Replacementroot value with the server.urlencode function)
> RS will add the report name at the end of this value, so the "ReportName"
> parameter is the parameter passed to the URL filled by RS.
> So, when the page "page.aspx" is called, read the ReportName query string
> (request("ReportName")) to retrieve the drilled report and all the
> associated parameters.
>
> "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > hello masters and gurus,
> >
> > anyone using the reportviewer control provided for integration with
> asp.net
> > webform? what should i do to keep the drilldown report to transfer to the
> > next report but just on the report viewer control? because when i try to
> > click one..it opens up on the whole page...which is not what i need..
> >
> > thanks in advance guys...
> >
> >
>
>|||You want rc:LinkTarget. Set the value of this HTML device command to the
window name of your main frame when a report is called. Any drill through
links in the report will open in the specified frame.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"dotnetprogram" <smalleville@.lycos.com> wrote in message
news:uz1YCl2VEHA.1652@.TK2MSFTNGP09.phx.gbl...
> It still didn't solve my problem..sorry i wasn't able to mention this..my
> page has a frames..wherein the left pane displays the list of reports that
> can be used...the right pane therefore is where my report viewer is
> located...when i click the drilldown report on that report..it opens it in
> the whole page and not just on that frame and on that specific report
viewer
> control..
> hope you can help me with this problem...thanks in advance..
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > use the rc:replacementroot parameter to inform your reportviewer to open
a
> > linked report in a specific ASPX web page.
> > The usage is like this
> >
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > (encode the Replacementroot value with the server.urlencode function)
> >
> > RS will add the report name at the end of this value, so the
"ReportName"
> > parameter is the parameter passed to the URL filled by RS.
> > So, when the page "page.aspx" is called, read the ReportName query
string
> > (request("ReportName")) to retrieve the drilled report and all the
> > associated parameters.
> >
> >
> > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > hello masters and gurus,
> > >
> > > anyone using the reportviewer control provided for integration with
> > asp.net
> > > webform? what should i do to keep the drilldown report to transfer to
> the
> > > next report but just on the report viewer control? because when i try
to
> > > click one..it opens up on the whole page...which is not what i need..
> > >
> > > thanks in advance guys...
> > >
> > >
> >
> >
>|||That was unintentionally undocumented. Actually it is a command that we use
for Report Manager and we didn't consider that developers would want to use
it for their own projects, so it didn't get as much attention as the others.
We try very hard to document all available commands.
There will be three new commands in SP1 and those will be documented in the
readme.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Josh Robinson" <Josh Robinson@.discussions.microsoft.com> wrote in message
news:57522785-22AA-4985-A921-D96A0EC66A5B@.microsoft.com...
> Jéjé,
> How did you find the "rc:ReplacementRoot=" URL access command? It is
not in the SQL RS documentation that I can find. Did you dig around in the
assemblies with Reflector, or did one of the MSFT guys post it here? Are
there any other useful undocumented commands? Thanks,
> -Josh
>
> "Jéjé" wrote:
> > use the rc:replacementroot parameter to inform your reportviewer to open
a
> > linked report in a specific ASPX web page.
> > The usage is like this
> >
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > (encode the Replacementroot value with the server.urlencode function)
> >
> > RS will add the report name at the end of this value, so the
"ReportName"
> > parameter is the parameter passed to the URL filled by RS.
> > So, when the page "page.aspx" is called, read the ReportName query
string
> > (request("ReportName")) to retrieve the drilled report and all the
> > associated parameters.
> >
> >
> > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > hello masters and gurus,
> > >
> > > anyone using the reportviewer control provided for integration with
> > asp.net
> > > webform? what should i do to keep the drilldown report to transfer to
the
> > > next report but just on the report viewer control? because when i try
to
> > > click one..it opens up on the whole page...which is not what i need..
> > >
> > > thanks in advance guys...
> > >
> > >
> >
> >
> >|||The current linktarget URL option works only for the first drilled report,
after RS lost this value and use a target = _Top (so the whole page)
RS keep the replacementroot value during each call.
In my usage, I'm using frames, in my ASPX page, I simply send the ReportName
value to the frame like this:
<frame id=Left src="http://pics.10026.com/?src=myleftmenu.aspx">
<frame id=right src='<%= Request("ReportName") %>
When I call a report, I open it like this URL:
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?ReportName>
the content in the < > is URLEncoded
You can create a more complex URL, for example, if you want to keep a state
of your left frame:
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?LeftOption=
Menu1&ReportName>
myframedpage.aspx =<frame id=Left src='myleftmenu.aspx?LeftOption=<%=Request("LeftOption")%>'>
<frame id=right src='<%= Request("ReportName") %>
good luck ! :)
I hope the SP1 provides more option to simplify the drill action.
"Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> a écrit dans le message
de news:u9jSSP$VEHA.2696@.TK2MSFTNGP09.phx.gbl...
> You want rc:LinkTarget. Set the value of this HTML device command to the
> window name of your main frame when a report is called. Any drill through
> links in the report will open in the specified frame.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "dotnetprogram" <smalleville@.lycos.com> wrote in message
> news:uz1YCl2VEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > It still didn't solve my problem..sorry i wasn't able to mention
this..my
> > page has a frames..wherein the left pane displays the list of reports
that
> > can be used...the right pane therefore is where my report viewer is
> > located...when i click the drilldown report on that report..it opens it
in
> > the whole page and not just on that frame and on that specific report
> viewer
> > control..
> >
> > hope you can help me with this problem...thanks in advance..
> >
> > "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> > news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > use the rc:replacementroot parameter to inform your reportviewer to
open
> a
> > > linked report in a specific ASPX web page.
> > > The usage is like this
> > >
> >
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > > (encode the Replacementroot value with the server.urlencode function)
> > >
> > > RS will add the report name at the end of this value, so the
> "ReportName"
> > > parameter is the parameter passed to the URL filled by RS.
> > > So, when the page "page.aspx" is called, read the ReportName query
> string
> > > (request("ReportName")) to retrieve the drilled report and all the
> > > associated parameters.
> > >
> > >
> > > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > hello masters and gurus,
> > > >
> > > > anyone using the reportviewer control provided for integration with
> > > asp.net
> > > > webform? what should i do to keep the drilldown report to transfer
to
> > the
> > > > next report but just on the report viewer control? because when i
try
> to
> > > > click one..it opens up on the whole page...which is not what i
need..
> > > >
> > > > thanks in advance guys...
> > > >
> > > >
> > >
> > >
> >
> >
>|||Yes, your drill throughs will have to support the LinkTarget attribute as
well. What type of action are you using, Jump to Report or Jump to URL? You
may have to convert your reports to Jump to URL. You can still pass
parameters and such if you build your URL as an expression ="http://..."
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:OZmS10$VEHA.4064@.TK2MSFTNGP11.phx.gbl...
> The current linktarget URL option works only for the first drilled report,
> after RS lost this value and use a target = _Top (so the whole page)
> RS keep the replacementroot value during each call.
> In my usage, I'm using frames, in my ASPX page, I simply send the
ReportName
> value to the frame like this:
> <frame id=Left src="http://pics.10026.com/?src=myleftmenu.aspx">
> <frame id=right src='<%= Request("ReportName") %>
> When I call a report, I open it like this URL:
>
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
>
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?ReportName>
> the content in the < > is URLEncoded
> You can create a more complex URL, for example, if you want to keep a
state
> of your left frame:
>
http://myserver/mysite/myframedpage.aspx?ReportName=<http://myserver/reportserver/folder/report
>
name?rc:ReplacementRoot=http://myserver/mysite/myframedpage.aspx?LeftOption=
> Menu1&ReportName>
> myframedpage.aspx => <frame id=Left
src='myleftmenu.aspx?LeftOption=<%=Request("LeftOption")%>'>
> <frame id=right src='<%= Request("ReportName") %>
> good luck ! :)
> I hope the SP1 provides more option to simplify the drill action.
> "Bryan Keller [MSFT]" <bryanke@.online.microsoft.com> a écrit dans le
message
> de news:u9jSSP$VEHA.2696@.TK2MSFTNGP09.phx.gbl...
> > You want rc:LinkTarget. Set the value of this HTML device command to the
> > window name of your main frame when a report is called. Any drill
through
> > links in the report will open in the specified frame.
> >
> > --
> > Bryan Keller
> > Developer Documentation
> > SQL Server Reporting Services
> >
> > A friendly reminder that this posting is provided "AS IS" with no
> > warranties, and confers no rights.
> >
> >
> > "dotnetprogram" <smalleville@.lycos.com> wrote in message
> > news:uz1YCl2VEHA.1652@.TK2MSFTNGP09.phx.gbl...
> > > It still didn't solve my problem..sorry i wasn't able to mention
> this..my
> > > page has a frames..wherein the left pane displays the list of reports
> that
> > > can be used...the right pane therefore is where my report viewer is
> > > located...when i click the drilldown report on that report..it opens
it
> in
> > > the whole page and not just on that frame and on that specific report
> > viewer
> > > control..
> > >
> > > hope you can help me with this problem...thanks in advance..
> > >
> > > "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> > > news:OnjkSeuVEHA.1152@.TK2MSFTNGP09.phx.gbl...
> > > > use the rc:replacementroot parameter to inform your reportviewer to
> open
> > a
> > > > linked report in a specific ASPX web page.
> > > > The usage is like this
> > > >
> > >
> >
>
http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > > > (encode the Replacementroot value with the server.urlencode
function)
> > > >
> > > > RS will add the report name at the end of this value, so the
> > "ReportName"
> > > > parameter is the parameter passed to the URL filled by RS.
> > > > So, when the page "page.aspx" is called, read the ReportName query
> > string
> > > > (request("ReportName")) to retrieve the drilled report and all the
> > > > associated parameters.
> > > >
> > > >
> > > > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > > > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > > hello masters and gurus,
> > > > >
> > > > > anyone using the reportviewer control provided for integration
with
> > > > asp.net
> > > > > webform? what should i do to keep the drilldown report to transfer
> to
> > > the
> > > > > next report but just on the report viewer control? because when i
> try
> > to
> > > > > click one..it opens up on the whole page...which is not what i
> need..
> > > > >
> > > > > thanks in advance guys...
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>|||I understand - I had noticed that some MSFT developer replies in this newsgroup said to "use the ReplacementRoot command" in the past. I didn't realize it was part of SQL RS and I have been using .NET Framework for something like 3 years now and hadn't seen it there either. Glad to know that it is part of Reporting Services and is usable by developers.
"Bryan Keller [MSFT]" wrote:
> That was unintentionally undocumented. Actually it is a command that we use
> for Report Manager and we didn't consider that developers would want to use
> it for their own projects, so it didn't get as much attention as the others.
> We try very hard to document all available commands.
> There will be three new commands in SP1 and those will be documented in the
> readme.
> --
> Bryan Keller
> Developer Documentation
> SQL Server Reporting Services
> A friendly reminder that this posting is provided "AS IS" with no
> warranties, and confers no rights.
>
> "Josh Robinson" <Josh Robinson@.discussions.microsoft.com> wrote in message
> news:57522785-22AA-4985-A921-D96A0EC66A5B@.microsoft.com...
> > Jéjé,
> > How did you find the "rc:ReplacementRoot=" URL access command? It is
> not in the SQL RS documentation that I can find. Did you dig around in the
> assemblies with Reflector, or did one of the MSFT guys post it here? Are
> there any other useful undocumented commands? Thanks,
> >
> > -Josh
> >
> >
> > "Jéjé" wrote:
> >
> > > use the rc:replacementroot parameter to inform your reportviewer to open
> a
> > > linked report in a specific ASPX web page.
> > > The usage is like this
> > >
> http://mysite/reportserver?/reportname&p1=1&p2=2.....&rc:ReplacementRoot=http://mysite/site/page.aspx?ReportName=
> > > (encode the Replacementroot value with the server.urlencode function)
> > >
> > > RS will add the report name at the end of this value, so the
> "ReportName"
> > > parameter is the parameter passed to the URL filled by RS.
> > > So, when the page "page.aspx" is called, read the ReportName query
> string
> > > (request("ReportName")) to retrieve the drilled report and all the
> > > associated parameters.
> > >
> > >
> > > "dotnetprogram" <smalleville@.lycos.com> a écrit dans le message de
> > > news:%23GAy6JXVEHA.2908@.TK2MSFTNGP10.phx.gbl...
> > > > hello masters and gurus,
> > > >
> > > > anyone using the reportviewer control provided for integration with
> > > asp.net
> > > > webform? what should i do to keep the drilldown report to transfer to
> the
> > > > next report but just on the report viewer control? because when i try
> to
> > > > click one..it opens up on the whole page...which is not what i need..
> > > >
> > > > thanks in advance guys...
> > > >
> > > >
> > >
> > >
> > >
>
>

Question about Reports....

Hi all... I am doing Report in Business Intelligence Project. If I preview the report, why is it the data is shown only in 2 pages. It is actually 4 pages if I print it... what should I do to show the 4 pages report if I preview it? Please I need guidance....

thanks.

-Ron-

It is not possible to control the number of pages in any format, either html preview or pdf.

Shyam

|||

On the Layout tab of your report, under the Layout section on the Properties menu, try setting your InteractiveSize to 8.5in, 11in.

|||

triguns wrote:

Hi all... I am doing Report in Business Intelligence Project. If I preview the report, why is it the data is shown only in 2 pages. It is actually 4 pages if I print it... what should I do to show the 4 pages report if I preview it? Please I need guidance....

thanks.

-Ron-

I'm brand new to MS BI and have a similar problem but the even number pages don't have any detail on them.... just header/footer stuff. I've got interactive and page size both set to 8.5X11. Any thoughts?

Thanks!

Leif|||

Do you have any explicit page breaks set?

Another thing that can affect paging is having a control too close to the border of the page. Try leaving a quarter inch or eighth of an inch between the control and the margin.

|||

It is because the data from one page is getting spilled to second page. This happens if the report width in your designer + (left margin+right margin specified in Report Properties -> Layout tab) exceeds the page width that you specify in Report Properties -> Layout tab. For example, if your report is 8 inches wide in your designer and in report properties, you have specified page width=8.5 inch and left margin=1inch, right margin=1inch, data from your pages will spill to next pages because 8 inch (designer report width) + 1 inch (left margin) + inch (right amrgin) > 8.5 inch (page width).

Shyam

Question about Pages

I am looking into a locking issue and I want to find out the specific
rows that live on a page.
Sp_lock returns the following
page id - 1:3873267
But, I don't know of any way to view the data there or correlate it
with specific rows in a table. Is there a way to do this?
Have a look here:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/10/625659.aspx
Andrew J. Kelly SQL MVP
<jbergmanster@.gmail.com> wrote in message
news:1187028314.018378.50630@.m37g2000prh.googlegro ups.com...
>I am looking into a locking issue and I want to find out the specific
> rows that live on a page.
> Sp_lock returns the following
> page id - 1:3873267
> But, I don't know of any way to view the data there or correlate it
> with specific rows in a table. Is there a way to do this?
>
|||Thank you, Andrew for that Blog article. That helped me find the
records I need. I have blogged about my testing of the locking issue
at http://jeffbergman.com/cs/blogs/csjeff/archive/2007/08/13/12.aspx
which describes a locking issue I was having with ADO.Net and the
SqlDataReader.
On Aug 13, 11:30 am, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:[vbcol=seagreen]
> Have a look here:
> http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/10/62565...
> --
> Andrew J. Kelly SQL MVP
> <jbergmans...@.gmail.com> wrote in message
> news:1187028314.018378.50630@.m37g2000prh.googlegro ups.com...
>
>

Question about Pages

I am looking into a locking issue and I want to find out the specific
rows that live on a page.
Sp_lock returns the following
page id - 1:3873267
But, I don't know of any way to view the data there or correlate it
with specific rows in a table. Is there a way to do this?1:3873267 means - datafile number 1, page number 3873267. You can try
undocummented DBCC PAGE statement to find the records on this page.
dbcc page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0|1|2|3} ])
--
Regards
Pawel Potasinski
[http://www.potasinski.pl]
Uzytkownik <jbergmanster@.gmail.com> napisal w wiadomosci
news:1187028314.018378.50630@.m37g2000prh.googlegroups.com...
>I am looking into a locking issue and I want to find out the specific
> rows that live on a page.
> Sp_lock returns the following
> page id - 1:3873267
> But, I don't know of any way to view the data there or correlate it
> with specific rows in a table. Is there a way to do this?
>|||Have a look here:
http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/10/625659.aspx
Andrew J. Kelly SQL MVP
<jbergmanster@.gmail.com> wrote in message
news:1187028314.018378.50630@.m37g2000prh.googlegroups.com...
>I am looking into a locking issue and I want to find out the specific
> rows that live on a page.
> Sp_lock returns the following
> page id - 1:3873267
> But, I don't know of any way to view the data there or correlate it
> with specific rows in a table. Is there a way to do this?
>|||Thank you, Andrew for that Blog article. That helped me find the
records I need. I have blogged about my testing of the locking issue
at http://jeffbergman.com/cs/blogs/csjeff/archive/2007/08/13/12.aspx
which describes a locking issue I was having with ADO.Net and the
SqlDataReader.
On Aug 13, 11:30 am, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:
> Have a look here:
> http://blogs.msdn.com/sqlserverstorageengine/archive/2006/06/10/62565...
> --
> Andrew J. Kelly SQL MVP
> <jbergmans...@.gmail.com> wrote in message
> news:1187028314.018378.50630@.m37g2000prh.googlegroups.com...
> >I am looking into a locking issue and I want to find out the specific
> > rows that live on a page.
> > Sp_lock returns the following
> > page id - 1:3873267
> > But, I don't know of any way to view the data there or correlate it
> > with specific rows in a table. Is there a way to do this?

Question about Pages

I am looking into a locking issue and I want to find out the specific
rows that live on a page.
Sp_lock returns the following
page id - 1:3873267
But, I don't know of any way to view the data there or correlate it
with specific rows in a table. Is there a way to do this?1:3873267 means - datafile number 1, page number 3873267. You can try
undocummented DBCC PAGE statement to find the records on this page.
dbcc page ( {'dbname' | dbid}, filenum, pagenum [, printopt={0
|1|2|3} ])
Regards
Pawel Potasinski
[http://www.potasinski.pl]
Uzytkownik <jbergmanster@.gmail.com> napisal w wiadomosci
news:1187028314.018378.50630@.m37g2000prh.googlegroups.com...
>I am looking into a locking issue and I want to find out the specific
> rows that live on a page.
> Sp_lock returns the following
> page id - 1:3873267
> But, I don't know of any way to view the data there or correlate it
> with specific rows in a table. Is there a way to do this?
>|||Have a look here:
http://blogs.msdn.com/sqlserverstor.../10/625659.aspx
Andrew J. Kelly SQL MVP
<jbergmanster@.gmail.com> wrote in message
news:1187028314.018378.50630@.m37g2000prh.googlegroups.com...
>I am looking into a locking issue and I want to find out the specific
> rows that live on a page.
> Sp_lock returns the following
> page id - 1:3873267
> But, I don't know of any way to view the data there or correlate it
> with specific rows in a table. Is there a way to do this?
>|||Thank you, Andrew for that Blog article. That helped me find the
records I need. I have blogged about my testing of the locking issue
at http://jeffbergman.com/cs/blogs/csj...7/08/13/12.aspx
which describes a locking issue I was having with ADO.Net and the
SqlDataReader.
On Aug 13, 11:30 am, "Andrew J. Kelly" <sqlmvpnooos...@.shadhawk.com>
wrote:[vbcol=seagreen]
> Have a look here:
> http://blogs.msdn.com/sqlserverstor.../06/10/62565...
> --
> Andrew J. Kelly SQL MVP
> <jbergmans...@.gmail.com> wrote in message
> news:1187028314.018378.50630@.m37g2000prh.googlegroups.com...
>
>
>
>