Maybe a second thought:

select db_name(sind.database_id) as dbname,object_name(sind.object_id,sind.database_id) as objname,sind.index_id,sind.index_type_desc,sind.avg_fragmentation_in_percent,'ALTER INDEX ON '+db_name(sind.database_id)+'.dbo.'+object_name(sind.object_id,sind.database_id)+'.'+si.name+' REBUILD WITH (FILLFACTOR = 85, SORT_IN_TEMPDB = ON STATISTICS_NORECOMPUTE = ON) ' as executethsestatemetns

from sys.dm_db_index_physical_stats(NULL,NULL,NULL,NULL,DEFAULT) sind join sys.indexes...

select db_name(sind.database_id) as dbname,object_name(sind.object_id,sind.database_id) as objname,sind.index_id,sind.index_type_desc,sind.avg_fragmentation_in_percent,'ALTER INDEX ON '+db_name(sind.database_id)+'.dbo.'+object_name(sind.object_id,sind.database_id)+'.'+si.name+' REBUILD WITH (FILLFACTOR = 85, SORT_IN_TEMPDB = ON STATISTICS_NORECOMPUTE = ON) ' as executethsestatemetns

from sys.dm_db_index_physical_stats(NULL,NULL,NULL,NULL,DEFAULT) sind join sys.indexes si

on si.index_id =...

There are some threads about the same situation on thsi site...

also check sp_msforeachtable and sp_msforeachdb to check for all tables in each database at one go.

Awsome, have a good day ahead and keep posting:-).

as of now, do not change the compatibility level to 90 from 80 as there might be some things like join predicates you will want o to check before making...

Mani Singh (6/23/2009)

---

we use this procedure for tracking long running jobs and sending out emails once it finds one:

"All credits to the Author of the script: I forgot who that...

What is this application(access or something else) what si the SQL server version SP and OS version and SP.

Also does this app/users connect/use DSN..

Well, when you think you know it all, you suddenly realize you are standing at the last position in the queue:

good Question: which prompted me to search around:

http://www.sqldbatips.com/showarticle.asp?ID=23

or...

we use this procedure for tracking long running jobs and sending out emails once it finds one:

"All credits to the Author of the script: I forgot who that wonderful person...

I see it is a Julian date.. if i am right?

there are many functions to convert from julian to georgian..

http://www.databasejournal.com/features/mssql/article.php/1442021/Working-with-Dates.htm

search for julian in here:

click on jobs folder in sql agent.. then goto object explorer details on the right pane.

ctrl+a to select all--> then right click -> script job as->create to-> new query window...

By looking at the BAckups history, you should have a fair idea of how much time each instance takes.

then schedule each instance backups at diff times.

Else you willl end up...

try this:

DBCC TRACEON (first run this) then

DBCC TRACESTATUS(-1)

and post the results (if any)

are you trying to conenct to SQL server express edition.

you can using SSMS if TCP/IP is configured , but you will not be using configuration management.

I forgot to ask:

What is the size of your TEMPDB and whats your drive size.

Which OS version with SP and SQL version with SP.

What is your Drive configuration? (if you...