Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Script for jobs

Author  Topic 

gkrishn
Starting Member

16 Posts

Posted - 2006-01-20 : 06:36:42
http://support.microsoft.com/?kbid=902388 is my issue and i cant install sp4 as my appli: vendor wont accept sp4.

I have excluded that database from Maintanence plan and planing to run script as job .
.any one got script for Integrity check and Optimization job ? Please help

-Rajiv

nr
SQLTeam MVY

12543 Posts

Posted - 2006-01-20 : 10:49:05
Have a look at the dbcc commands in bol.
dbcc checkdb
dbcc dbreindex
...

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -