Good suggestions When I will have time, I'd try to done it.

Regards

Yes lowell, I guess, by default, it can actually change or delete the objects it creates, but MS should have been more explicit on the subject. It is actually possible...

Just simply and it's work fine.

Thank you very much Gail.

I must to improve my T-SQL practise

God damned :blink:

I haven't saw this task in toolbox...! So It work fine.

Thank you very well Greg

Many thanks Andras,

I haven't seen this SP in BOL. The next time I'll search more in msdb to find an answers.

Regards

I have had this problem when the replication down and growth log size of published database.

Si, I've create a new agent profile

Modify the default values by Query Timeout (3000) and...

Many Thanks for "philcart" for location of DTSBackup2000. It's exactly the tools I need. Save & restore basically three DTS is easy and fast, but when you have about fourty...

Hello,

Have a look on this :

http://www.sqlteam.com/filtertopics.asp?topicID=125

This will help you.

Kenavo

Philippe

Before installing SP4, try to check your memory allocation in SQL Server. Fix the max to 2Gb.

In the following link, you'd find some information !

http://support.microsoft.com/default.aspx?scid=kb;en-us;274750&Product=sql2k#3

I have a similar problem in a full reindex job. Just try to put the arithabort and set quoted identifier on in your job and made à test . It will running...

Hi,

If you want to reduce spaceused by your database, make a backup log then a dbcc shrinkfile of your data file. Maybe it can be necessary to made backup log with...

Hi, I have this problem on my job. So, go on this URL

http://support.microsoft.com/?kbid=301292

And then, add to your job (before your shrink) :