When setting up Queued Updating Replication it seems to get hung up. It gets to adding article 445 of 1083 and just stays there for a very long time.
Is there anything I can do or should I just wait it out?
I checked sp_who, I don't see any blocking. Any ideas?
Thanx!
JLS,
as long as there's no timeout I'd wait a while - 1083 is a huge amount of articles. If there is a timeout, you might want to alter the agent's profile.
Regards,
Paul Ibison
Showing posts with label setting. Show all posts
Showing posts with label setting. Show all posts
Sunday, March 11, 2012
Saturday, February 25, 2012
Annoying issue with PDF rendering
Are there some guidlines on setting the page and body sizes as well as
laying out objects such that PDF doesn't throw blank pages between or pages
or on the first page.
My page is standard A4 which in landscape means it is 29.7cm wide - and this
is what I have set the report width to. I have margins of 1cm on the right
and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
for this, the report body and footer (no header) are 27.5cm wide.
Body contains two tables. One table is stand alone the other Table is
imbedded in a List grouped on user Id - there are no pagebreak checkboxes
checked.
In the footer I have a few textboxes detailing various things such as print
date and time, page number etc. The objects in the Footer and Body are
indented slightly and nothing overlaps.
Why am I getting these blank pages spilled in to Acrobat?
thanks
MattMatt
I would be really interested to know the answer to this as I am
experiencing the exact same problem. Looking back at past responses,
it looks like this is something that cannot be solved until the next
version. To overcome the problem, I am having to export to excel, copy
to word and print to pdf. Please if anyone has a better solution, lets
us know...
Lisa
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message news:<esfCduUaEHA.1644@.tk2msftngp13.phx.gbl>...
> Are there some guidlines on setting the page and body sizes as well as
> laying out objects such that PDF doesn't throw blank pages between or pages
> or on the first page.
> My page is standard A4 which in landscape means it is 29.7cm wide - and this
> is what I have set the report width to. I have margins of 1cm on the right
> and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> for this, the report body and footer (no header) are 27.5cm wide.
> Body contains two tables. One table is stand alone the other Table is
> imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> checked.
> In the footer I have a few textboxes detailing various things such as print
> date and time, page number etc. The objects in the Footer and Body are
> indented slightly and nothing overlaps.
> Why am I getting these blank pages spilled in to Acrobat?
> thanks
> Matt|||I believe I ran into this on a report I had to export to pdf and if I recall
correctly, I was able to resolve it by playing around with the 'Size'
properties of the Body and the 'PageSize' properties of the Report.
You see the Body properties by clicking on an empty area of your report in
Report Designer, the white part with the grid lines or dots on it.
You see the Report properties by clicking on the thin beige area in Report
Designer just to the right or left of the Body of the report I just
described above.
I found that by playing around with these #'s I was able to control the pdf
rendering a bit better. I think one set of #'s had to be bigger than the
other to stop the blank page thing from happening. And please don't ask
which way it goes 'cause I don't remember :-) And I don't have that project
open right now and don't want to wait 10 minutes for it to open. Our
solution is getting rather large and seems to take forever to open.
Hope that helps.
Dale
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:esfCduUaEHA.1644@.tk2msftngp13.phx.gbl...
> Are there some guidlines on setting the page and body sizes as well as
> laying out objects such that PDF doesn't throw blank pages between or
pages
> or on the first page.
> My page is standard A4 which in landscape means it is 29.7cm wide - and
this
> is what I have set the report width to. I have margins of 1cm on the
right
> and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> for this, the report body and footer (no header) are 27.5cm wide.
> Body contains two tables. One table is stand alone the other Table is
> imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> checked.
> In the footer I have a few textboxes detailing various things such as
print
> date and time, page number etc. The objects in the Footer and Body are
> indented slightly and nothing overlaps.
> Why am I getting these blank pages spilled in to Acrobat?
> thanks
> Matt
>|||Hi Lisa,
You may have found as Dale suggests, that by playing with the formatting,
you can get it to export correctly to PDF.
Probably like you Lisa I was after something a bit more concrete to take the
guesswork out of it, but thanks to Dale for responding.
For what it's worth, this is where I'm at.
1) The page width needs to be either 21cm or 29.7cm for portrait and
landscape respectively. I am really only using Landscape, so I'm using
measurements relative to that.
2) The parts of the report, Body, Header and Footer cannot be wider than the
page width less margins. I typically have 1cm margins so my B, H and F need
to be in theory no wider than 27.7 - in practice, I have found that I can't
get over 27cm - although I've done quite a bit of playing, my testing is by
no means exhaustive.
3) Make sure objects don't overlap. In Crystal, you could pop things on top
of each other, in RS this is not the case.
The above ones are pretty obvious so you are probably on top of them
4) This is the grey area. I have two tables. One stand alone, I can set to
the width of the report body. A second table resides in a list. Even
though I'd reduced the width of this table to about 20cm it was still
spilling over to a new page. I found setting Can Grow property to True for
some of the longer fields resolved this. Even so, I cannot get the table
any wider than 25.5cm. The table is sitting within a List, which is 26.5cm
wide an has no padding.
Perhaps we can refine this as we come across more ideas
regards
Matt
"Lisa" <budgenlj@.willis.com> wrote in message
news:9abd1432.0407140649.3a7717f8@.posting.google.com...
> Matt
> I would be really interested to know the answer to this as I am
> experiencing the exact same problem. Looking back at past responses,
> it looks like this is something that cannot be solved until the next
> version. To overcome the problem, I am having to export to excel, copy
> to word and print to pdf. Please if anyone has a better solution, lets
> us know...
> Lisa
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:<esfCduUaEHA.1644@.tk2msftngp13.phx.gbl>...
> > Are there some guidlines on setting the page and body sizes as well as
> > laying out objects such that PDF doesn't throw blank pages between or
pages
> > or on the first page.
> >
> > My page is standard A4 which in landscape means it is 29.7cm wide - and
this
> > is what I have set the report width to. I have margins of 1cm on the
right
> > and 1cm on the left, the top and bottom margins are both 1.5cm.
Allowing
> > for this, the report body and footer (no header) are 27.5cm wide.
> >
> > Body contains two tables. One table is stand alone the other Table is
> > imbedded in a List grouped on user Id - there are no pagebreak
checkboxes
> > checked.
> >
> > In the footer I have a few textboxes detailing various things such as
print
> > date and time, page number etc. The objects in the Footer and Body are
> > indented slightly and nothing overlaps.
> >
> > Why am I getting these blank pages spilled in to Acrobat?
> >
> > thanks
> >
> > Matt|||Dale/Matt
Thank you for your responses. I have managed to get this to work now
and pdf correcly by altering the page widths. Thank you both so much.
Lisa
"Dale" <dale@.NoSpamPlease.ca> wrote in message news:<ewSzN1daEHA.752@.TK2MSFTNGP09.phx.gbl>...
> I believe I ran into this on a report I had to export to pdf and if I recall
> correctly, I was able to resolve it by playing around with the 'Size'
> properties of the Body and the 'PageSize' properties of the Report.
> You see the Body properties by clicking on an empty area of your report in
> Report Designer, the white part with the grid lines or dots on it.
> You see the Report properties by clicking on the thin beige area in Report
> Designer just to the right or left of the Body of the report I just
> described above.
> I found that by playing around with these #'s I was able to control the pdf
> rendering a bit better. I think one set of #'s had to be bigger than the
> other to stop the blank page thing from happening. And please don't ask
> which way it goes 'cause I don't remember :-) And I don't have that project
> open right now and don't want to wait 10 minutes for it to open. Our
> solution is getting rather large and seems to take forever to open.
> Hope that helps.
> Dale
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:esfCduUaEHA.1644@.tk2msftngp13.phx.gbl...
> > Are there some guidlines on setting the page and body sizes as well as
> > laying out objects such that PDF doesn't throw blank pages between or
> pages
> > or on the first page.
> >
> > My page is standard A4 which in landscape means it is 29.7cm wide - and
> this
> > is what I have set the report width to. I have margins of 1cm on the
> right
> > and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> > for this, the report body and footer (no header) are 27.5cm wide.
> >
> > Body contains two tables. One table is stand alone the other Table is
> > imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> > checked.
> >
> > In the footer I have a few textboxes detailing various things such as
> print
> > date and time, page number etc. The objects in the Footer and Body are
> > indented slightly and nothing overlaps.
> >
> > Why am I getting these blank pages spilled in to Acrobat?
> >
> > thanks
> >
> > Matt
> >
> >
laying out objects such that PDF doesn't throw blank pages between or pages
or on the first page.
My page is standard A4 which in landscape means it is 29.7cm wide - and this
is what I have set the report width to. I have margins of 1cm on the right
and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
for this, the report body and footer (no header) are 27.5cm wide.
Body contains two tables. One table is stand alone the other Table is
imbedded in a List grouped on user Id - there are no pagebreak checkboxes
checked.
In the footer I have a few textboxes detailing various things such as print
date and time, page number etc. The objects in the Footer and Body are
indented slightly and nothing overlaps.
Why am I getting these blank pages spilled in to Acrobat?
thanks
MattMatt
I would be really interested to know the answer to this as I am
experiencing the exact same problem. Looking back at past responses,
it looks like this is something that cannot be solved until the next
version. To overcome the problem, I am having to export to excel, copy
to word and print to pdf. Please if anyone has a better solution, lets
us know...
Lisa
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message news:<esfCduUaEHA.1644@.tk2msftngp13.phx.gbl>...
> Are there some guidlines on setting the page and body sizes as well as
> laying out objects such that PDF doesn't throw blank pages between or pages
> or on the first page.
> My page is standard A4 which in landscape means it is 29.7cm wide - and this
> is what I have set the report width to. I have margins of 1cm on the right
> and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> for this, the report body and footer (no header) are 27.5cm wide.
> Body contains two tables. One table is stand alone the other Table is
> imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> checked.
> In the footer I have a few textboxes detailing various things such as print
> date and time, page number etc. The objects in the Footer and Body are
> indented slightly and nothing overlaps.
> Why am I getting these blank pages spilled in to Acrobat?
> thanks
> Matt|||I believe I ran into this on a report I had to export to pdf and if I recall
correctly, I was able to resolve it by playing around with the 'Size'
properties of the Body and the 'PageSize' properties of the Report.
You see the Body properties by clicking on an empty area of your report in
Report Designer, the white part with the grid lines or dots on it.
You see the Report properties by clicking on the thin beige area in Report
Designer just to the right or left of the Body of the report I just
described above.
I found that by playing around with these #'s I was able to control the pdf
rendering a bit better. I think one set of #'s had to be bigger than the
other to stop the blank page thing from happening. And please don't ask
which way it goes 'cause I don't remember :-) And I don't have that project
open right now and don't want to wait 10 minutes for it to open. Our
solution is getting rather large and seems to take forever to open.
Hope that helps.
Dale
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:esfCduUaEHA.1644@.tk2msftngp13.phx.gbl...
> Are there some guidlines on setting the page and body sizes as well as
> laying out objects such that PDF doesn't throw blank pages between or
pages
> or on the first page.
> My page is standard A4 which in landscape means it is 29.7cm wide - and
this
> is what I have set the report width to. I have margins of 1cm on the
right
> and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> for this, the report body and footer (no header) are 27.5cm wide.
> Body contains two tables. One table is stand alone the other Table is
> imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> checked.
> In the footer I have a few textboxes detailing various things such as
> date and time, page number etc. The objects in the Footer and Body are
> indented slightly and nothing overlaps.
> Why am I getting these blank pages spilled in to Acrobat?
> thanks
> Matt
>|||Hi Lisa,
You may have found as Dale suggests, that by playing with the formatting,
you can get it to export correctly to PDF.
Probably like you Lisa I was after something a bit more concrete to take the
guesswork out of it, but thanks to Dale for responding.
For what it's worth, this is where I'm at.
1) The page width needs to be either 21cm or 29.7cm for portrait and
landscape respectively. I am really only using Landscape, so I'm using
measurements relative to that.
2) The parts of the report, Body, Header and Footer cannot be wider than the
page width less margins. I typically have 1cm margins so my B, H and F need
to be in theory no wider than 27.7 - in practice, I have found that I can't
get over 27cm - although I've done quite a bit of playing, my testing is by
no means exhaustive.
3) Make sure objects don't overlap. In Crystal, you could pop things on top
of each other, in RS this is not the case.
The above ones are pretty obvious so you are probably on top of them
4) This is the grey area. I have two tables. One stand alone, I can set to
the width of the report body. A second table resides in a list. Even
though I'd reduced the width of this table to about 20cm it was still
spilling over to a new page. I found setting Can Grow property to True for
some of the longer fields resolved this. Even so, I cannot get the table
any wider than 25.5cm. The table is sitting within a List, which is 26.5cm
wide an has no padding.
Perhaps we can refine this as we come across more ideas
regards
Matt
"Lisa" <budgenlj@.willis.com> wrote in message
news:9abd1432.0407140649.3a7717f8@.posting.google.com...
> Matt
> I would be really interested to know the answer to this as I am
> experiencing the exact same problem. Looking back at past responses,
> it looks like this is something that cannot be solved until the next
> version. To overcome the problem, I am having to export to excel, copy
> to word and print to pdf. Please if anyone has a better solution, lets
> us know...
> Lisa
>
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:<esfCduUaEHA.1644@.tk2msftngp13.phx.gbl>...
> > Are there some guidlines on setting the page and body sizes as well as
> > laying out objects such that PDF doesn't throw blank pages between or
pages
> > or on the first page.
> >
> > My page is standard A4 which in landscape means it is 29.7cm wide - and
this
> > is what I have set the report width to. I have margins of 1cm on the
right
> > and 1cm on the left, the top and bottom margins are both 1.5cm.
Allowing
> > for this, the report body and footer (no header) are 27.5cm wide.
> >
> > Body contains two tables. One table is stand alone the other Table is
> > imbedded in a List grouped on user Id - there are no pagebreak
checkboxes
> > checked.
> >
> > In the footer I have a few textboxes detailing various things such as
> > date and time, page number etc. The objects in the Footer and Body are
> > indented slightly and nothing overlaps.
> >
> > Why am I getting these blank pages spilled in to Acrobat?
> >
> > thanks
> >
> > Matt|||Dale/Matt
Thank you for your responses. I have managed to get this to work now
and pdf correcly by altering the page widths. Thank you both so much.
Lisa
"Dale" <dale@.NoSpamPlease.ca> wrote in message news:<ewSzN1daEHA.752@.TK2MSFTNGP09.phx.gbl>...
> I believe I ran into this on a report I had to export to pdf and if I recall
> correctly, I was able to resolve it by playing around with the 'Size'
> properties of the Body and the 'PageSize' properties of the Report.
> You see the Body properties by clicking on an empty area of your report in
> Report Designer, the white part with the grid lines or dots on it.
> You see the Report properties by clicking on the thin beige area in Report
> Designer just to the right or left of the Body of the report I just
> described above.
> I found that by playing around with these #'s I was able to control the pdf
> rendering a bit better. I think one set of #'s had to be bigger than the
> other to stop the blank page thing from happening. And please don't ask
> which way it goes 'cause I don't remember :-) And I don't have that project
> open right now and don't want to wait 10 minutes for it to open. Our
> solution is getting rather large and seems to take forever to open.
> Hope that helps.
> Dale
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:esfCduUaEHA.1644@.tk2msftngp13.phx.gbl...
> > Are there some guidlines on setting the page and body sizes as well as
> > laying out objects such that PDF doesn't throw blank pages between or
> pages
> > or on the first page.
> >
> > My page is standard A4 which in landscape means it is 29.7cm wide - and
> this
> > is what I have set the report width to. I have margins of 1cm on the
> right
> > and 1cm on the left, the top and bottom margins are both 1.5cm. Allowing
> > for this, the report body and footer (no header) are 27.5cm wide.
> >
> > Body contains two tables. One table is stand alone the other Table is
> > imbedded in a List grouped on user Id - there are no pagebreak checkboxes
> > checked.
> >
> > In the footer I have a few textboxes detailing various things such as
> > date and time, page number etc. The objects in the Footer and Body are
> > indented slightly and nothing overlaps.
> >
> > Why am I getting these blank pages spilled in to Acrobat?
> >
> > thanks
> >
> > Matt
> >
> >
Friday, February 24, 2012
Animation Speed (Auto – Hide) Management Studio
Does anyone know how to set the Animation Speed for SQL Server Management Studio.
I think the setting is stored in the SQLShell settings file in the C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\profiles but adjusting the number up and down didn't seem to have any effect on the Auto-Hide speed.
Thanks
Kevin Haglund
1. Close SQL Server Management Studio.2. Open this file in a text editor C:\Documents and Settings\<username>\My Documents\SQL Server Management Studio\Settings\CurrentSettings-2006-02-01.vssettings
3. Search for "AnimationSpeed" and replace the existing value (5) with your desired speed; 10 being the fastest choice, I do not know what is the lowest (1?). Save.
4. Open SQL Server Management Studio and it should now animate at your desired speed.
Siric
Monday, February 13, 2012
Analysis Services NLB
Hi everyone, I'm setting up two Analysis Services servers in NLB
following the directions in the link
http://www.microsoft.com/technet/pro.../olapsite.mspx
After some tries, both servers are working fine alone (trough each
server name), but not trough the NLB. Any Ideas?, Anyone has any other
step-by-step guide to setup a NLB configuration for Analysis Services?
Thanks in advance.
Miguel.
How are you testing that the servers are working?
Are you using Analysis Manager or a client like MDX Sample? It is not
recommended that you use Analysis Manager in and NLB environment (it
will only work against the NLB IP address)
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1139507155.262121.310690@.f14g2000cwb.googlegroups .com>,
mi.balle@.gmail.com says...
> Hi everyone, I'm setting up two Analysis Services servers in NLB
> following the directions in the link
> http://www.microsoft.com/technet/pro.../olapsite.mspx
> After some tries, both servers are working fine alone (trough each
> server name), but not trough the NLB. Any Ideas?, Anyone has any other
> step-by-step guide to setup a NLB configuration for Analysis Services?
> Thanks in advance.
> Miguel.
>
following the directions in the link
http://www.microsoft.com/technet/pro.../olapsite.mspx
After some tries, both servers are working fine alone (trough each
server name), but not trough the NLB. Any Ideas?, Anyone has any other
step-by-step guide to setup a NLB configuration for Analysis Services?
Thanks in advance.
Miguel.
How are you testing that the servers are working?
Are you using Analysis Manager or a client like MDX Sample? It is not
recommended that you use Analysis Manager in and NLB environment (it
will only work against the NLB IP address)
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1139507155.262121.310690@.f14g2000cwb.googlegroups .com>,
mi.balle@.gmail.com says...
> Hi everyone, I'm setting up two Analysis Services servers in NLB
> following the directions in the link
> http://www.microsoft.com/technet/pro.../olapsite.mspx
> After some tries, both servers are working fine alone (trough each
> server name), but not trough the NLB. Any Ideas?, Anyone has any other
> step-by-step guide to setup a NLB configuration for Analysis Services?
> Thanks in advance.
> Miguel.
>
Analysis Services NLB
Hi everyone, I'm setting up two Analysis Services servers in NLB
following the directions in the link
http://www.microsoft.com/technet/pr...n/olapsite.mspx
After some tries, both servers are working fine alone (trough each
server name), but not trough the NLB. Any Ideas?, Anyone has any other
step-by-step guide to setup a NLB configuration for Analysis Services?
Thanks in advance.
Miguel.How are you testing that the servers are working?
Are you using Analysis Manager or a client like MDX Sample? It is not
recommended that you use Analysis Manager in and NLB environment (it
will only work against the NLB IP address)
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1139507155.262121.310690@.f14g2000cwb.googlegroups.com>,
mi.balle@.gmail.com says...
> Hi everyone, I'm setting up two Analysis Services servers in NLB
> following the directions in the link
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/olapsite.mspx[/ur
l]
> After some tries, both servers are working fine alone (trough each
> server name), but not trough the NLB. Any Ideas?, Anyone has any other
> step-by-step guide to setup a NLB configuration for Analysis Services?
> Thanks in advance.
> Miguel.
>
following the directions in the link
http://www.microsoft.com/technet/pr...n/olapsite.mspx
After some tries, both servers are working fine alone (trough each
server name), but not trough the NLB. Any Ideas?, Anyone has any other
step-by-step guide to setup a NLB configuration for Analysis Services?
Thanks in advance.
Miguel.How are you testing that the servers are working?
Are you using Analysis Manager or a client like MDX Sample? It is not
recommended that you use Analysis Manager in and NLB environment (it
will only work against the NLB IP address)
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell
In article <1139507155.262121.310690@.f14g2000cwb.googlegroups.com>,
mi.balle@.gmail.com says...
> Hi everyone, I'm setting up two Analysis Services servers in NLB
> following the directions in the link
> [url]http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/olapsite.mspx[/ur
l]
> After some tries, both servers are working fine alone (trough each
> server name), but not trough the NLB. Any Ideas?, Anyone has any other
> step-by-step guide to setup a NLB configuration for Analysis Services?
> Thanks in advance.
> Miguel.
>
Subscribe to:
Posts (Atom)