Are you going to migrate from the existing Sql Server 2000 to another Sql 2000 server ?if thats then ensure the following,

1.You can attach/restore system databases only if they have...

Check if this helps,

http://sql-articles.com/index.php?page=Scripts/scrip_user_05.php

Refer the below link as well which describes the 3 roles available in msdb which John mentioned,

http://msdn2.microsoft.com/en-us/library/ms188283.aspx

No it is not possible to perform downgrading from enterprise to standard without uninstalling/reinstalling.

Refer this link for the available upgrade options in In-place upgrade,

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

Sql Server 2005 has a compatability of 90 whereas Sql Server 2000 has 80. In order to utilize the features available in Sql 2005 you need to have it as...

If it is Sql Server 2000 ensure that the name of the new server is reflected in originating_server column in sysjobs system table. If not you can update the same...

Hi,

If you want to perform backup from being in one server to another server, you need to create a share in that server and ensure that Sqlservice account has modify...

You can only install client tools and not the database engine of Sql Server 2005 Enterprise Edition. To install client tools run the Sqlrun_tools.msi file available in Tools\Setup folder of...

You may also refer this below link,

http://www.mssqltips.com/tip.asp?tip=1166

You can refer these links which might help your case,

http://support.microsoft.com/kb/263556

http://www.databasejournal.com/features/mssql/article.php/3424791

Good Luck !

You can use this query to list all the objects owned by EUR\ld5594 ID,

Select name from sysobjects where uid=user_id('EUR\ld5594')

you need to replace the login name with yours. After that you...

Have you applied SQL Server 2005 Service Pack 2 if not pls go ahead and apply the same and see if the problem persist.

Hi John,

Ensure that you have applied Sql Server 2005 SP2 for Tools as well.

Refer this http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1404000&SiteID=1

for more information.

1. You cannot restore system databases from SQL 2000 to SQL 2005 as both are of different builds. So the only option is to script all the logins using http://support.microsoft.com/kb/246133

using...

Ensure that the Sql Service account has modify permissions on the folder containing data and log files. In your case I think SQL Server would not have started. For user...