Defrag data disk

Hi,
The disks on which my databases are stored is heavily
fragmented. This because of wrong database grow settings.
Can I use the Windows system tool: Disk Defragmenter to
defragment my disk or will SQL not like this?
Thanks,
Jeroen.I believe you can, so long as the block size <= 4KB.
You will need to stop sql server if you want the data files defragemented
"Jeroen" <nieuwdamsigt@.hotmail.com> wrote in message
news:006101c3c31f$9e391750$a101280a@.phx.gbl...
> Hi,
> The disks on which my databases are stored is heavily
> fragmented. This because of wrong database grow settings.
> Can I use the Windows system tool: Disk Defragmenter to
> defragment my disk or will SQL not like this?
> Thanks,
> Jeroen.|||"Jeroen" <nieuwdamsigt@.hotmail.com> wrote in message
news:006101c3c31f$9e391750$a101280a@.phx.gbl...
> Hi,
> The disks on which my databases are stored is heavily
> fragmented. This because of wrong database grow settings.
> Can I use the Windows system tool: Disk Defragmenter to
> defragment my disk or will SQL not like this?
>
Also your disks may appear more fragmented than they really are.
If you have a few large files that are in 2 fragments, you disk can report
as being 90% fragmented without this being a big deal.
David

Default Trace SQL 2005

What settings are there for the default trace option in SQL 2005? I see that
it stores a history of traces in the \MSSQL.1\MSSQL\LOG. It is pretty cool
because it will show you in SSMS a SQL report with schema changes on a per
database level.
I just want to know how to modify the setings for the default trace option as
far as size, time, and rollover.The only setting that exists is to turn it off (using sp_configure). IF you want something different
from the default, you have to roll your own (using server-side traces). Being able to customize
these things is interesting, so you might want to suggest this for next version
(http://connect.microsoft.com/sqlserver).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"evan4434" <u36821@.uwe> wrote in message news:7709e496ca18a@.uwe...
> What settings are there for the default trace option in SQL 2005? I see that
> it stores a history of traces in the \MSSQL.1\MSSQL\LOG. It is pretty cool
> because it will show you in SSMS a SQL report with schema changes on a per
> database level.
> I just want to know how to modify the setings for the default trace option as
> far as size, time, and rollover.
>

default settings when creating a database

Hello,
Some users create new databases using the enterprise manager console (right
click in the database section and then selecting new database).
Once created this database has default settings like "Auto shrink" checked
or "Auto close" unchecked (in the option tab).
Is there a way to set these default settings so each time a new database is
created it has the right options?
thanks
Yes, set the correct options on the Model database. That database is the
baseline from which all other databases on a server are created.
<grille11@.yahoo.com> wrote in message
news:cjju9f$bb5$1@.reader1.imaginet.fr...
> Hello,
> Some users create new databases using the enterprise manager console
(right
> click in the database section and then selecting new database).
> Once created this database has default settings like "Auto shrink" checked
> or "Auto close" unchecked (in the option tab).
> Is there a way to set these default settings so each time a new database
is
> created it has the right options?
> thanks
>
|||I could have searched a little more for this one I guess. Thanks!
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OMxDsF9pEHA.2864@.TK2MSFTNGP12.phx.gbl...[vbcol=seagreen]
> Yes, set the correct options on the Model database. That database is the
> baseline from which all other databases on a server are created.
>
> <grille11@.yahoo.com> wrote in message
> news:cjju9f$bb5$1@.reader1.imaginet.fr...
> (right
checked
> is
>

default settings when creating a database

Hello,
Some users create new databases using the enterprise manager console (right
click in the database section and then selecting new database).
Once created this database has default settings like "Auto shrink" checked
or "Auto close" unchecked (in the option tab).
Is there a way to set these default settings so each time a new database is
created it has the right options?
thanksYes, set the correct options on the Model database. That database is the
baseline from which all other databases on a server are created.
<grille11@.yahoo.com> wrote in message
news:cjju9f$bb5$1@.reader1.imaginet.fr...
> Hello,
> Some users create new databases using the enterprise manager console
(right
> click in the database section and then selecting new database).
> Once created this database has default settings like "Auto shrink" checked
> or "Auto close" unchecked (in the option tab).
> Is there a way to set these default settings so each time a new database
is
> created it has the right options?
> thanks
>|||I could have searched a little more for this one I guess. Thanks!
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:OMxDsF9pEHA.2864@.TK2MSFTNGP12.phx.gbl...
> Yes, set the correct options on the Model database. That database is the
> baseline from which all other databases on a server are created.
>
> <grille11@.yahoo.com> wrote in message
> news:cjju9f$bb5$1@.reader1.imaginet.fr...
> > Hello,
> >
> > Some users create new databases using the enterprise manager console
> (right
> > click in the database section and then selecting new database).
> > Once created this database has default settings like "Auto shrink"
checked
> > or "Auto close" unchecked (in the option tab).
> > Is there a way to set these default settings so each time a new database
> is
> > created it has the right options?
> >
> > thanks
> >
> >
>

Default settings for strings and numbers

How do I change the default settings on SQL Server so that; when I create a
new table in EM or import a table from Excel, I will always get varchar(100)
for any string instead of nvarchar(255), and change the default for numbers
to numeric(19,6) instead of float(53)?
Thanks.
ArcherNo, Enterprise Manager does not have any provisions to change such defaults
for datatypes.
Anith

default rs settings

is there a simple manual how to setup RS.

with the administrators group im able to view my reports. but normal users are not able to view anything. they can enter reporting services, but not open a report.

The answer to your problem is to go into Report Manager, click on the properties tab, and add a New Role Assignment.

In the Group or User name box, type Everyone, and then below that, select Browser.

Click on OK.

You can look thru the BOL to see this also. Also, check out the many ssrs blogs online.

hth

BobP

Default Printing Option for Crystal Report

I have developed a PDF web report which opens in a browser by using Crystal Report for VS.NET 2003. Is there any way to capture the printer settings of the users (who view this report) and change the Printer Paper Size to Legal? I understand that this is a security issue and this is not permitted under normal circumstances...but is there a round about way? My OS is Windows 2003.
Thanks for your helpIf I understand your question correctly, here's how I do it in VB 6 and CR 8.5 using RDC (maybe you can manipulate it to fit your needs?).

Report.PaperSize = crPaperLegal
Report.PrintOut

This way, you don't have to change the user's settings.

Default Printer settings

I have an issue with default papaer size and margin sizes. My printer is
configured with a default paper size of A4, every time I print a report with
the print control it defaults to Letter. So I have to hit the go button to
the print to run.
Secondly the default margin sizes are 12.7mm (1/2 inch), I woudl like to
reduce this to 5mm (@. 3/16 inch). I have had a similiar issue with blank
pages and found reducing the default print margin control to something less
than 1/2 inch sorts this out.
Is there a congfig file setting that I can change to make these printer
settings stick?
thanks
RayThe print control will use the margins set in your report. If you do not
set the margins, it will default to half an inch.
--
| Thread-Topic: Default Printer settings
| thread-index: AcVKL/UhL/9g9tA8Qqi+9Q5klGKalQ==| X-WBNR-Posting-Host: 203.10.231.231
| From: "=?Utf-8?B?UmF5IFNlcHBhbGE=?="
<Ray.Seppala@.defence.gov.au.(Donotspam)>
| Subject: Default Printer settings
| Date: Tue, 26 Apr 2005 00:17:08 -0700
| Lines: 16
| Message-ID: <6315458B-6B62-4F09-AFC1-76E19A8B4ABD@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41806
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have an issue with default papaer size and margin sizes. My printer is
| configured with a default paper size of A4, every time I print a report
with
| the print control it defaults to Letter. So I have to hit the go button
to
| the print to run.
|
| Secondly the default margin sizes are 12.7mm (1/2 inch), I woudl like to
| reduce this to 5mm (@. 3/16 inch). I have had a similiar issue with blank
| pages and found reducing the default print margin control to something
less
| than 1/2 inch sorts this out.
|
| Is there a congfig file setting that I can change to make these printer
| settings stick?
|
| thanks
|
| Ray
||||Thanks,
I have since found out that I have to re-publish all my reports for RS SP2
to be able to read each Report's print layout and margin settings.
Thanks for the the reply Brad!
""Brad Syputa - MS"" wrote:
> The print control will use the margins set in your report. If you do not
> set the margins, it will default to half an inch.
> --
> | Thread-Topic: Default Printer settings
> | thread-index: AcVKL/UhL/9g9tA8Qqi+9Q5klGKalQ==> | X-WBNR-Posting-Host: 203.10.231.231
> | From: "=?Utf-8?B?UmF5IFNlcHBhbGE=?="
> <Ray.Seppala@.defence.gov.au.(Donotspam)>
> | Subject: Default Printer settings
> | Date: Tue, 26 Apr 2005 00:17:08 -0700
> | Lines: 16
> | Message-ID: <6315458B-6B62-4F09-AFC1-76E19A8B4ABD@.microsoft.com>
> | MIME-Version: 1.0
> | Content-Type: text/plain;
> | charset="Utf-8"
> | Content-Transfer-Encoding: 7bit
> | X-Newsreader: Microsoft CDO for Windows 2000
> | Content-Class: urn:content-classes:message
> | Importance: normal
> | Priority: normal
> | X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
> | Newsgroups: microsoft.public.sqlserver.reportingsvcs
> | NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
> | Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
> | Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:41806
> | X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
> |
> | I have an issue with default papaer size and margin sizes. My printer is
> | configured with a default paper size of A4, every time I print a report
> with
> | the print control it defaults to Letter. So I have to hit the go button
> to
> | the print to run.
> |
> | Secondly the default margin sizes are 12.7mm (1/2 inch), I woudl like to
> | reduce this to 5mm (@. 3/16 inch). I have had a similiar issue with blank
> | pages and found reducing the default print margin control to something
> less
> | than 1/2 inch sorts this out.
> |
> | Is there a congfig file setting that I can change to make these printer
> | settings stick?
> |
> | thanks
> |
> | Ray
> |
>