1. SQL will warn you if you create a procedure which is refereing to "non-existing" procedure

create procedure foo

as

execute bar

=========

Cannot add rows to sysdepends for the current stored procedure because it...

My observations are as below.

xp_enumerrorlogs reads the file ERRORLOG (from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\Parameters Key) and for Archived logs are named as per extension of the rest ERRORLOG).

I changed the extension of previous ErrorLogs...

There are some drawbacks of using DBCC INDEXDEFRAG

1. it doesn't update statistics at all

2. It is always fully logged

Data is always logged in transaction log file. The transaction log is a serial record of all modifications that have occurred in the database as well as the transaction that...

For Getting the list of server in destination, It MUST be registered in Enterpise manager.

Please check and let me know.

Nice to hear that issue is resolved by solution provided by me.

I have no idea why Component Checker returns unknown.

If you need any help in that, I need to do...

That's interesting

Download a tool from below link and run it

http://www.betav.com/Files/Content/Tools/tools.htm

Download mdacrt.exe from there any Run it. You should see drivers listed there after this...

Once you see drivers listed there,...

Is there any driver listed in ODBC Administartor??

You wil find many GUID (Long numbers; something like {DD90D410-1823-43EB-9A16-A2331BF08799}) under that key.

Please try deleting them and reinstall MDAC

lets do this.

Delete below key from Registry (please take backup) and reinstall MDAC

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Setup\ExceptionComponents

Reinstall MDAC and run component checker again

1. Please go to Control Panel => ODBC Administrator and check that you have SQL Driver listed

2. If not, download component checker from support.microsoft.com and check MDAC dll versions

3. If...

Microsoft SQL Server 2000 Index Defragmentation Best Practices

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx

Quick question:

Do you have auto-shrink option enable for the database?

Microsoft has a KB article for this error message.

http://support.microsoft.com/?id=912816

As per KB

This problem occurs after you install the cumulative security update that is referenced in the following Microsoft Knowledge Base...

Hope below link will help you

http://support.microsoft.com/?id=317428