If your Sql Server is running currently under local system account then if you drop builtin the Sql agent service will not start.

So before dropping it you need to...

Your only option is to use T-Sql query to backup the database,

Backup database dbname to disk='Path\filename.bak'

You can make use of the below query and see if it helps,

xp_regread @rootkey='HKEY_LOCAL_MACHINE',

@key='SYSTEM\ControlSet001\Services\SQLServerAgent',

@value_name='ObjectName'

You can start Sql Server in single user mode using net start command as well as shown here for default instance of Sql Server. You need to type the below...

For all the user databases and model,msdb you need not stop the services. Its just a normal restore. But inorder to restore the master database you need to start Sql...

You can save your packages as .dts file and then later import them into Sql Server. Regarding the assemblies I am not sure if you can script it. As Mobasha...

Can you confirm whether there is sufficient folder permission to create the sparse file ? Please check the if that particular login has permissions to the NTFS folder permission to...

Check this thread from MSDN and see if it helps,

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

Just for confirmation, did you apply SP2 for SSMS as well ? Click Help - about it will display the version of SSMS

You can rebuild system databases in Sql 2005 and specify the collation as well using the below command,

start /wait CD or DVD Drive\setup.exe /qn INSTANCENAME=MSSQLSERVER REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=NewStrongPassword SQLCOLLATION=NewSystemCollation

But before...

We use Sql Server native backup for backing up medium sized databases. In few servers where there are large databases we use litespeed. The compression of the backup file is...

I think you are trying to connect to the remote server using the SA password. Please ensure that the SA password is correct for the remote server.

You can also make use of database publishing wizard to accomplish the same. Refer, http://www.microsoft.com/downloads/details.aspx?familyid=56E5B1C5-BF17-42E0-A410-371A838E570A&displaylang=en

I think your only option is uninstall Sql 2000 EE and install Sql 2000 Std and restore the databases from backup, script the logins before uninstalling etc..

Check these Microsoft KB articles and see if it helps,

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

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