I wouldn't recommend 64-bit with SQL 2000, but if you are 2005 or 2008, it should work fine.

This isn't likely a SQL issue, but a display issue. SQL Server does not remove CHR(13) from your text if you insert it with those characters in there. It is...

What do you mean by optimize here?

This sounds like a test or interview question. Please show some effort here and give us what you are looking for, why, what thoughts...

Remove a schedule from the maintenance plan or disable the job in the SQL Agent list.

What is the question here? Please write a question that better explains what you are looking for.

http://www.sqlservercentral.com/articles/Advanced+Querying/thearrayinsqlserver2000/1886/

You would need to pull all your code out of source control and do a search/replace and recompile the code.

If you feel you understand the material, give the test a try. You'll never know if you're ready until you do that. The real test is different than simulations, mostly...

I think you could possibly ignore the sheet name and it would take the first one, but I'm not sure.

Instead, I'd require the clients to specifically set a name. It's...

This sounds like a test or interview question, and you haven't really shown that you put any effort into thinking about it. Also, it's a general question.

What options are...

This isn't really a SQL Server problem, but it could be a kerberos or AD issue between the servers. Your secure channel to the domain controller might be down, or...

You could have another bug in there.

The scheduler in SQL Server manages threads just like the scheduler in the OS does, but this one managers the SQL processes. If...

This sounds like a test or interview questions, as Gail mentioned, and we don't solve those for you.

Please put in questions that you have, but show some effort to have...

If you have a question, please list it. We do not want statements only posted here. You should have asked if what you think is true and not just left...

Yep, thanks for the update. Good to know that.