defrag

hoe do i defrag the sql database?http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <bill@.discussions.microsoft.com> wrote in message
news:3063DFAD-8F5D-485D-B64E-80B4DE4563CE@.microsoft.com...
> hoe do i defrag the sql database?|||thanks.
where do i tyoe these commands?
"Tibor Karaszi" wrote:
> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "bill" <bill@.discussions.microsoft.com> wrote in message
> news:3063DFAD-8F5D-485D-B64E-80B4DE4563CE@.microsoft.com...
> > hoe do i defrag the sql database?
>
>|||Use Query Analyzer (2000) or SQL Server Management Studio (2005), create a stored procedure
containing the commands, and create an SQL Server Agent job that call this procedure with your
desired schedule.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"bill" <bill@.discussions.microsoft.com> wrote in message
news:62625214-0680-4D61-8945-D75E2306F4E9@.microsoft.com...
> thanks.
> where do i tyoe these commands?
>
> "Tibor Karaszi" wrote:
>> http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "bill" <bill@.discussions.microsoft.com> wrote in message
>> news:3063DFAD-8F5D-485D-B64E-80B4DE4563CE@.microsoft.com...
>> > hoe do i defrag the sql database?
>>