Francisco,

as an info for you our db server for the SAP database server running SQL2K Ent Ed. is

4 X XEON 700 CPU

4 GB RAM

Compaq MA8000 disk subsystem

system, log,...

I have exactly the same problem with my SAP databases as Lee Dise told.

We hae 25000+ tables, all the system tables are terribly fragmented and I cannot do anything to...

I have SAP databases on SQL2K.

It is working fine and fast.

1200+ users, 100GB+ databases

Why not to make it simple:

In EM right click the database to be scripted, All tasks, Genarate SQL script.

And there you choose the options you want to script.

Simple, fast except...

Andy,

If Primary keys AND (clustered) indices are so important why MS is not using them on the system tables?

there is ablosutly no PK on system tables and on some tables...

Just to be stuck to the wording I would say it is not garanteed but most probably it will be the same.

But as Dan has shown us it couls be...

put /3GB switch to your boot.ini file then reboot your machine

From the security point of view you should have your log files on separate physical disks.

From the performance pont of view the best is to separate the system databases (master,...

I don't know exactly what do you nead by storing the index pages.

The index and data pages are stored within the operating system files you defined in your create db...

It is a bit complicated, but it's feasible:

first of all you update the statistics on a table not on a DB.

To see all the statistics enter:

sp_helpstats YourTableName, 'ALL'

after you...

Have a look in the BOL

The syntax is:

alter database YourDB modify file (name = OldLogicalName, Newname = NewLogicalName)

A mainframe will never talk to SQLServer.

a mainframe is a "BIG" machine.

SQLServer has to learn to speak to the mainframe through OLEDB for example

Why not to use the Host Integration Server (HIS) from Microsoft?

I also have data on our mainframe (VSAM and DB2 V6.1) and I can access them trough HIS.

I am even...

Why not to make an alter table alter column ColumnName NOT NULL after the insert into statement.

So you can create your primary key

Have a look in EM database master. Tjere stored proces or in QA database master type sp_helptext sp_who2