DBCC SHOW_STATISTICS or STATS_DATE

No.

Thats a bit strange because a custom job that only rebuilds the STATS with FULL SCAN takes

3:30 hr to complete while a Dtabase maintenaince plan that uses DBCC...

Ok, its raid 5 but, But ive got a raid 1 that I can put the ldf, backups, tempdb on, trans logs on.

thanks

You should only use DBCC INDEXDEFRAG on indexes with less than 1000 pages, and the if it does have more than 1000 pages then

Logical Scan Fragmentation > 20% OR Avg....

he he!

This is proably nothing to do with SQL Server, IF you use the BDE (borland databse engine to connect to sql you wll have to configure the BDE properly) There...

The obvious choice would be Erwin, which I use. We could then share diagrams between anhyone else with erwin. It doesn’t read database dumps though. It can connect and reverse...

try writing the steps your self in a job. You can then simply script the joob to another server.

For sql server 7.0, use "isql"

Sql server 2000, "osql"

And sql 2005, "sqlcmd"

Transactional replication is the way forward but rember the disadvantages:

More complex setup than log shipping,

More newtork traffic,

Complex failback after primary failure.

you should use dbmail in SQL2005.

databse logins can be imported by creating a syslogins.dat file and import using bcp, server logins have to be scripted manually, Do this by rightcliking on the server login in...

I have a strange feeling this depends on what OS you run the sp on, 2000, XP etc....

FInd out whicg OS does what and then code this into the sp.

Definetley a permission issue, it might not necessary be permissions with the sql agent, it could be permissions on the linux box if the DTS package has to get data...