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.

Use parameters in your client side code as well. Don't

Myvar.Execute "myproc " & myparam

Use the proper parameter client side methods (add to the call as methods, not concatenations) when calling...

Service accounts are administrator level functions, usually, so I, or another admin, changes the password if it's needed. So we never store them for that reason.

I also never share them....

Actually that's a great question and probably worth an article or two. If Jeff/anyone else if up for it, send me a draft. I'm sure people are intereseted. Likewise Mr/Ms...