How many pages did ReportingService.Render method generate?

Hi,
I use SQL Server Reporting service SOAP API to render a report into a PDF
file. The method that I use is ReportingService.Render.
Now we are trying to know how many pages we have in the PDF file by Render
method. How can I retrieve number of generated page from reporting service?
Any help would be appreciated,
MaxHello Max,
Based on my scope, it does not seem there is parameter you could get the
page number from the output of rendering. You may need to use your own
count to count the page rendered by using device information settings:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
rsp_prog_soapapi_dev_8bld.asp
Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you Peter for help.
"Peter Yang [MSFT]" <petery@.online.microsoft.com> wrote in message
news:U7qMWncNGHA.128@.TK2MSFTNGXA01.phx.gbl...
> Hello Max,
> Based on my scope, it does not seem there is parameter you could get the
> page number from the output of rendering. You may need to use your own
> count to count the page rendered by using device information settings:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/
> rsp_prog_soapapi_dev_8bld.asp
> Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>

how long need ALTER DATATABLE (DATABASE) SET ENABLE_BROKER ?

I am try to start with SQL BROKER service,

When I lunch from sql Management studio the following query, this don't finish never.

ALTER DATATABLE dbname SET ENABLE_BROKER

Where I am mistaking ?

I've written some article about SB here: http://www.dotnetfun.com/Articles/sql/sql2005/SQL2005ServiceBrokerProblems.aspx

Essentially:

-- Enable Service Broker: ALTER DATABASE [Database Name] SET ENABLE_BROKER; -- Disable Service Broker: ALTER DATABASE [Database Name] SET DISABLE_BROKER; SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database name'; -- Where 'Database name' is the name of the database you want to query. |||

I assume you mean ALTER DATABASE.

ALTER DATABSE dbname SET ENABLE_BROKER requires an exclusive lock on the database. Any session using that database has a shared lock on it, thus bloking the ALTER. So make sure you close (or switch to another database context) all sessions.

HTH,

~ Remus

|||

Holas!

How can I close all the sessions using a query?

Saludos,

|||You can use the WITH ROLLBACK IMMEDIATE clause of the ALTER DATABASE to force the close off conflicting sessions|||

Thanks Ramus,

Saludos,

|||

thank you for your best guidance that was very useful for me to solve my problem.

regard you

mojgan

how long need ALTER DATATABLE (DATABASE) SET ENABLE_BROKER ?

I am try to start with SQL BROKER service,

When I lunch from sql Management studio the following query, this don't finish never.

ALTER DATATABLE dbname SET ENABLE_BROKER

Where I am mistaking ?

I've written some article about SB here: http://www.dotnetfun.com/Articles/sql/sql2005/SQL2005ServiceBrokerProblems.aspx

Essentially:

-- Enable Service Broker: ALTER DATABASE [Database Name] SET ENABLE_BROKER; -- Disable Service Broker: ALTER DATABASE [Database Name] SET DISABLE_BROKER; SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database name'; -- Where 'Database name' is the name of the database you want to query. |||

I assume you mean ALTER DATABASE.

ALTER DATABSE dbname SET ENABLE_BROKER requires an exclusive lock on the database. Any session using that database has a shared lock on it, thus bloking the ALTER. So make sure you close (or switch to another database context) all sessions.

HTH,

~ Remus

|||

Holas!

How can I close all the sessions using a query?

Saludos,

|||You can use the WITH ROLLBACK IMMEDIATE clause of the ALTER DATABASE to force the close off conflicting sessions|||

Thanks Ramus,

Saludos,

|||

thank you for your best guidance that was very useful for me to solve my problem.

regard you

mojgan

how long need ALTER DATATABLE (DATABASE) SET ENABLE_BROKER ?

I am try to start with SQL BROKER service,

When I lunch from sql Management studio the following query, this don't finish never.

ALTER DATATABLE dbname SET ENABLE_BROKER

Where I am mistaking ?

I've written some article about SB here: http://www.dotnetfun.com/Articles/sql/sql2005/SQL2005ServiceBrokerProblems.aspx

Essentially:

-- Enable Service Broker: ALTER DATABASE [Database Name] SET ENABLE_BROKER; -- Disable Service Broker: ALTER DATABASE [Database Name] SET DISABLE_BROKER; SELECT is_broker_enabled FROM sys.databases WHERE name = 'Database name'; -- Where 'Database name' is the name of the database you want to query. |||

I assume you mean ALTER DATABASE.

ALTER DATABSE dbname SET ENABLE_BROKER requires an exclusive lock on the database. Any session using that database has a shared lock on it, thus bloking the ALTER. So make sure you close (or switch to another database context) all sessions.

HTH,

~ Remus

|||

Holas!

How can I close all the sessions using a query?

Saludos,

|||You can use the WITH ROLLBACK IMMEDIATE clause of the ALTER DATABASE to force the close off conflicting sessions|||

Thanks Ramus,

Saludos,

|||

thank you for your best guidance that was very useful for me to solve my problem.

regard you

mojgan

|||Hi there,

I faced the same problem you have mentioned.

Then, I found a simple solution. You need to use the following 2 statements together, and the query will finish in no time:

Use NorthWind
alter database NorthWind SET ENABLE_BROKER

How long does it take to startup SQL Service with AWE enabled

Hi,
We have a fail-over cluster with a SQL Server 2000 instance installed on it.
There are 6GB memory available on the cluster, and we have the /PAE switch
turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL
server. but from what I read about turn on AWE, some paper warned that the
startup process of SQL service will take a lot longer. Does anybody have
experience about how long it takes to startup SQL in a cluster with AWE
enabled with 3GB memory allocated? And if we experience a timeout error
before SQL Service started, what can we do?
Thanks
Hong Wang
Yes, the failover process will take longer with AWE enabled. The reason is
that the AWE memory must be "zeroed out." This takes extra time. However,
we have found that the Recovery Interval controls most of the failover
timing and that managing the Shared Volumes consumes more time than the AWE
clearing.
With 8 GB RAM, Windows 2000, SQL Server max server memory set to 6.5 GB, a
typical failover for a busy system could take 3 to 5 minutes. The recovery
process could take up to 15 minutes or so on a busy system once services
were restored on the new node.
There is also a KB article that discusses application processes "awareness"
of clustered instances. Basically, the application must use retry logic for
detected database connectivity errors, which can be trapped. However, this
would be good practice even if the database was hosted on a stand-alone
system.
Sincerely,
Anthony Thomas

"Hong Wang" <HongWang@.discussions.microsoft.com> wrote in message
news:4CBDA708-88EF-49F6-A55C-70C3F90F5F1A@.microsoft.com...
> Hi,
> We have a fail-over cluster with a SQL Server 2000 instance installed on
it.
> There are 6GB memory available on the cluster, and we have the /PAE switch
> turned on. I want to enable AWE in SQL Server and allocate 3-4GB to SQL
> server. but from what I read about turn on AWE, some paper warned that the
> startup process of SQL service will take a lot longer. Does anybody have
> experience about how long it takes to startup SQL in a cluster with AWE
> enabled with 3GB memory allocated? And if we experience a timeout error
> before SQL Service started, what can we do?
> Thanks
> Hong Wang

How I see what Service pack I have

I cannot find what service pack I had install in my Server.
Can anyone tell me where I can see it.
RafaelSELECT serverproperty('productlevel')
--
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message
news:ux2PQ82fGHA.324@.TK2MSFTNGP02.phx.gbl...
>I cannot find what service pack I had install in my Server.
> Can anyone tell me where I can see it.
>
> Rafael
>|||Rafael,
Check out:
How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/en-us
HTH
Jerry
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message
news:ux2PQ82fGHA.324@.TK2MSFTNGP02.phx.gbl...
>I cannot find what service pack I had install in my Server.
> Can anyone tell me where I can see it.
>
> Rafael
>

How I see what Service pack I have

I cannot find what service pack I had install in my Server.
Can anyone tell me where I can see it.
RafaelSELECT serverproperty('productlevel')
HTH
Kalen Delaney, SQL Server MVP
www.solidqualitylearning.com
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message
news:ux2PQ82fGHA.324@.TK2MSFTNGP02.phx.gbl...
>I cannot find what service pack I had install in my Server.
> Can anyone tell me where I can see it.
>
> Rafael
>|||Rafael,
Check out:
How to identify your SQL Server version and edition
http://support.microsoft.com/kb/321185/en-us
HTH
Jerry
"Rafael Tejera" <rafaeltejera@.hotmail.com> wrote in message
news:ux2PQ82fGHA.324@.TK2MSFTNGP02.phx.gbl...
>I cannot find what service pack I had install in my Server.
> Can anyone tell me where I can see it.
>
> Rafael
>

how get the DataSetDefinition of a report by Reporting Services Web Service

it seems that 2 ways

1.PrepareQuery ()
but it need a parameter :DataSetDefinition ?

2.GetDataDrivenSubscriptionProperties ()
but ListSubscriptions() return 0 rows

how ?

Dear ,

Pls give details about ur question?

Regards

sufian