Each time a stored procedure calls another, the nesting level increases. So if I call proc 1, I have a level of 1. If proc 1 updates table A that...

Depends on your update/insert frequency. The more often you do those the more often you might want to defrag/rebuild.

Lots of people do it weekly, some daily, some monthly.

and some never....

tedious code. Or pay for something like Data Compare from Red Gate. Might burn the $300 cost in time very, very quickly.

Can you connect from the web machine to the SQL Server using query analyzer or the data sources in ODBC?

Maybe the SQL 2000 instance is named, which means you'd need...

First, put your ON clause after the join.

from a

join b

on a.x = b.y

join c

on a.x = c.y

etc.

Next, do you want...

That is strange. I've never really been asked any strange ones. Mostly it's about me or technical ones.

I think I'd wonder about someone that asked me that question seriously. I'd...

Not sure what you mean for "recommended".

Both Litespeed and SQL Backup are good products. They work slightly different ways and are better situated in different situations.

I'd talk to both companies,...

Doh! I fixed the ad, so it's a methodology. Brian's teaching the class, so I expect the myths will be few and far between

sysjobhistory will show you where you are. sysjobs I believe shows the start time, so you can calculate the time elapsed.

Profiler monitors all activity on the server, so all queries (SELECT, INSERT, UPDATE, DELETE). If each user connect with their own login, then this will work. If they share...

You can possibly do this with xp_sendmail and authenticate to an SMTP mail server.

The other thing to explain to your network person is that you need alerts sent to you...

This is a little confusing. Are you trying to connect to sql server 2005 or sql server 2000?

Also, when you say you can connect with PHP, do you mean the...

Can you give some idea of the memory on the server and your setting? Also, do you mean that the server responds slow? That merges timeout or take too long...

What are the DB names?

Michael has good ideas. Be sure your statistics are up to date as well.