What edition of sql server you are using?

Check in SQL SERVER configuration manager..

If it is express SQL Agent will not be available.

Microsoft SQL Server 2000 Index Defragmentation Best Practices

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

From BOL:

Local partitioned views are included in SQL Server 2005 for backward compatibility purposes only, and are in the process of being deprecated. The preferred method for partitioning data locally...

I think it is related to network protocol...

Check the network protocol configuration...

You can alias sql instance in client network utililty..

If you stop the sql service in SCM, I don't think you can connect without starting sql in SSMS...

net stop sqlserveragent

net stop mssqlserver

net start mssqlserver

net start sqlserveragent

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

I don't think it is going to work if grant exec permission to sp_helptext because in SQL 2005 security is locked down completely...

Just guess: One option might be create a...

Wen you are creating index use ON <Filegroup> option otherwise index will be created on default filegroup....

CREATE INDEX IX_INDEX ON TABLENAME(COLUMN_NAME) ON FILEGROUP_NAME

Close the command window to stop the sql...

Check the startup parameters in configuration manager...

Disable VIA protocol if it is enabled...

Start the sql from configuration manager and see what you get..

I did not understand your question completely but....

If you want to map the login to run the xp_cmdshell on the remote server you can map it to 'sa'... I don't...

Datediff function provides the difference between the two dates so what is the relation with DST?

As mentioned before sql time is system time there no other serperate clock for sql.

Try changing your PORT number from 1433 to 1434/1435...in configuration manager..

I don't have servers running 2000 cmpt mode...

The following article will help you and BOL http://msdn2.microsoft.com/en-us/library/ms178653.aspx

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx

Based on the following thread disabling VIA protocol resolved...

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

Did you check your startup parameter in configuration manager?

There are some third party comparision tools out there you can use them if it is one time process by downloading trial version...

Google "Shcema comparision tools for sql server" or...

Use SQL server conffiguration Manager or you can create a batch file using NETSTOP/NETSTART commands...