Page break & Service Pack !

Can anyone let me know how I check which Service Pack I do have in SQL
Server Reporting Services.
The second problem is in the reporting services I can see all the pages but
when I export in to PDF I can see proper page break, any idea what's the
problem.
ThanksOn Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Can anyone let me know how I check which Service Pack I do have in SQL
> Server Reporting Services.
> The second problem is in the reporting services I can see all the pages but
> when I export in to PDF I can see proper page break, any idea what's the
> problem.
> Thanks
The first answer is as follows:
SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
('edition') AS SQLServerEdition
To get version specs check this link.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
For the second question, if I'm understanding you correctly, the
interface has no page breaks by default. it all appears as a single
page. The PDF renderer breaks it up into pages.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Is that version gave me SQL Server Reporting Services.
"EMartinez" <emartinez.pr1@.gmail.com> wrote in message
news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
>> Can anyone let me know how I check which Service Pack I do have in SQL
>> Server Reporting Services.
>> The second problem is in the reporting services I can see all the pages
>> but
>> when I export in to PDF I can see proper page break, any idea what's the
>> problem.
>> Thanks
>
> The first answer is as follows:
> SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> ('edition') AS SQLServerEdition
> To get version specs check this link.
> http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> For the second question, if I'm understanding you correctly, the
> interface has no page breaks by default. it all appears as a single
> page. The PDF renderer breaks it up into pages.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Oct 15, 8:46 am, "Rogers" <naiss...@.hotmail.com> wrote:
> Is that version gave me SQL Server Reporting Services.
> "EMartinez" <emartinez...@.gmail.com> wrote in message
> news:1192244268.917148.26670@.e9g2000prf.googlegroups.com...
> > On Oct 12, 10:01 am, "Rogers" <naiss...@.hotmail.com> wrote:
> >> Can anyone let me know how I check which Service Pack I do have in SQL
> >> Server Reporting Services.
> >> The second problem is in the reporting services I can see all the pages
> >> but
> >> when I export in to PDF I can see proper page break, any idea what's the
> >> problem.
> >> Thanks
> > The first answer is as follows:
> > SELECT SERVERPROPERTY('productversion') AS SQLServerVersion,
> > SERVERPROPERTY ('productlevel') AS ServicePackLevel, SERVERPROPERTY
> > ('edition') AS SQLServerEdition
> > To get version specs check this link.
> >http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185
> > For the second question, if I'm understanding you correctly, the
> > interface has no page breaks by default. it all appears as a single
> > page. The PDF renderer breaks it up into pages.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If I understand you correctly, generally speaking, the service pack
level of SQL Server is the same as for SSRS/Reporting Services that
you are running. Hope this clarifies it further.
Regards,
Enrique Martinez
Sr. Software Consultant

Page brakes after top group item

I just started with reporting services.
I created report that has two groujping items in the table. Everything works
fine just I always get second row for the top level group on the second
page. This doesn't make any sense to me
1) I am using HTML rending and I don't need all this pages
2) the top group item has only one detailed item and second has about 8
items they all can fit on one page even if viewed in collapsed state
3) There are no any forced page breaks for any table items and for table
itself.
Any ideas how to solve the problem?
ShimonSorry
I just figure out that it looks like that only in preview but on the site it
looks fine.
Thanks,
Shimon.
"Shimon Sim" <estshim@.att.net> wrote in message
news:eeQ3XrQeEHA.2376@.tk2msftngp13.phx.gbl...
> I just started with reporting services.
> I created report that has two groujping items in the table. Everything
works
> fine just I always get second row for the top level group on the second
> page. This doesn't make any sense to me
> 1) I am using HTML rending and I don't need all this pages
> 2) the top group item has only one detailed item and second has about 8
> items they all can fit on one page even if viewed in collapsed state
> 3) There are no any forced page breaks for any table items and for table
> itself.
> Any ideas how to solve the problem?
> Shimon
>

Page (1:14440325), slot 6 for text, ntext,or image node does not e

Hello,
This is the second time in less than 2 weeks this has happened to my db
server.
Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
FULLSCAN after obtaining the table info. from the following
dbcc traceon(3604)
dbcc page(dbname,1, 14440325)
dbcc traceoFF(3604)
Do not know why it is happening��
TIA,
Manoj Kumar
DBCC is of limited use when dealing with BLOB data types. Generally when
you have repeated allocation mismatches, there is an underlying hardware
problem. I would check the system and application event logs for a disk
subsystem fault.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
> Hello,
> This is the second time in less than 2 weeks this has happened to my db
> server.
>
> Page (1:14440325), slot 6 for text, ntext, or image node does not exist..
> I have performed a dbcc checktable and UPDATE STATISTICS ��TBLNAME�� WITH
> FULLSCAN after obtaining the table info. from the following
> dbcc traceon(3604)
> dbcc page(dbname,1, 14440325)
> dbcc traceoFF(3604)
> Do not know why it is happening��
>
> TIA,
> --
> Manoj Kumar
|||Thanks Geoff.
I do not see any issues in the evt log which are related with physical disk
subsystem or RAM although the dbcc page(DBName,1, 19440325,2) does indicate a
data corruption!!
Manoj Kumar
"Geoff N. Hiten" wrote:

> DBCC is of limited use when dealing with BLOB data types. Generally when
> you have repeated allocation mismatches, there is an underlying hardware
> problem. I would check the system and application event logs for a disk
> subsystem fault.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "Manoj Kumar" <ManojKumar@.discussions.microsoft.com> wrote in message
> news:C1AE4DDE-F52A-4151-A634-01BB3F3E3063@.microsoft.com...
>

Packages, Jobs and Scheduling issues

I'm starting to have second thoughts about switching to SQL 2005.

After hours of trying, I finally managed to get SSIS packages to run as intended. Now, I need to create a schedule for the package. I create a job, owned by the Local System account, which SQL Server Agent also uses. I can run the Package myself, but when I schedule it, it always fails. After much trial and error, I decided to give up on this manner of running SSIS packages. I decided to create the job as a CmdExec type job instead. When run manually, it woks fine, but when I schedule it, it doesn't run. Now, it's not that it gives an error message, it just DOESN'T run, it appears as "not scheduled" in the Job Activity Monitor, even though the schedule is listed in the Schedules property. How then, can I schedule the command to run? Thanks for the info.

The reason is very simple the local systems account does not have access to network resources anything you run through that account fails. xp_cmdshell is a better choice but you have to create a proxy to admin level account to run the Agent. All you need is covered below post again if you still need help, I know it works and can run for hours like clock work.

http://support.microsoft.com/kb/912911

|||

I usually run the Sql Server Agent under a service account that has the privilges required to run any processing.

You may run into another issue where errors in Analysis Services Commands are not reported when run via the Sql Server Agent. I am in the process of trying to find out if MS is aware of this issue. It appears to be an issue in all versions of SQL 2005 up to and including SP2.

sql

Packages, Jobs and Scheduling issues

I'm starting to have second thoughts about switching to SQL 2005.

After hours of trying, I finally managed to get SSIS packages to run as intended. Now, I need to create a schedule for the package. I create a job, owned by the Local System account, which SQL Server Agent also uses. I can run the Package myself, but when I schedule it, it always fails. After much trial and error, I decided to give up on this manner of running SSIS packages. I decided to create the job as a CmdExec type job instead. When run manually, it woks fine, but when I schedule it, it doesn't run. Now, it's not that it gives an error message, it just DOESN'T run, it appears as "not scheduled" in the Job Activity Monitor, even though the schedule is listed in the Schedules property. How then, can I schedule the command to run? Thanks for the info.

The reason is very simple the local systems account does not have access to network resources anything you run through that account fails. xp_cmdshell is a better choice but you have to create a proxy to admin level account to run the Agent. All you need is covered below post again if you still need help, I know it works and can run for hours like clock work.

http://support.microsoft.com/kb/912911

|||

I usually run the Sql Server Agent under a service account that has the privilges required to run any processing.

You may run into another issue where errors in Analysis Services Commands are not reported when run via the Sql Server Agent. I am in the process of trying to find out if MS is aware of this issue. It appears to be an issue in all versions of SQL 2005 up to and including SP2.

Package dies after about 10000 seconds.

I have written a package that archives off old orders over night, it appears that this package is failing after about 10000 second every time it is run. I don't think it is memory as I am running it and checking for memory leaks.

Basic run down of package is

EXEcute SQL task to get orders to delete

If a for loop, loop each ordernumber

within the for loop there are 2 dataflow

dataflow 1

find related records in child tables (oldb connection using query)

using a mutli split first

check (with lookup) for records already in archive database

only copy on a fail from the look up

second

delete related records

dataflow 2

do the same but for the parent table

SP1 CTP is installed on server.

Any ideas?

You need to identify where the bottleneck is. Your log file should give some clues as to which task is taking a long time..

-Jamie

|||This might sound like a dumb question but were is my log file?|||

Not a dumb question at all.

You need to configure logging for your package. Right-click on the control-flow surface and select "Logging..."

-Jamie

|||If you have any connection to remote db's, you also want to check that. Some connection get lost or drop after runn continues for a couple of min, hour etc. (i happened to me once because the vendor from which i was downloading the data from had a batch process at their end that always interrupted my download)
Also, you can try doing batch insert to your achieve table by setting the Row per batch to a decent number. That may help it yours inserts are very very larg.

But first, check your loggs as jamei said

overlapping job

Hi,
If a job is scheduled to run every minute, what happens if
the job takes longer than 1 minute to execute.
Will a second occurence of the job run or will it wait for
the first occurence of the job to finish or will it not
run.
Thanks,
ned
To take an example, if the job takes 1 min 10 seconds to run and is
scheduled to run every minute it will in fact run every 2 minutes.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ned Radenovic" <anonymous@.discussions.microsoft.com> wrote in message
news:00c901c492b7$ea326c20$a401280a@.phx.gbl...
> Hi,
>
> If a job is scheduled to run every minute, what happens if
> the job takes longer than 1 minute to execute.
> Will a second occurence of the job run or will it wait for
> the first occurence of the job to finish or will it not
> run.
> Thanks,
> ned
|||Thanks,
Ned
>--Original Message--
>To take an example, if the job takes 1 min 10 seconds to
run and is
>scheduled to run every minute it will in fact run every 2
minutes.
>--
>HTH
>Jasper Smith (SQL Server MVP)
>http://www.sqldbatips.com
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>"Ned Radenovic" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:00c901c492b7$ea326c20$a401280a@.phx.gbl...
if[vbcol=seagreen]
for
>
>.
>