Dice and Monster are very popular with recruiters, who list most of the jobs. Some private individuals on Monster. not sure if JustSQLserverJobs.com is still out there or used.

Do you mean reset someone else's password?

I don't think that specific permission exists.

Is that the same issue?

Is Litespeed installed or are you wondering about what you are about to install? I'm not sure other than the filename or the download.

I'd download again and then see if...

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...