Query help

• Ford Fairlane

  SSCertifiable

  Points: 7664

  More actions

  September 1, 2005 at 7:57 pm

  #168586

  Hi all,

   

  I have a server (SQL 2000) which has some 100 odd databases on it. Now I am trying to script a job to on a weekly basis go through each database and for each table with in each database rebuild the indexes. I was hoping it would rathe rstraight forward as

  declare @cmd1 varchar(500)

  Set @cmd1 = EXEC sp_MSforeachtable @command1="print '?' DBCC DBREINDEX ('?')"

  exec sp_MSforeachdb @command1=@cmd1

   

  but it doesnt like this. Any ideas would be great as I am sure it something simple I have missed.

   

  Thanks

  Hope this helps...

  Ford Fairlane
  Rock and Roll Detective

  

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  September 1, 2005 at 9:35 pm

  #587081

  you can use part/all of this script

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**

• Ford Fairlane

  SSCertifiable

  Points: 7664

  More actions

  September 1, 2005 at 11:30 pm

  #587090

  sushila THANK YOU

  Hope this helps...

  Ford Fairlane
  Rock and Roll Detective