Get to the server manager and check on autostartup options. sqlAgent might not have been started. start it and check box for autostartup.

Since you say that the database schema is not that stable. best option i can think of is to do a daily backup and restore diffrential backup every say 30...

Why don't you try after backing up the log, dbcc shrinkfile and see if that works.

Each DTS package has a version stored when its run. My guess would be no...you cannot run the same package versions on a single instance sql 2000.

Try Swynk.com. There are couple of DTS scripts there and procs as well.

Check the work flow of steps which need to be followed after each step is sucessfully executed. There might be some step which did not have the right work flow...

U might want to check to see if the version has changed, i.e someone made changes and saved it. Try to run a version that is a week old where...

I think it doesn't give that liberty to import access diagrams.

Guess since you did not detach , it might not take the attach . I think u cannot attach if you did not detach the files. Maybe you can...

there are couple of ways you can do that:

1. Restart sql server (ruled out i guess)

2. U can run sp_cycle_errorlog, but the number of versions will be 6 only. to...

Maybe you can try VISIO 2000. Its also a good tool.

if you have clustered indexes with not efficient fillfactor or without a fillfactor, that might also be the reason for slow running of your queries. As you had mentioned the...

Thanks for all answers :))

When you give access to READ|WRITE permissions mean FIXED DB ROLES, by default the user has access to the views you create.

Same problem on our server as well. Do as Hirenk mentioned.