Is it a 'good and safe' practice to update the system tables in the msdb?

No! I would stay away from it unless being told so and guided by Microsoft PSS.

They will be nicely executed one after the other.

To a certain extend you can read about it on BOL at CREATE TABLE under the Temporary Table section.

Just be aware of this:

http://support.microsoft.com/default.aspx?scid=KB;en-us;291332

What about http://www.solidqualitylearning.com/default.aspx?lang=en ?

There are quite a few very knowledgeable people among their mentors

http://www.solidqualitylearning.com/aboutUs.aspx

See, if this helps:

http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part3/c1161.mspx

They error message is pretty self-describing. Index ID=1 means the clustered index is rebuild. That in turn could mean that all non-clustered indexes are also internally rebuild. Depending on how...

If I see this right, you want to query for a specific month, right?

If so, why extract dateparts and convert anyway? You could also query for something like this:

WHERE

 < your...

Another one:

SELECT REPLACE(STR(DATEPART(mm,GETDATE()),2), ' ', '0')

Well, while I somehow believe your data model has some kind of flaw, you might want to have a look at

http://www.sommarskog.se/dynamic_sql.html

http://www.sommarskog.se/arrays-in-sql.html

http://www.sommarskog.se/dyn-search.html

Should give you some ideas how you...

Either DBCC CHECKDB or DBCC CHECKCATALOG.

I would also look for any entries in log files, check for hardware issues. Since the index ID is 12 this is a non-clustered index....

sp_spaceused?

I said, the example isn't the best

Either that way or to try and avoid the UDF completely. However, you might want to read...

Sorry, UDF stands for User-Defined Functions.

And no, you shouldn't get rid of them, but rather carefully evaluate your alternatives given.

While this is not the best example, it demonstrates...

Okay, I hope I didn't get lost inside your queries, but to me it seems that you need to include the test for Error1 !='' in the WHERE clause. And...