an interesting problem

I manage a news database oriented website where there is a column named
'news' in a table 'news' storing huge HTML formatted artciles. I had to
replace a particular word 'india' by 'world' in all the records under this
column. Strange thing is the occurances of the word 'india' towards the end
of the articles are getting recognized by
select count(*) from news where charindex('india',news)>0
i.e. the above query results 0. Though there are thousands of records in
the column 'news' containing the word 'india'.
I think the issue is of max limit of charindex.
Please help at the earliest convenience of yours.
Regards,
John-I think the issue is of max limit of charindex.
No I don=B4t think so, because Charindex returns an INT, so there should
be a problem if the character would be found at the
2,147,483,648 +1. So are you searching on the right table and database
? That should return a hit, if the word india is present in there.
HTH, jens Suessmeyer.|||John
Did you try LIKE operator?
"John" <netconsul@.gmail.com> wrote in message
news:ePx4t626FHA.1140@.tk2msftngp13.phx.gbl...
>I manage a news database oriented website where there is a column named
>'news' in a table 'news' storing huge HTML formatted artciles. I had to
>replace a particular word 'india' by 'world' in all the records under this
>column. Strange thing is the occurances of the word 'india' towards the end
>of the articles are getting recognized by
> select count(*) from news where charindex('india',news)>0
>
> i.e. the above query results 0. Though there are thousands of records in
> the column 'news' containing the word 'india'.
> I think the issue is of max limit of charindex.
> Please help at the earliest convenience of yours.
> Regards,
> John
>
>
>|||Thats what my problem is.
select news from news where news like '%india%'
results in 74000+ records while
select count(*) from news where charindex('india',news)>0
returns none.
I am using charindex to find the position of India in the record and use
'updatetext' to replace it by world.
because charindex('india',news) returns 0, updatetext cant replace india in
each record by world.
Any quick help will be appreciated.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1132230042.794270.99970@.g43g2000cwa.googlegroups.com...
-I think the issue is of max limit of charindex.
No I don´t think so, because Charindex returns an INT, so there should
be a problem if the character would be found at the
2,147,483,648 +1. So are you searching on the right table and database
? That should return a hit, if the word india is present in there.
HTH, jens Suessmeyer.|||Hi Everyone,
Solution to my problem lies here.
http://www.aspfaq.com/show.asp?id=2445
Please note that my fear about charindex is correct.
Initially I used CHARINDEX, but that failed if the pattern was deeper than
8,000 characters into the value. PATINDEX never dies. :-)
Thanks
John
"John" <netconsul@.gmail.com> wrote in message
news:eT7LVE66FHA.4076@.TK2MSFTNGP10.phx.gbl...
> Thats what my problem is.
> select news from news where news like '%india%'
> results in 74000+ records while
> select count(*) from news where charindex('india',news)>0
>
> returns none.
> I am using charindex to find the position of India in the record and use
> 'updatetext' to replace it by world.
> because charindex('india',news) returns 0, updatetext cant replace india
> in each record by world.
>
> Any quick help will be appreciated.
>
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1132230042.794270.99970@.g43g2000cwa.googlegroups.com...
> -I think the issue is of max limit of charindex.
> No I don´t think so, because Charindex returns an INT, so there should
> be a problem if the character would be found at the
> 2,147,483,648 +1. So are you searching on the right table and database
> ? That should return a hit, if the word india is present in there.
> HTH, jens Suessmeyer.
>

an interesting problem

I manage a news database oriented website where there is a column named
'news' in a table 'news' storing huge HTML formatted artciles. I had to
replace a particular word 'india' by 'world' in all the records under this
column. Strange thing is the occurances of the word 'india' towards the end
of the articles are getting recognized by
select count(*) from news where charindex('india',news)>0
i.e. the above query results 0. Though there are thousands of records in
the column 'news' containing the word 'india'.
I think the issue is of max limit of charindex.
Please help at the earliest convenience of yours.
Regards,
John
-I think the issue is of max limit of charindex.
No I don=B4t think so, because Charindex returns an INT, so there should
be a problem if the character would be found at the
2,147,483,648 +1. So are you searching on the right table and database
? That should return a hit, if the word india is present in there.
HTH, jens Suessmeyer.
|||John
Did you try LIKE operator?
"John" <netconsul@.gmail.com> wrote in message
news:ePx4t626FHA.1140@.tk2msftngp13.phx.gbl...
>I manage a news database oriented website where there is a column named
>'news' in a table 'news' storing huge HTML formatted artciles. I had to
>replace a particular word 'india' by 'world' in all the records under this
>column. Strange thing is the occurances of the word 'india' towards the end
>of the articles are getting recognized by
> select count(*) from news where charindex('india',news)>0
>
> i.e. the above query results 0. Though there are thousands of records in
> the column 'news' containing the word 'india'.
> I think the issue is of max limit of charindex.
> Please help at the earliest convenience of yours.
> Regards,
> John
>
>
>
|||Thats what my problem is.
select news from news where news like '%india%'
results in 74000+ records while
select count(*) from news where charindex('india',news)>0
returns none.
I am using charindex to find the position of India in the record and use
'updatetext' to replace it by world.
because charindex('india',news) returns 0, updatetext cant replace india in
each record by world.
Any quick help will be appreciated.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1132230042.794270.99970@.g43g2000cwa.googlegro ups.com...
-I think the issue is of max limit of charindex.
No I dont think so, because Charindex returns an INT, so there should
be a problem if the character would be found at the
2,147,483,648 +1. So are you searching on the right table and database
? That should return a hit, if the word india is present in there.
HTH, jens Suessmeyer.
|||Hi Everyone,
Solution to my problem lies here.
http://www.aspfaq.com/show.asp?id=2445
Please note that my fear about charindex is correct.
Initially I used CHARINDEX, but that failed if the pattern was deeper than
8,000 characters into the value. PATINDEX never dies. :-)
Thanks
John
"John" <netconsul@.gmail.com> wrote in message
news:eT7LVE66FHA.4076@.TK2MSFTNGP10.phx.gbl...
> Thats what my problem is.
> select news from news where news like '%india%'
> results in 74000+ records while
> select count(*) from news where charindex('india',news)>0
>
> returns none.
> I am using charindex to find the position of India in the record and use
> 'updatetext' to replace it by world.
> because charindex('india',news) returns 0, updatetext cant replace india
> in each record by world.
>
> Any quick help will be appreciated.
>
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1132230042.794270.99970@.g43g2000cwa.googlegro ups.com...
> -I think the issue is of max limit of charindex.
> No I dont think so, because Charindex returns an INT, so there should
> be a problem if the character would be found at the
> 2,147,483,648 +1. So are you searching on the right table and database
> ? That should return a hit, if the word india is present in there.
> HTH, jens Suessmeyer.
>

an interesting problem

I manage a news database oriented website where there is a column named
'news' in a table 'news' storing huge HTML formatted artciles. I had to
replace a particular word 'india' by 'world' in all the records under this
column. Strange thing is the occurances of the word 'india' towards the end
of the articles are getting recognized by
select count(*) from news where charindex('india',news)>0
i.e. the above query results 0. Though there are thousands of records in
the column 'news' containing the word 'india'.
I think the issue is of max limit of charindex.
Please help at the earliest convenience of yours.
Regards,
John-I think the issue is of max limit of charindex.
No I don=B4t think so, because Charindex returns an INT, so there should
be a problem if the character would be found at the
2,147,483,648 +1. So are you searching on the right table and database
? That should return a hit, if the word india is present in there.
HTH, jens Suessmeyer.|||John
Did you try LIKE operator?
"John" <netconsul@.gmail.com> wrote in message
news:ePx4t626FHA.1140@.tk2msftngp13.phx.gbl...
>I manage a news database oriented website where there is a column named
>'news' in a table 'news' storing huge HTML formatted artciles. I had to
>replace a particular word 'india' by 'world' in all the records under this
>column. Strange thing is the occurances of the word 'india' towards the end
>of the articles are getting recognized by
> select count(*) from news where charindex('india',news)>0
>
> i.e. the above query results 0. Though there are thousands of records in
> the column 'news' containing the word 'india'.
> I think the issue is of max limit of charindex.
> Please help at the earliest convenience of yours.
> Regards,
> John
>
>
>|||Thats what my problem is.
select news from news where news like '%india%'
results in 74000+ records while
select count(*) from news where charindex('india',news)>0
returns none.
I am using charindex to find the position of India in the record and use
'updatetext' to replace it by world.
because charindex('india',news) returns 0, updatetext cant replace india in
each record by world.
Any quick help will be appreciated.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1132230042.794270.99970@.g43g2000cwa.googlegroups.com...
-I think the issue is of max limit of charindex.
No I dont think so, because Charindex returns an INT, so there should
be a problem if the character would be found at the
2,147,483,648 +1. So are you searching on the right table and database
? That should return a hit, if the word india is present in there.
HTH, jens Suessmeyer.|||Hi Everyone,
Solution to my problem lies here.
http://www.aspfaq.com/show.asp?id=2445
Please note that my fear about charindex is correct.
Initially I used CHARINDEX, but that failed if the pattern was deeper than
8,000 characters into the value. PATINDEX never dies. :-)
Thanks
John
"John" <netconsul@.gmail.com> wrote in message
news:eT7LVE66FHA.4076@.TK2MSFTNGP10.phx.gbl...
> Thats what my problem is.
> select news from news where news like '%india%'
> results in 74000+ records while
> select count(*) from news where charindex('india',news)>0
>
> returns none.
> I am using charindex to find the position of India in the record and use
> 'updatetext' to replace it by world.
> because charindex('india',news) returns 0, updatetext cant replace india
> in each record by world.
>
> Any quick help will be appreciated.
>
>
> "Jens" <Jens@.sqlserver2005.de> wrote in message
> news:1132230042.794270.99970@.g43g2000cwa.googlegroups.com...
> -I think the issue is of max limit of charindex.
> No I dont think so, because Charindex returns an INT, so there should
> be a problem if the character would be found at the
> 2,147,483,648 +1. So are you searching on the right table and database
> ? That should return a hit, if the word india is present in there.
> HTH, jens Suessmeyer.
>

An Error Occured During Printing (0X80070003)

we r using the report viewer control of the reporting service 2000 , and it works fine

but when there is a huge report (around 1000 page) it gives the above error "An Error Occured During Printing (0X80070003)" after spoling of around half of the report around 500 page, and stops spoling the rest of the report

is it a problem with the reporting service or the server hardware ?

The problem is that your report is too large for the amount of RAM you have available on the server. Take a look at breaking the report down into a series of smaller reports. Here is a KB article that discusses the problem: http://support.microsoft.com/kb/909678

Larry

am I using SHRINKFILE correctly?

I created some huge tables over the weekend for testing and I have since
dropped them since I don't need them however my database is still over 3
gig. (pre testing size was a few hundred meg)
I'm doing
DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
DBCC SHRINKFILE(mydatabase_v1_Log,1)
and it seems to be working but the file size of the mdf file remains over 3
gig.
What am I missing here ?
Thanks alot.
Hi
It seems that there is still data in one of the later extents and
TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
specifying a target size instead.
John
"D" wrote:

> I created some huge tables over the weekend for testing and I have since
> dropped them since I don't need them however my database is still over 3
> gig. (pre testing size was a few hundred meg)
> I'm doing
> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
> DBCC SHRINKFILE(mydatabase_v1_Log,1)
> and it seems to be working but the file size of the mdf file remains over 3
> gig.
> What am I missing here ?
> Thanks alot.
>
>
|||That did it. Cool ! Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:085AADB1-D52A-488D-BE04-E5976C34D4DA@.microsoft.com...[vbcol=seagreen]
> Hi
> It seems that there is still data in one of the later extents and
> TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
> specifying a target size instead.
> John
> "D" wrote:

am I using SHRINKFILE correctly?

I created some huge tables over the weekend for testing and I have since
dropped them since I don't need them however my database is still over 3
gig. (pre testing size was a few hundred meg)
I'm doing
DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
DBCC SHRINKFILE(mydatabase_v1_Log,1)
and it seems to be working but the file size of the mdf file remains over 3
gig.
What am I missing here ?
Thanks alot.Hi
It seems that there is still data in one of the later extents and
TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
specifying a target size instead.
John
"D" wrote:

> I created some huge tables over the weekend for testing and I have since
> dropped them since I don't need them however my database is still over 3
> gig. (pre testing size was a few hundred meg)
> I'm doing
> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
> DBCC SHRINKFILE(mydatabase_v1_Log,1)
> and it seems to be working but the file size of the mdf file remains over
3
> gig.
> What am I missing here ?
> Thanks alot.
>
>|||That did it. Cool ! Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:085AADB1-D52A-488D-BE04-E5976C34D4DA@.microsoft.com...[vbcol=seagreen]
> Hi
> It seems that there is still data in one of the later extents and
> TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
> specifying a target size instead.
> John
> "D" wrote:
>

am I using SHRINKFILE correctly?

I created some huge tables over the weekend for testing and I have since
dropped them since I don't need them however my database is still over 3
gig. (pre testing size was a few hundred meg)
I'm doing
DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
DBCC SHRINKFILE(mydatabase_v1_Log,1)
and it seems to be working but the file size of the mdf file remains over 3
gig.
What am I missing here ?
Thanks alot.Hi
It seems that there is still data in one of the later extents and
TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
specifying a target size instead.
John
"D" wrote:
> I created some huge tables over the weekend for testing and I have since
> dropped them since I don't need them however my database is still over 3
> gig. (pre testing size was a few hundred meg)
> I'm doing
> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
> DBCC SHRINKFILE(mydatabase_v1_Log,1)
> and it seems to be working but the file size of the mdf file remains over 3
> gig.
> What am I missing here ?
> Thanks alot.
>
>|||That did it. Cool ! Thanks
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:085AADB1-D52A-488D-BE04-E5976C34D4DA@.microsoft.com...
> Hi
> It seems that there is still data in one of the later extents and
> TRUNCATEONLY does not re-allocate this to an earlier free extent. Try
> specifying a target size instead.
> John
> "D" wrote:
>> I created some huge tables over the weekend for testing and I have since
>> dropped them since I don't need them however my database is still over 3
>> gig. (pre testing size was a few hundred meg)
>> I'm doing
>> DBCC SHRINKFILE(mydatabase_Data,TRUNCATEONLY )
>> DBCC SHRINKFILE(mydatabase_v1_Log,1)
>> and it seems to be working but the file size of the mdf file remains over
>> 3
>> gig.
>> What am I missing here ?
>> Thanks alot.
>>
>>