Hi,
I have a report with multiple pages.
I added a page break but then went to the table properties and unchecked the
page break checkbox.
However, when i run the report from my vb.net application I can see a page
break at the end of each page. How can I delete the page breaks?
Thanks.You can get page breaks from groups, lists, etc... Either search through
the RDL or check each one of the items to ensure your not asking for page
breaks somewhere else...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"collie" <collie@.discussions.microsoft.com> wrote in message
news:ABEEBB6A-A408-48C0-A528-F881D5815A65@.microsoft.com...
> Hi,
> I have a report with multiple pages.
> I added a page break but then went to the table properties and unchecked
the
> page break checkbox.
> However, when i run the report from my vb.net application I can see a page
> break at the end of each page. How can I delete the page breaks?
> Thanks.
Showing posts with label pages. Show all posts
Showing posts with label pages. Show all posts
Friday, March 30, 2012
Page Borders
We're creating a text report (i.e. not tabular, etc.) that will run several
pages. We would like to have a border around each page, including the page
header and page footer. We've set a body border, but that doesn't draw
horizontal lines at the top an bottom of each page.
We've tried putting our controls in a rectange and expanding the rectange to
be encompass a page both vertically and horizontally, but the page header is
excluded from this border (plus we suspect we'll have additional problems if
our individual controls causes a page break). Also, though we have the
rectange control's height set to 9 inches, it shrinks such that it ends
after the last control in the region.
Any suggestions for defining a border on each page, the first page excluded
(it's a cover page)?
We're using MS Reporting Services 2005.
Thanks,
ChrisNot sure if this does exactly what you're looking for, but in addition
to the body border, have you tried putting horizontal lines in the page
header & page footer?
Eva Pierce Monsen|||Thanks for Eva's informative inputs,
Hi Chris.
As Eva has mentioned, you can explicitly customize the SSRS report's header
and footer sections in the VS 2005's report designer. Just right click on
the report designer's empty area and you'll find the "Page Header" and
"Page Footer" option in the context menu, select either one to edit the
template.
#Adding a Page Header and Footer to a Report
http://msdn2.microsoft.com/en-us/library/ms159677.aspx
BTW, as for the body's border setting, based on my local test, it also
works (display both horizental and vertical lines). I simply set the border
width and border style (solid) and the runtime report displays both
horizental and vertical border lines for the report body. I think the
problem you met is possibly specific to report body's size.
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community 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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Steven,
The horizonal body borders appear when we first render the report. However,
when we export the report to PDF, the horizontal lines at the top & bottom
of the body do not appear. Also, the border does not encompass the header
and footer, so even if the horizontal lines did appear, it isn't quite what
we're looking for. The prototype I'm working off of is a MS Word document
that has a page border that does encompass the header & footer.
Any other suggestions?
Thanks,
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:NasHAxdjGHA.4528@.TK2MSFTNGXA01.phx.gbl...
> Thanks for Eva's informative inputs,
> Hi Chris.
> As Eva has mentioned, you can explicitly customize the SSRS report's
> header
> and footer sections in the VS 2005's report designer. Just right click on
> the report designer's empty area and you'll find the "Page Header" and
> "Page Footer" option in the context menu, select either one to edit the
> template.
> #Adding a Page Header and Footer to a Report
> http://msdn2.microsoft.com/en-us/library/ms159677.aspx
> BTW, as for the body's border setting, based on my local test, it also
> works (display both horizental and vertical lines). I simply set the
> border
> width and border style (solid) and the runtime report displays both
> horizental and vertical border lines for the report body. I think the
> problem you met is possibly specific to report body's size.
> Hope this helps.
> Regards,
> Steven Cheng
> Microsoft Online Community 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.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hi Chris,
Thanks for your response.
Yes, the body border solution has its natural limitation since it does not
include the Header and Footer sections. Have you tried Eva's suggestion on
customizing the UI through the Header and Footer template in the report
designer? As I've also mentioned in the previous message, you can right
click on the report designer's empty area and you'll find the "Page Header"
and "Page Footer" option in the context menu, select either one to edit the
template. Thus, you can put some report item(such as Line ) into the header
or footer section to simulate a border line. How do you think of this?
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hey Chris,
How are you doing on this issue, does the further suggestion help you some?
If there is still anything we can help, please feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
pages. We would like to have a border around each page, including the page
header and page footer. We've set a body border, but that doesn't draw
horizontal lines at the top an bottom of each page.
We've tried putting our controls in a rectange and expanding the rectange to
be encompass a page both vertically and horizontally, but the page header is
excluded from this border (plus we suspect we'll have additional problems if
our individual controls causes a page break). Also, though we have the
rectange control's height set to 9 inches, it shrinks such that it ends
after the last control in the region.
Any suggestions for defining a border on each page, the first page excluded
(it's a cover page)?
We're using MS Reporting Services 2005.
Thanks,
ChrisNot sure if this does exactly what you're looking for, but in addition
to the body border, have you tried putting horizontal lines in the page
header & page footer?
Eva Pierce Monsen|||Thanks for Eva's informative inputs,
Hi Chris.
As Eva has mentioned, you can explicitly customize the SSRS report's header
and footer sections in the VS 2005's report designer. Just right click on
the report designer's empty area and you'll find the "Page Header" and
"Page Footer" option in the context menu, select either one to edit the
template.
#Adding a Page Header and Footer to a Report
http://msdn2.microsoft.com/en-us/library/ms159677.aspx
BTW, as for the body's border setting, based on my local test, it also
works (display both horizental and vertical lines). I simply set the border
width and border style (solid) and the runtime report displays both
horizental and vertical border lines for the report body. I think the
problem you met is possibly specific to report body's size.
Hope this helps.
Regards,
Steven Cheng
Microsoft Online Community 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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Steven,
The horizonal body borders appear when we first render the report. However,
when we export the report to PDF, the horizontal lines at the top & bottom
of the body do not appear. Also, the border does not encompass the header
and footer, so even if the horizontal lines did appear, it isn't quite what
we're looking for. The prototype I'm working off of is a MS Word document
that has a page border that does encompass the header & footer.
Any other suggestions?
Thanks,
Chris
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:NasHAxdjGHA.4528@.TK2MSFTNGXA01.phx.gbl...
> Thanks for Eva's informative inputs,
> Hi Chris.
> As Eva has mentioned, you can explicitly customize the SSRS report's
> header
> and footer sections in the VS 2005's report designer. Just right click on
> the report designer's empty area and you'll find the "Page Header" and
> "Page Footer" option in the context menu, select either one to edit the
> template.
> #Adding a Page Header and Footer to a Report
> http://msdn2.microsoft.com/en-us/library/ms159677.aspx
> BTW, as for the body's border setting, based on my local test, it also
> works (display both horizental and vertical lines). I simply set the
> border
> width and border style (solid) and the runtime report displays both
> horizental and vertical border lines for the report body. I think the
> problem you met is possibly specific to report body's size.
> Hope this helps.
> Regards,
> Steven Cheng
> Microsoft Online Community 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.
>
> Get Secure! www.microsoft.com/security
> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hi Chris,
Thanks for your response.
Yes, the body border solution has its natural limitation since it does not
include the Header and Footer sections. Have you tried Eva's suggestion on
customizing the UI through the Header and Footer template in the report
designer? As I've also mentioned in the previous message, you can right
click on the report designer's empty area and you'll find the "Page Header"
and "Page Footer" option in the context menu, select either one to edit the
template. Thus, you can put some report item(such as Line ) into the header
or footer section to simulate a border line. How do you think of this?
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hey Chris,
How are you doing on this issue, does the further suggestion help you some?
If there is still anything we can help, please feel free to post here.
Regards,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
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.
Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Page allocationError
Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Run SP_SPACEUSED & SP_HELPDB for information on this database.|||Run SP_SPACEUSED & SP_HELPDB for information on this database.
what exactly should i be looking for?
It shows 4081.94 MB space used. And unallocated space is shown negative i.e. -9.74 MB.|||CHeck what is the space left on PRIMARY FILEGROUP.
Run SP_HELPFILE and use DBCC UPDATEUSAGE before running.|||Hi satya,
thanks for the reply.
after running dbcc updateusage, it updated the usage.
after running sp_helpfile it shows for primary filegroup size=4116480 KB
Max=5121024 KB
Growth=10%
when i try to increase the size of the primary datafile it again gives the same error.
thanks
harshal.|||Have you disabled auto grow on the primary filegroup?
Ensure there are no disk space issues where Primary filegroup is hosted.|||Have you disabled auto grow on the primary filegroup?
Ensure there are no disk space issues where Primary filegroup is hosted.
That is the whole problem auto grow is enabled and there is ample space on the drive where primary filegroup is hosted, still it is not allocating the space.|||See what happens when you manually expand the file by say 100 MB. You may be running into a timing conflict of some kind, with the growth set to 10%. At this point, the file will try to grow by almost half a gig. This will take some time. I would consider setting the filegrowth to a flat value. Probably 10 - 50 MB, depending on the growth rate of the database.|||See what happens when you manually expand the file by say 100 MB. You may be running into a timing conflict of some kind, with the growth set to 10%. At this point, the file will try to grow by almost half a gig. This will take some time. I would consider setting the filegrowth to a flat value. Probably 10 - 50 MB, depending on the growth rate of the database.
Ok I tried increasing the size of the database in units of 50 MB, it worked fine the first time when the size was 4095MB but after that if i try to increase it more even by 1 MB it gives me the same error.
What can possibly be the reason? can there be some kind of quota or some thing which may be configured?|||How much available disk space do you have on that drive?|||How much available disk space do you have on that drive?
free space on the drive is 9.04 GB.|||Hmm. Maybe there is an O/S limit on files? Never heard of such a thing, though. But, just to test out if it is the O/S playing with your head, try backing up the database a couple times to the same file. You should be able to create a file greater than 4GB in size. What O/S is this? 2K or 2K3?|||ok i'll try that.
its 2k server|||ok i'll try that.
But only on MONDAY :D
Time to call it a week !!! :rolleyes:|||Hmm. Maybe there is an O/S limit on files? Never heard of such a thing, though. But, just to test out if it is the O/S playing with your head, try backing up the database a couple times to the same file. You should be able to create a file greater than 4GB in size. What O/S is this? 2K or 2K3?Don't even go there! The SQL Server limits (http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp) aren't an issue here!
-PatP|||Don't even go there! The SQL Server limits (http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp) aren't an issue here!
-PatP
yeah thats right but then what is causing this?|||ok here is the error again:
"Error 5149: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."
it says that it is operating system error.
As if the os is not able to "SEE" the existing empty space.|||Harshal ... Yes ... Now that Mcrowley mentions it .. i remember reading about it somewhere...
I will bet a bottle of whiskey on your file system being FAT32. FAT32 file systems have a 4 GB file size limit ... you will need to convert your file system to NTFS in case you want a db file bigger than 4 GB.
Do tell if I am right ...|||http://support.microsoft.com/default.aspx?scid=kb;en-us;314463
Enigma: Looks like you are on to something there.|||http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/windows/xp/all/reskit/en-us/prkc_fil_tdrn.asp
take a look at this too|||http://sqljunkies.com/WebLog/enigma/archive/2004/05/14/2483.aspx|||Harshal ... Yes ... Now that Mcrowley mentions it .. i remember reading about it somewhere...
I will bet a bottle of whiskey on your file system being FAT32. FAT32 file systems have a 4 GB file size limit ... you will need to convert your file system to NTFS in case you want a db file bigger than 4 GB.
Do tell if I am right ...
Hey Enigma I owe you a Grand Single Malt on this.
Just now converted the file system to NTFS it was indeed fat32 and Bingooo !!|||Was this your prod system ?|||Was this your prod system ?
No Way!!
It is my personal workstation.|||Great zot man!
I'm certainly glad that you found your solution. I'm also deathly curious as to why on earth you'd run FAT32 on an NT workstation ?!?! We used to run FAT32 and/or unformatted volumes in the days of Win-NT 3.51, but the thought that you might be running FAT today never entered my mind!
-PatP|||Great zot man!
I'm certainly glad that you found your solution. I'm also deathly curious as to why on earth you'd run FAT32 on an NT workstation ?!?! We used to run FAT32 and/or unformatted volumes in the days of Win-NT 3.51, but the thought that you might be running FAT today never entered my mind!
-PatP
:D :D ;)
Actually a couple of weeks back my secondary hard disk had crashed and so the network admin gave me a spare disk, said that this is a temperory arrangement he would be giving me a new disk soon, but i never got that disk and i continued with what i had and never checked what the file system was.
:(
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages available in filegroup PRIMARY. Space can be created by dropping objects, adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Run SP_SPACEUSED & SP_HELPDB for information on this database.|||Run SP_SPACEUSED & SP_HELPDB for information on this database.
what exactly should i be looking for?
It shows 4081.94 MB space used. And unallocated space is shown negative i.e. -9.74 MB.|||CHeck what is the space left on PRIMARY FILEGROUP.
Run SP_HELPFILE and use DBCC UPDATEUSAGE before running.|||Hi satya,
thanks for the reply.
after running dbcc updateusage, it updated the usage.
after running sp_helpfile it shows for primary filegroup size=4116480 KB
Max=5121024 KB
Growth=10%
when i try to increase the size of the primary datafile it again gives the same error.
thanks
harshal.|||Have you disabled auto grow on the primary filegroup?
Ensure there are no disk space issues where Primary filegroup is hosted.|||Have you disabled auto grow on the primary filegroup?
Ensure there are no disk space issues where Primary filegroup is hosted.
That is the whole problem auto grow is enabled and there is ample space on the drive where primary filegroup is hosted, still it is not allocating the space.|||See what happens when you manually expand the file by say 100 MB. You may be running into a timing conflict of some kind, with the growth set to 10%. At this point, the file will try to grow by almost half a gig. This will take some time. I would consider setting the filegrowth to a flat value. Probably 10 - 50 MB, depending on the growth rate of the database.|||See what happens when you manually expand the file by say 100 MB. You may be running into a timing conflict of some kind, with the growth set to 10%. At this point, the file will try to grow by almost half a gig. This will take some time. I would consider setting the filegrowth to a flat value. Probably 10 - 50 MB, depending on the growth rate of the database.
Ok I tried increasing the size of the database in units of 50 MB, it worked fine the first time when the size was 4095MB but after that if i try to increase it more even by 1 MB it gives me the same error.
What can possibly be the reason? can there be some kind of quota or some thing which may be configured?|||How much available disk space do you have on that drive?|||How much available disk space do you have on that drive?
free space on the drive is 9.04 GB.|||Hmm. Maybe there is an O/S limit on files? Never heard of such a thing, though. But, just to test out if it is the O/S playing with your head, try backing up the database a couple times to the same file. You should be able to create a file greater than 4GB in size. What O/S is this? 2K or 2K3?|||ok i'll try that.
its 2k server|||ok i'll try that.
But only on MONDAY :D
Time to call it a week !!! :rolleyes:|||Hmm. Maybe there is an O/S limit on files? Never heard of such a thing, though. But, just to test out if it is the O/S playing with your head, try backing up the database a couple times to the same file. You should be able to create a file greater than 4GB in size. What O/S is this? 2K or 2K3?Don't even go there! The SQL Server limits (http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp) aren't an issue here!
-PatP|||Don't even go there! The SQL Server limits (http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp) aren't an issue here!
-PatP
yeah thats right but then what is causing this?|||ok here is the error again:
"Error 5149: MODIFY FILE encountered operating system error 112(There is not enough space on the disk.) while attempting to expand the physical file."
it says that it is operating system error.
As if the os is not able to "SEE" the existing empty space.|||Harshal ... Yes ... Now that Mcrowley mentions it .. i remember reading about it somewhere...
I will bet a bottle of whiskey on your file system being FAT32. FAT32 file systems have a 4 GB file size limit ... you will need to convert your file system to NTFS in case you want a db file bigger than 4 GB.
Do tell if I am right ...|||http://support.microsoft.com/default.aspx?scid=kb;en-us;314463
Enigma: Looks like you are on to something there.|||http://www.microsoft.com/resources/documentation/Windows/XP/all/reskit/en-us/Default.asp?url=/resources/documentation/windows/xp/all/reskit/en-us/prkc_fil_tdrn.asp
take a look at this too|||http://sqljunkies.com/WebLog/enigma/archive/2004/05/14/2483.aspx|||Harshal ... Yes ... Now that Mcrowley mentions it .. i remember reading about it somewhere...
I will bet a bottle of whiskey on your file system being FAT32. FAT32 file systems have a 4 GB file size limit ... you will need to convert your file system to NTFS in case you want a db file bigger than 4 GB.
Do tell if I am right ...
Hey Enigma I owe you a Grand Single Malt on this.
Just now converted the file system to NTFS it was indeed fat32 and Bingooo !!|||Was this your prod system ?|||Was this your prod system ?
No Way!!
It is my personal workstation.|||Great zot man!
I'm certainly glad that you found your solution. I'm also deathly curious as to why on earth you'd run FAT32 on an NT workstation ?!?! We used to run FAT32 and/or unformatted volumes in the days of Win-NT 3.51, but the thought that you might be running FAT today never entered my mind!
-PatP|||Great zot man!
I'm certainly glad that you found your solution. I'm also deathly curious as to why on earth you'd run FAT32 on an NT workstation ?!?! We used to run FAT32 and/or unformatted volumes in the days of Win-NT 3.51, but the thought that you might be running FAT today never entered my mind!
-PatP
:D :D ;)
Actually a couple of weeks back my secondary hard disk had crashed and so the network admin gave me a spare disk, said that this is a temperory arrangement he would be giving me a new disk soon, but i never got that disk and i continued with what i had and never checked what the file system was.
:(
Page allocation error
Hi all,
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages
available in filegroup PRIMARY. Space can be created by dropping objects,
adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile
is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Sometimes autogrow doesn't catch up with the space requirements, resulting in this error message. I suggest
you pre-allocate storage.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> Hi all,
> There a quite strange error i am getting :
> "Could not allocate new page for database 'rough'. There are no more pages
> available in filegroup PRIMARY. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> This database has unrestricted filegrowth, the current size of the datafile
> is 4.6GB and there is 9 GB space free on the hard disk.
> The recovery model is full logged.
> sql server 2k with sp3a.
> any thoughts?
> harshal.
>|||yeah for the same reason i tried to increase the size of the file from the
enterprise manager it still gave me the same error.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Sometimes autogrow doesn't catch up with the space requirements, resulting
in this error message. I suggest
> you pre-allocate storage.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > Hi all,
> > There a quite strange error i am getting :
> > "Could not allocate new page for database 'rough'. There are no more
pages
> > available in filegroup PRIMARY. Space can be created by dropping
objects,
> > adding additional files, or allowing file growth."
> >
> > This database has unrestricted filegrowth, the current size of the
datafile
> > is 4.6GB and there is 9 GB space free on the hard disk.
> >
> > The recovery model is full logged.
> > sql server 2k with sp3a.
> >
> > any thoughts?
> >
> > harshal.
> >
> >
>|||Seems to be a problem at the OS level, if SQL Server cannot allocate space even though space exists on the
hard drive. A couple of things to check is if you have disk quotas or compression.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> yeah for the same reason i tried to increase the size of the file from the
> enterprise manager it still gave me the same error.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > Sometimes autogrow doesn't catch up with the space requirements, resulting
> in this error message. I suggest
> > you pre-allocate storage.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > Hi all,
> > > There a quite strange error i am getting :
> > > "Could not allocate new page for database 'rough'. There are no more
> pages
> > > available in filegroup PRIMARY. Space can be created by dropping
> objects,
> > > adding additional files, or allowing file growth."
> > >
> > > This database has unrestricted filegrowth, the current size of the
> datafile
> > > is 4.6GB and there is 9 GB space free on the hard disk.
> > >
> > > The recovery model is full logged.
> > > sql server 2k with sp3a.
> > >
> > > any thoughts?
> > >
> > > harshal.
> > >
> > >
> >
> >
>|||no there is no compression done on the disk and the funny thing is that if i
delete some thing on the disk then it allows me to allocate the space for
that database, but even if i dont delete anything and try to increase the
space on other database there is no problem.
what else do i be looking for?
Thanks and Regards,
Harshal.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujLfGjOOEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Seems to be a problem at the OS level, if SQL Server cannot allocate space
even though space exists on the
> hard drive. A couple of things to check is if you have disk quotas or
compression.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> > yeah for the same reason i tried to increase the size of the file from
the
> > enterprise manager it still gave me the same error.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > > Sometimes autogrow doesn't catch up with the space requirements,
resulting
> > in this error message. I suggest
> > > you pre-allocate storage.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> > news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > > Hi all,
> > > > There a quite strange error i am getting :
> > > > "Could not allocate new page for database 'rough'. There are no more
> > pages
> > > > available in filegroup PRIMARY. Space can be created by dropping
> > objects,
> > > > adding additional files, or allowing file growth."
> > > >
> > > > This database has unrestricted filegrowth, the current size of the
> > datafile
> > > > is 4.6GB and there is 9 GB space free on the hard disk.
> > > >
> > > > The recovery model is full logged.
> > > > sql server 2k with sp3a.
> > > >
> > > > any thoughts?
> > > >
> > > > harshal.
> > > >
> > > >
> > >
> > >
> >
> >
>
There a quite strange error i am getting :
"Could not allocate new page for database 'rough'. There are no more pages
available in filegroup PRIMARY. Space can be created by dropping objects,
adding additional files, or allowing file growth."
This database has unrestricted filegrowth, the current size of the datafile
is 4.6GB and there is 9 GB space free on the hard disk.
The recovery model is full logged.
sql server 2k with sp3a.
any thoughts?
harshal.Sometimes autogrow doesn't catch up with the space requirements, resulting in this error message. I suggest
you pre-allocate storage.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> Hi all,
> There a quite strange error i am getting :
> "Could not allocate new page for database 'rough'. There are no more pages
> available in filegroup PRIMARY. Space can be created by dropping objects,
> adding additional files, or allowing file growth."
> This database has unrestricted filegrowth, the current size of the datafile
> is 4.6GB and there is 9 GB space free on the hard disk.
> The recovery model is full logged.
> sql server 2k with sp3a.
> any thoughts?
> harshal.
>|||yeah for the same reason i tried to increase the size of the file from the
enterprise manager it still gave me the same error.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> Sometimes autogrow doesn't catch up with the space requirements, resulting
in this error message. I suggest
> you pre-allocate storage.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > Hi all,
> > There a quite strange error i am getting :
> > "Could not allocate new page for database 'rough'. There are no more
pages
> > available in filegroup PRIMARY. Space can be created by dropping
objects,
> > adding additional files, or allowing file growth."
> >
> > This database has unrestricted filegrowth, the current size of the
datafile
> > is 4.6GB and there is 9 GB space free on the hard disk.
> >
> > The recovery model is full logged.
> > sql server 2k with sp3a.
> >
> > any thoughts?
> >
> > harshal.
> >
> >
>|||Seems to be a problem at the OS level, if SQL Server cannot allocate space even though space exists on the
hard drive. A couple of things to check is if you have disk quotas or compression.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"harshal mistry" <harshal_in@.hotmail.com> wrote in message news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> yeah for the same reason i tried to increase the size of the file from the
> enterprise manager it still gave me the same error.
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
> message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > Sometimes autogrow doesn't catch up with the space requirements, resulting
> in this error message. I suggest
> > you pre-allocate storage.
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> >
> >
> > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > Hi all,
> > > There a quite strange error i am getting :
> > > "Could not allocate new page for database 'rough'. There are no more
> pages
> > > available in filegroup PRIMARY. Space can be created by dropping
> objects,
> > > adding additional files, or allowing file growth."
> > >
> > > This database has unrestricted filegrowth, the current size of the
> datafile
> > > is 4.6GB and there is 9 GB space free on the hard disk.
> > >
> > > The recovery model is full logged.
> > > sql server 2k with sp3a.
> > >
> > > any thoughts?
> > >
> > > harshal.
> > >
> > >
> >
> >
>|||no there is no compression done on the disk and the funny thing is that if i
delete some thing on the disk then it allows me to allocate the space for
that database, but even if i dont delete anything and try to increase the
space on other database there is no problem.
what else do i be looking for?
Thanks and Regards,
Harshal.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujLfGjOOEHA.3752@.TK2MSFTNGP12.phx.gbl...
> Seems to be a problem at the OS level, if SQL Server cannot allocate space
even though space exists on the
> hard drive. A couple of things to check is if you have disk quotas or
compression.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
> "harshal mistry" <harshal_in@.hotmail.com> wrote in message
news:eXi1eLOOEHA.3016@.tk2msftngp13.phx.gbl...
> > yeah for the same reason i tried to increase the size of the file from
the
> > enterprise manager it still gave me the same error.
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote
in
> > message news:uGe3zrNOEHA.904@.TK2MSFTNGP12.phx.gbl...
> > > Sometimes autogrow doesn't catch up with the space requirements,
resulting
> > in this error message. I suggest
> > > you pre-allocate storage.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "harshal mistry" <harshal_in@.hotmail.com> wrote in message
> > news:u3yRBFLOEHA.2716@.tk2msftngp13.phx.gbl...
> > > > Hi all,
> > > > There a quite strange error i am getting :
> > > > "Could not allocate new page for database 'rough'. There are no more
> > pages
> > > > available in filegroup PRIMARY. Space can be created by dropping
> > objects,
> > > > adding additional files, or allowing file growth."
> > > >
> > > > This database has unrestricted filegrowth, the current size of the
> > datafile
> > > > is 4.6GB and there is 9 GB space free on the hard disk.
> > > >
> > > > The recovery model is full logged.
> > > > sql server 2k with sp3a.
> > > >
> > > > any thoughts?
> > > >
> > > > harshal.
> > > >
> > > >
> > >
> > >
> >
> >
>
Friday, March 9, 2012
P/T question
I have a perfmon output as:
"(Eastern Standard Time)","Memory\Pages/sec","SQLServer:Memory Manager\Target Server Memory(KB)","SQLServer:Memory Manager\Total Server Memory (KB)"
"11/18/2004 10:30:04.750","692.29290389658956","6686608","6686608"
"11/18/2004 10:30:19.750","57.035332875362883","6686608","6686608"
"11/18/2004 10:30:34.750","50.946407096710089","6686752","6686752"
"11/18/2004 10:30:49.750","45.985057453103487","6686896","6686896"
"11/18/2004 10:31:04.750","80.718985188776941","6686608","6686608"
"11/18/2004 10:31:19.765","51.419713435012362","6686688","6686688"
"11/18/2004 10:31:34.765","83.316956075479524","6686784","6686784"
"11/18/2004 10:31:49.765","86.4656131714503","6686784","6686784"
"11/18/2004 10:32:04.765","184.19541457981779","6687008","6687008"
"11/18/2004 10:32:19.765","1594.8601288134912","6686784","6686784"
"11/18/2004 10:32:34.765","66.843390396403805","6686784","6686784"
"11/18/2004 10:32:49.765","66.840494677987792","6686928","6686928"
"11/18/2004 10:33:04.765","118.8274008488409","6686896","6686896"
"11/18/2004 10:33:19.765","317.40745114920139","6686896","6686896"
"11/18/2004 10:33:34.765","102.44640018841849","6686896","6686896"
"11/18/2004 10:33:49.765","144.69523847001818","6686896","6686896"
"11/18/2004 10:34:04.765","85.31078069975311","6686896","6686896"
"11/18/2004 10:34:19.765","201.69105891920668","6687040","6687040"
"11/18/2004 10:34:34.765","160.50180640532426","6687040","6687040"
"11/18/2004 10:34:49.765","82.745816941897289","6687040","6687040"
"11/18/2004 10:35:04.765","77.598868378704793","6687040","6687040"
"11/18/2004 10:35:19.765","144.36181802848549","6687040","6687040"
"11/18/2004 10:35:34.765","115.436326945804","6687200","6687200"
"11/18/2004 10:35:49.765","220.79121078389826","6687200","6687200"
Does this mean that if I add more memory to the box and allocate it to SQL Server, it will be beneficial?
ThanksThese are very alarming numbers. How much memory DO you have?|||We have 8GB on the box and 6GB (approx.) allocated to SQL Server. This is a very intensive i/o and oltp application.
"(Eastern Standard Time)","Memory\Pages/sec","SQLServer:Memory Manager\Target Server Memory(KB)","SQLServer:Memory Manager\Total Server Memory (KB)"
"11/18/2004 10:30:04.750","692.29290389658956","6686608","6686608"
"11/18/2004 10:30:19.750","57.035332875362883","6686608","6686608"
"11/18/2004 10:30:34.750","50.946407096710089","6686752","6686752"
"11/18/2004 10:30:49.750","45.985057453103487","6686896","6686896"
"11/18/2004 10:31:04.750","80.718985188776941","6686608","6686608"
"11/18/2004 10:31:19.765","51.419713435012362","6686688","6686688"
"11/18/2004 10:31:34.765","83.316956075479524","6686784","6686784"
"11/18/2004 10:31:49.765","86.4656131714503","6686784","6686784"
"11/18/2004 10:32:04.765","184.19541457981779","6687008","6687008"
"11/18/2004 10:32:19.765","1594.8601288134912","6686784","6686784"
"11/18/2004 10:32:34.765","66.843390396403805","6686784","6686784"
"11/18/2004 10:32:49.765","66.840494677987792","6686928","6686928"
"11/18/2004 10:33:04.765","118.8274008488409","6686896","6686896"
"11/18/2004 10:33:19.765","317.40745114920139","6686896","6686896"
"11/18/2004 10:33:34.765","102.44640018841849","6686896","6686896"
"11/18/2004 10:33:49.765","144.69523847001818","6686896","6686896"
"11/18/2004 10:34:04.765","85.31078069975311","6686896","6686896"
"11/18/2004 10:34:19.765","201.69105891920668","6687040","6687040"
"11/18/2004 10:34:34.765","160.50180640532426","6687040","6687040"
"11/18/2004 10:34:49.765","82.745816941897289","6687040","6687040"
"11/18/2004 10:35:04.765","77.598868378704793","6687040","6687040"
"11/18/2004 10:35:19.765","144.36181802848549","6687040","6687040"
"11/18/2004 10:35:34.765","115.436326945804","6687200","6687200"
"11/18/2004 10:35:49.765","220.79121078389826","6687200","6687200"
Does this mean that if I add more memory to the box and allocate it to SQL Server, it will be beneficial?
ThanksThese are very alarming numbers. How much memory DO you have?|||We have 8GB on the box and 6GB (approx.) allocated to SQL Server. This is a very intensive i/o and oltp application.
Saturday, February 25, 2012
Override a foreign key constraint
A website that I'm working on has users sign in and keeps a log of the pages they go to. The log table has a foreign key in it that links to the username is the users table. I need to update the username for one of the users but the foreign key is preventing me from doing so. What is the benefit of having a foreign key like this? Can I delete it to update the username or is there a better way?
Foreign Key constraints ensure the integrity of the data is maintained. If there was no FK in place. then it would be easy to get orphaned and inconsistent data. In your example, if you just update a username to be Bob from Terry then all the records associated with Terry in the log table will now have no link back to the users record ie the Terry records will be orphaned.
Soooooo, in answer to your question, you can drop it make your update but it will throw an error when you try and recreate the FK unless you update the log records too.
You can create these constraints with a cascading updates/deletes which will filter your changes down to the child tables but in this case, it looks like its turned off.
I'd suggest just doing the following
Psuedo code:
UPDATE Log set Username = Bob WHERE username = Terry
UPDATE user set username = Bob WHERE username = Terry.
HTH!
Subscribe to:
Posts (Atom)