You posted this in 2005 forum so I believe you are using 2005...

In 2005 you can rebuild the indexes online while users are accessing...using ALTERT TABLE command...

Check the BOL topic...

Check this out...

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1151987&SiteID=17

I don't see anything except one thing...

If you want to use SQL mail on this server domain account should have sufficient rights to connect to exchange...

If you are writing your backups to network drive then make sure the domain account has the rihgts...

Domain account should be local admin on the server where the sql is...

I don't know it is a BUG or not...but

Try after applying sp2 hotfix which will be available either today or tomorrow...

Thanks Brandie....

For 2000 servers check the "msinfo32.exe" in C:\Program Files\Common Files\Microsoft Shared\MSInfo folder...

Microsoft Issues SP2 Hotfix for SQL Server 2005 for this problem...

http://bink.nu/Article9653.bink

There is some MP issue in SP2 but it is not the one...

Any way MS releasing hotfix for SP2...

http://blogs.msdn.com/sqlrem/archive/2007/02/24/Maintenance-Plan-Changes-in-SQL-Server-2005-SP2.aspx

http://bink.nu/Article9653.bink

Can you ping?

can you run four part linked server queries?

Peer-to-peer with in the same domain? or different domain?

If it is different domain, windows login may not work...

Try using bcp utility...

Check BOL for syntax...

I think you are running bcp command in query window...

bcp command is command line utility, if you want to run in query window you have call through xp_cmdshell command...

exec xp_cmdshell...

For Single node (active/passive) cluster, start sp installation from the active node and it will be installed on passive node...

For two node (active/active) cluster, start the installation once from each node....

You have...

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

http://www.nigelrivett.net/DMO/DMOScriptAllDatabases.html

In my previous post there was typo...

I mean to say "remote Connections"...

YOu can this through Surface Area Configuration (SAC)...