Can we change the page size of crstal report

I need to set the size of the page 8.5*3.5
can i change it.I dont know about the Developer end, but you can change the size of the paper at the CMC end.

In the CMC when you to go the report options and Process tab, there youcan find the page setup. In that option if you check the customize option u can fix the page length and width.

all the best

can we change the file size that c2 creates a new trc file at ?

hello there
I want to know if I can have sql server C2 login log to a file till it
reaches 10 megs and switch to another one.
the reason is that I want to ship the logs to a log aggregation software
every hour or so ?
any ideas ?
Hi,
As far as I know we cant change the trace file size after enabling C2 audit.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eSKK8R3dFHA.688@.TK2MSFTNGP14.phx.gbl...
> hello there
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
> any ideas ?
>

can we change the file size that c2 creates a new trc file at ?

hello there
I want to know if I can have sql server C2 login log to a file till it
reaches 10 megs and switch to another one.
the reason is that I want to ship the logs to a log aggregation software
every hour or so ?
any ideas ?Hi,
As far as I know we cant change the trace file size after enabling C2 audit.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eSKK8R3dFHA.688@.TK2MSFTNGP14.phx.gbl...
> hello there
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
> any ideas ?
>

can we change the file size that c2 creates a new trc file at ?

hello there
I want to know if I can have sql server C2 login log to a file till it
reaches 10 megs and switch to another one.
the reason is that I want to ship the logs to a log aggregation software
every hour or so ?
any ideas ?Hi,
As far as I know we cant change the trace file size after enabling C2 audit.
Thanks
Hari
SQL Server MVP
"Simo Sentissi" <msentissi@.rightnow.com> wrote in message
news:eSKK8R3dFHA.688@.TK2MSFTNGP14.phx.gbl...
> hello there
> I want to know if I can have sql server C2 login log to a file till it
> reaches 10 megs and switch to another one.
> the reason is that I want to ship the logs to a log aggregation software
> every hour or so ?
> any ideas ?
>sql

Can t-log size handle large number of deletions?

Hi All,
Im just wondering if there is a way i could find out if the size of my
transaction log will be able to record the number of deletions i will be
performing? Basically i have to delete 325 million rows from a table and my
t-log is, say 20GB. is there a way i can calculate if the t-log is big
enough or will it need to expand?
thx in advance.Well I certainly would not advocate deleting them all in one batch. If you
delete them in smaller batches (say 10K or 100K at a time) it will not only
be faster but you would have the option to backup or truncate the log as you
go along. How many rows in the table do you want to keep. It may be
easier to BCP out the ones to keep, truncate the table and bcp them back in.
--
Andrew J. Kelly
SQL Server MVP
"M Sandico" <msandico@.muchomail.com> wrote in message
news:%23ZDvAlIpDHA.3688@.TK2MSFTNGP11.phx.gbl...
> Hi All,
> Im just wondering if there is a way i could find out if the size of my
> transaction log will be able to record the number of deletions i will be
> performing? Basically i have to delete 325 million rows from a table and
my
> t-log is, say 20GB. is there a way i can calculate if the t-log is big
> enough or will it need to expand?
> thx in advance.
>|||You are correct in that I dont delete them all in one batch. I delete in
batches of 1000 with a BEGIN TRAN and COMMIT TRAN as well. What I am
planning to do is just set the model to SIMPLE during the deletion and have
the COMMIT TRAN force the log to be flushed during the automatic checkpoint
(when log is 70% full).
Just thought there would be a way to guesstimate how big a t-log youd need
for certain operations..
thx.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:e9rVaHJpDHA.360@.TK2MSFTNGP12.phx.gbl...
> Well I certainly would not advocate deleting them all in one batch. If
you
> delete them in smaller batches (say 10K or 100K at a time) it will not
only
> be faster but you would have the option to backup or truncate the log as
you
> go along. How many rows in the table do you want to keep. It may be
> easier to BCP out the ones to keep, truncate the table and bcp them back
in.
> --
> Andrew J. Kelly
> SQL Server MVP
>
> "M Sandico" <msandico@.muchomail.com> wrote in message
> news:%23ZDvAlIpDHA.3688@.TK2MSFTNGP11.phx.gbl...
> > Hi All,
> >
> > Im just wondering if there is a way i could find out if the size of my
> > transaction log will be able to record the number of deletions i will be
> > performing? Basically i have to delete 325 million rows from a table and
> my
> > t-log is, say 20GB. is there a way i can calculate if the t-log is big
> > enough or will it need to expand?
> >
> > thx in advance.
> >
> >
>|||I don't know of a formula off hand. You would have to account for at least
the amount of data that you are deleting and then some percentage for
overhead etc. What that percentage is I don't really know.
--
Andrew J. Kelly
SQL Server MVP
"M Sandico" <msandico@.muchomail.com> wrote in message
news:ugg192JpDHA.2188@.TK2MSFTNGP11.phx.gbl...
> You are correct in that I dont delete them all in one batch. I delete in
> batches of 1000 with a BEGIN TRAN and COMMIT TRAN as well. What I am
> planning to do is just set the model to SIMPLE during the deletion and
have
> the COMMIT TRAN force the log to be flushed during the automatic
checkpoint
> (when log is 70% full).
> Just thought there would be a way to guesstimate how big a t-log youd need
> for certain operations..
> thx.
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:e9rVaHJpDHA.360@.TK2MSFTNGP12.phx.gbl...
> > Well I certainly would not advocate deleting them all in one batch. If
> you
> > delete them in smaller batches (say 10K or 100K at a time) it will not
> only
> > be faster but you would have the option to backup or truncate the log as
> you
> > go along. How many rows in the table do you want to keep. It may be
> > easier to BCP out the ones to keep, truncate the table and bcp them back
> in.
> >
> > --
> >
> > Andrew J. Kelly
> > SQL Server MVP
> >
> >
> > "M Sandico" <msandico@.muchomail.com> wrote in message
> > news:%23ZDvAlIpDHA.3688@.TK2MSFTNGP11.phx.gbl...
> > > Hi All,
> > >
> > > Im just wondering if there is a way i could find out if the size of my
> > > transaction log will be able to record the number of deletions i will
be
> > > performing? Basically i have to delete 325 million rows from a table
and
> > my
> > > t-log is, say 20GB. is there a way i can calculate if the t-log is big
> > > enough or will it need to expand?
> > >
> > > thx in advance.
> > >
> > >
> >
> >
>

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>|||That's right.

>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in mess
age
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>
>

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.
Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>
|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>
|||That's right.

>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?
|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>
>

Can tempdb be presized?

SQL Server 2000 & 2005
When restarting a server, can you specify the size you want tempdb to be? I
have no choice but to place in on the same drive as the other .mdf files and
would like to avoid it being created in pieces.Yes. Simply create the files you want and expand them manually to the
desired size. When the server restarts, it will retain the specified size.
--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Jay" <nospam@.nospam.org> wrote in message
news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
> SQL Server 2000 & 2005
> When restarting a server, can you specify the size you want tempdb to be?
> I have no choice but to place in on the same drive as the other .mdf files
> and would like to avoid it being created in pieces.
>|||I take it it will only do this if you have sized it manually, but will
shrink the tempdb if it had auto-grown?
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:uqrJURjIIHA.4592@.TK2MSFTNGP02.phx.gbl...
> Yes. Simply create the files you want and expand them manually to the
> desired size. When the server restarts, it will retain the specified
> size.
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:%23KdcLIjIIHA.1168@.TK2MSFTNGP02.phx.gbl...
>> SQL Server 2000 & 2005
>> When restarting a server, can you specify the size you want tempdb to be?
>> I have no choice but to place in on the same drive as the other .mdf
>> files and would like to avoid it being created in pieces.
>|||That's right.
>I take it it will only do this if you have sized it manually, but will
>shrink the tempdb if it had auto-grown?|||Makes sense.
Thank you Aaron.
Thank you Geoff.
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:uWnkLvjIIHA.4956@.TK2MSFTNGP06.phx.gbl...
> That's right.
>>I take it it will only do this if you have sized it manually, but will
>>shrink the tempdb if it had auto-grown?
>

Can SQL Express handle database size up to 9 GB?

Hi everyone,

Kindly tell me the size of database that SQL Express can handle.

Tks for your cooperation.

Brgds,

Adien

The express system can only handle db sizes of 4gb. Note that you can have multiple databases on the one server each being 4gb in size.

|||If I have 9 gb database, can it convert to sql express 4 gb? 2 or 3 database each.|||

If you do wish to break it up into different databases you are going to have to look at your application design and how it connects to the database. You will not be able to have it configured as the one database over multiple files like you do in the full system, they will have to be different databases.

Can Reportviewer control size be dynamic

When using an asp.net 2.0 reportviewer control to display an SSRS report, the size of the report is always bigger that the control it is housed in. So you have to scroll back and forth.

Can't the Reportviewer control size be dynamic? What is the general parctice on this?

Thanks

ReportControl and SSRS newbie!

Hi,

I'm not sure what do you mean by "control the size dynamically". Based on my knowledge, if the report does not need to scroll verticall within the iframe, you can handle it in two ways.

First, assign the height, width value in a hard coded way, you can refer the following code which shares the solution.
http://www.codeproject.com/sqlrs/ReportViewer2005.asp

Second, you can set two properties to make the repoertviewer autosize:

AsyncRendering = false; and SizeToReportContent = true;

Thanks.