pavankvnv (4/17/2012)
HI Muthu,I ran the script and it created those two tables in master and msdb and executed successfully.
But fragmentation is not reduced. Please let me know how to put this script in a job that should execute weekly and should run for all databases.
Thanks,
Pavan KVN
It may be a small table.
You can do that using script. Write a SP loop the sys.databases.
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/