Problem with SQL Service Pack 4

I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
install says it completed but after I rebooted and did a select @.@.version it
still shows SP3. I only have a default instance so I know that it installed
on the right instance. Could anyone help me out with this?You can review the setup log for any errors (file called sqlsp.log in the
windows directory). It is perfectly safe to run SP4 again to try and make it
stick (assuming you have the system database backups just in case you need
to regress)
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||I tried it several times but got the same result.
I've attached a copy of my sqlsp.log file. I looked at the sqlsp.log file
and it only listed one non-fatal error...I can't see this being the problem
considering it was nonfatal.
Jasper Smith wrote:
>You can review the setup log for any errors (file called sqlsp.log in the
>windows directory). It is perfectly safe to run SP4 again to try and make it
>stick (assuming you have the system database backups just in case you need
>to regress)
>>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
>> install says it completed but after I rebooted and did a select @.@.version
>> it
>> still shows SP3. I only have a default instance so I know that it
>> installed
>> on the right instance. Could anyone help me out with this?|||What does the following query return?
SELECT SERVERPROPERTY('ProductLevel')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||SP3....
Dan Guzman wrote:
>What does the following query return?
> SELECT SERVERPROPERTY('ProductLevel')
>>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
>> install says it completed but after I rebooted and did a select @.@.version
>> it
>> still shows SP3. I only have a default instance so I know that it
>> installed
>> on the right instance. Could anyone help me out with this?
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server/200606/1sql

Problem with SQL Service Pack 4

You can review the setup log for any errors (file called sqlsp.log in the
windows directory). It is perfectly safe to run SP4 again to try and make it
stick (assuming you have the system database backups just in case you need
to regress)
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?I tried it several times but got the same result.
I've attached a copy of my sqlsp.log file. I looked at the sqlsp.log file
and it only listed one non-fatal error...I can't see this being the problem
considering it was nonfatal.
Jasper Smith wrote:[vbcol=seagreen]
>You can review the setup log for any errors (file called sqlsp.log in the
>windows directory). It is perfectly safe to run SP4 again to try and make i
t
>stick (assuming you have the system database backups just in case you need
>to regress)
>|||I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
install says it completed but after I rebooted and did a select @.@.version it
still shows SP3. I only have a default instance so I know that it installed
on the right instance. Could anyone help me out with this?|||You can review the setup log for any errors (file called sqlsp.log in the
windows directory). It is perfectly safe to run SP4 again to try and make it
stick (assuming you have the system database backups just in case you need
to regress)
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||I tried it several times but got the same result.
I've attached a copy of my sqlsp.log file. I looked at the sqlsp.log file
and it only listed one non-fatal error...I can't see this being the problem
considering it was nonfatal.
Jasper Smith wrote:[vbcol=seagreen]
>You can review the setup log for any errors (file called sqlsp.log in the
>windows directory). It is perfectly safe to run SP4 again to try and make i
t
>stick (assuming you have the system database backups just in case you need
>to regress)
>|||What does the following query return?
SELECT SERVERPROPERTY('ProductLevel')
Hope this helps.
Dan Guzman
SQL Server MVP
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||What does the following query return?
SELECT SERVERPROPERTY('ProductLevel')
Hope this helps.
Dan Guzman
SQL Server MVP
"Leon Parker" <u23479@.uwe> wrote in message news:625d255c1f101@.uwe...
>I upgraded from SQL 2000 Service Pack 3 to SQL 2000 Service Pack 4. The
> install says it completed but after I rebooted and did a select @.@.version
> it
> still shows SP3. I only have a default instance so I know that it
> installed
> on the right instance. Could anyone help me out with this?|||SP3....
Dan Guzman wrote:[vbcol=seagreen]
>What does the following query return?
> SELECT SERVERPROPERTY('ProductLevel')
>
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1|||SP3....
Dan Guzman wrote:[vbcol=seagreen]
>What does the following query return?
> SELECT SERVERPROPERTY('ProductLevel')
>
Message posted via droptable.com
http://www.droptable.com/Uwe/Forum...server/200606/1

Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

PROCEDURE dbo.uspStorage_AreaGrowthTrend
PROCEDURE dbo.uspStorage_ListGrowthTrend
PROCEDURE dbo.uspStorage_SiteCollectionTrend
PROCEDURE dbo.uspStorage_SizeTrend
PROCEDURE dbo.usp_StartDateEndDate_Retrieve

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani

Problem with Report Pack for sharepoint's, rpdataextraction parser

hi,

when i try to execute the rpdataextraction parser, i am getting the following message - Unable to access site collection: User cannot be found.

it will be of immense help for me if any one helps me on this or directs me to right resource.

thanks

hello,

I have the same problem, so yesterday I found a possible solution for this problem, I'm trying to follow it:

There are a french blog for this issue: http://fmdain.blogspot.com/2006/06/reporting-pack-sps.pour-sql2k5.html.

The solution consist in:

1 - Verify that the tables DimDate and DimTime was complete filled. In my case the DimTime wasn't.

2 - an edition on procedures on database dbSPSReporting, to comment's lines : WHERE dd.DateFull and DATEADD, for all procedures on database.

I localized only those below:

PROCEDURE dbo.uspStorage_AreaGrowthTrend
PROCEDURE dbo.uspStorage_ListGrowthTrend
PROCEDURE dbo.uspStorage_SiteCollectionTrend
PROCEDURE dbo.uspStorage_SizeTrend
PROCEDURE dbo.usp_StartDateEndDate_Retrieve

If you use this solution and works, please send me a confirmation and any other comments about, or other solution.

Regards,

Ernani

Problem with report manager find command

I am using sql server reporting services with service pack 2 applied. One of
my users has encountered a strange problem using the find command after a
report has been run.
If you try to use the find command in the report manager to locate a string
that is in the last group on a page, it will report "The search text was not
found". The find command works fine for test in all other groups on the
report. If you export the report to pdf, the acrobat search function will
find the text. I have tested several of my reports they all seem to have the
same problem.
Has anyone else had this problem with the find command in the report
manager? Any idea how to fix it?Hi,
Welcome to use MSDN Managed Newsgroup Support.
To state the problem clearly, would you tell me how you are searching the
string in report manager?
Do you use the Ctrl-F to find a string in a report via browser? If so,
which browser and what version do you use?
The Search for Feature in the Report Manager Page can only search published
reports, folders, shared data sources, and resources.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
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.|||Thanks for the input. I will try to be more clear.
Here is the procedure I am using. First I am run the report in Internet
Explorer 6. I type the search string into the text box which appears between
the zoom factor (100%) and the word find. When I hover my mouse over the
text box a tool tip pops up and displays "find text". Finally, I click on
the word "Find".
Normally the report will jump to wherever the search string is first found
in the report, regardless of which page it appears on. As I stated earlier
if the search string appears in the last group on a page, for some reason it
will not be found.
I noticed today that the problem only seems to occur if the last group on
the page spans onto the next page. If the last group on the page finishes on
the page you can successfully find items in that group.
"Wei Lu" wrote:
"Wei Lu" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup Support.
> To state the problem clearly, would you tell me how you are searching the
> string in report manager?
> Do you use the Ctrl-F to find a string in a report via browser? If so,
> which browser and what version do you use?
> The Search for Feature in the Report Manager Page can only search published
> reports, folders, shared data sources, and resources.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> 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.
>
>|||Hi Guess,
Thank you for update. I understood your concern is that you are trying to
search the string in a report with a html viewer and you can not find it if
the string in the last group. If I misunderstood your concern, please feel
free to point it out.
In the reporting service, this Search feature searches for content in the
report by typing a word or phrase that you want to find (the maximum value
length is 256 characters). The search is case-insensitive and begins at the
page or section that is currently selected. Only visible content is
included in a search operation. This search feature is based on javascript.
So I'd like to know if you use the Ctrl-F to search the string, will you
find it properly? Is this string visible or not?
Also you may want to insert a page break after the table to test.
Further, if you installed the Sample, you may check if the issue occurs on
¡"product catalog" sample report.
Thank you for your patience and cooperations. Please let me know your
results with this so that I can provide further association. I look forward
your reply.
Sincerely yours,
Wei Lu
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.|||Hi Wei,
Thanks for you efforts.
To answer your question, the text is visible. If I use Ctrl-F, it does find
the text as long as I am currently on the page where the text appears. In my
experience, the find/next commands in the report manager will find a string
on the current page as well as all other pages (both before and after the
current page) except in the circumstances described in my earlier posts.
The problem I am having does occur in the Product Catalog sample report.
For example on page five, the last line of the report has product no. of
"BK-M38S-56". The find command will not find this product no.. If I use
Ctrl-F it will find the product no., as long as I am on page 5. In fact I
can not use the find/next commands to locate any product no. in the
"Mountain-400" section on page 5.
The sample reports are on my local machine. The earlier reports I tested
were on our application server. I am curious to know if you experience the
same problem on page 5 of the product catalog.
I tried adding a page break after the table in the Product Catalog sample
report. It did not make any difference.
"Wei Lu" wrote:
> Hi Guess,
> Thank you for update. I understood your concern is that you are trying to
> search the string in a report with a html viewer and you can not find it if
> the string in the last group. If I misunderstood your concern, please feel
> free to point it out.
> In the reporting service, this Search feature searches for content in the
> report by typing a word or phrase that you want to find (the maximum value
> length is 256 characters). The search is case-insensitive and begins at the
> page or section that is currently selected. Only visible content is
> included in a search operation. This search feature is based on javascript.
> So I'd like to know if you use the Ctrl-F to search the string, will you
> find it properly? Is this string visible or not?
> Also you may want to insert a page break after the table to test.
> Further, if you installed the Sample, you may check if the issue occurs on
> ¡"product catalog" sample report.
> Thank you for your patience and cooperations. Please let me know your
> results with this so that I can provide further association. I look forward
> your reply.
> Sincerely yours,
> Wei Lu
> 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.
>|||Hi Guess,
I have searched in our internal knowledge base, it is a known issue in
Reporting Service and is fixed in SQL Server 2005 Reporting Services.
For now, if it has much business impact on you, I recommend that you open a
Support incident
with Microsoft Customer Service and Support (CSS) so that a dedicated
Support Professional can work with you in a more timely and efficient
manner. If you need any help in this regard, please let me know.
For a complete list of Microsoft Customer Service and Support phone
numbers, please go to the following address on the World Wide Web:
<http://support.microsoft.com/directory/overview.asp>
If you are outside the US please see http://support.microsoft.com for
regional support phone numbers.
If there are further questions on the issue, please feel free to let us
know. Have a great day!
Sincerely yours,
Wei Lu
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.

Problem with Prepared Statements

Hi
we are developing a java application, which connects to a MS SQL Server 2000
via the Microsoft JDBC Drive Service Pack 3.
Due to the fact that we have massiv performance problems with MS SQL. I
started profiling our MS SQL Server.
I've recognized during analyzing the traces, that the variables of every
prepared Sql command are defined as nvarchar(4000) or Decimal(38,0). Quite
confusing by the fact that the lenght of the fields is not exceeding 50
signs in the tables as well as in the variable used within our application.
I not understand the behaviour of the JDBC Driver. Is there a problem
defining the length of prepared parameters ?
Cause within ODBC i am able to define the length of input values in order to
reduce the amount of data being in access by the sql engine.
kind regards
chris
Christian Billig wrote:

> Hi
> we are developing a java application, which connects to a MS SQL Server 2000
> via the Microsoft JDBC Drive Service Pack 3.
> Due to the fact that we have massiv performance problems with MS SQL. I
> started profiling our MS SQL Server.
> I've recognized during analyzing the traces, that the variables of every
> prepared Sql command are defined as nvarchar(4000) or Decimal(38,0). Quite
> confusing by the fact that the lenght of the fields is not exceeding 50
> signs in the tables as well as in the variable used within our application.
> I not understand the behaviour of the JDBC Driver. Is there a problem
> defining the length of prepared parameters ?
> Cause within ODBC i am able to define the length of input values in order to
> reduce the amount of data being in access by the sql engine.
> kind regards
> chris
Hi. The declared length of the varchar variables are not crucial, but
if you have real VARCHAR columns, and the driver is sending data as
NVARCHARs, then your varchar indexes won't be used, so you will have
slow table scans. The solution for that is to set the JDBC connection
property SendStringParametersAsUnicode=false. The driver by default
sends data as 16-bit characters so any Java char is sent correctly.
As long as you are using standard English 8-bit ASCII characters,
you don't need to send as UNICODE.
Let me know if this takes care of the problem.
Joe
|||Hi Joe
setting the property SendStringParametersAsUnicode=false did not change the
performance.
What still is confusing are the Trace Results.
Executing a SQL Statement as prepared statement in a loop just changing the
binded values for 50 times,
is resulting for Java in a trace with 50 statements exec sp_cursoropen.
Doing the same in c# und using an OleDB Connection with the exact same SQL
and value is leading to a different Trace
which contains one statement with "exec sp_prepexec" and 49 statements of
"exec sp_execute".
May i'm doing something wrong ? Or is that really the right behaviour ? It
looks to me that in our java application the PrepareStatement is not really
executed.
bye
chris
|||Seems to be a problem of the JDBC Driver even prepare Insert and Update
statements are being executed as sp_executesql
where as using the jdbc 2005 beta 1 driver they are executed as sp_prepexec
and sp_execute.
Even Select statements which were executed as cursor-open, -fetch and -close
are now executed as sp_prepexec and sp_execute as long as the resultset is
text_forward_only.
Due to the fact that we need scrollable resultsets the former behaviour is
ok
During testing the JDBC 2005 Beta 1 we recognized a bug in this
constellation.The SQL Statement used for opening the cursor is not prepared
any longer although we are using the preparedstatement method. That causes
an immens memory usage until the SQL Server reachs the allowed maximum
memory usage and begins to use the swap file.
|||forgot the log
Both Statements were executed as PreparedStatement with an insensitive
Cursor ResultSet.
JDBC 2000 on SQL Server 2000 SP4
declare @.P1 int
set @.P1=0
declare @.P2 int
set @.P2=4104
declare @.P3 int
set @.P3=8193
declare @.P4 int
set @.P4=0
exec sp_cursoropen @.P1 output, N'SELECT "LVORLP".* FROM "LVORLP" WHERE
("LVBNKZ" = @.P1 AND "LVFIRM" = @.P2 AND ("LVABRJ" > @.P3 OR "LVABRJ" = @.P4 AND
"LVABRM" > @.P5 OR "LVABRJ" = @.P6 AND "LVABRM" = @.P7 AND "LVABGR" > @.P8 OR
"LVABRJ" = @.P9 AND "LVABRM" = @.P10 AND "LVABGR" = @.P11 AND "LVSABE" > @.P12
OR "LVABRJ" = @.P13 AND "LVABRM" = @.P14 AND "LVABGR" = @.P15 AND "LVSABE" =
@.P16 AND "LVPRNR" >= @.P17)) ORDER BY "LVABRJ", "LVABRM", "LVABGR", "LVSABE",
"LVPRNR"', @.P2 output, @.P3 output, @.P4 output, N'@.P1 varbinary(8000) ,@.P2
varbinary(8000) ,@.P3 decimal(38,0) ,@.P4 decimal(38,0) ,@.P5 decimal(38,0)
,@.P6 decimal(38,0) ,@.P7 decimal(38,0) ,@.P8 varbinary(8000) ,@.P9
decimal(38,0) ,@.P10 decimal(38,0) ,@.P11 varbinary(8000) ,@.P12
varbinary(8000) ,@.P13 decimal(38,0) ,@.P14 decimal(38,0) ,@.P15
varbinary(8000) ,@.P16 varbinary(8000) ,@.P17 decimal(38,0) ', 0x42,
0x303031, -9999, -9999, -99, -9999, -99, 0x00, -9999, -99, 0x00,
0x000000, -9999, -99, 0x00, 0x000000, -999999
select @.P1, @.P2, @.P3, @.P4
JDBC 2005 Beta 1 on SQL Server 2000 SP4
RPC Starting
declare @.P1 int
set @.P1=0
declare @.P2 int
set @.P2=0
exec sp_cursoropen @.P1 output, 'SELECT "LVORLP".* FROM "LVORLP" WHERE
(("LVBNKZ" > 0x42) OR ("LVBNKZ" = 0x42 AND "LVFIRM" > 0x303031) OR ("LVBNKZ"
= 0x42 AND "LVFIRM" = 0x303031 AND "LVABRJ" > 2005) OR ("LVBNKZ" = 0x42 AND
"LVFIRM" = 0x303031 AND "LVABRJ" = 2005 AND "LVABRM" > 9) OR ("LVBNKZ" =
0x42 AND "LVFIRM" = 0x303031 AND "LVABRJ" = 2005 AND "LVABRM" = 9 AND
"LVABGR" > 0x20) OR ("LVBNKZ" = 0x42 AND "LVFIRM" = 0x303031 AND "LVABRJ" =
2005 AND "LVABRM" = 9 AND "LVABGR" = 0x20 AND "LVSABE" > 0x202020) OR
("LVBNKZ" = 0x42 AND "LVFIRM" = 0x303031 AND "LVABRJ" = 2005 AND "LVABRM" =
9 AND "LVABGR" = 0x20 AND "LVSABE" = 0x202020 AND "LVPRNR" >= 0)) ORDER BY
"LVBNKZ", "LVFIRM", "LVABRJ", "LVABRM", "LVABGR", "LVSABE", "LVPRNR"', 8, 1,
@.P2 output
select @.P1, @.P2