In SQL Server 2000, there is no default trace running unlike SQL Server 2005 and above. The query you had posted gets the information from the default trace.

In order to...

You can accomplish through the Execute SQL Task. You can write the custom sql script to meet your requirements.

For finding job details you may find this script useful.

Running sp_helplogins will give the details of all the logins on an instance.

How long did it take...

You may find these links useful

http://www.sqlservercentral.com/Forums/Topic574316-148-1.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4128e62f-92d1-4125-baa3-fdd9fed59d48

What is the output after executing the above query? Do you see any error messages?

Does the error message read out "expecting a doublecolon"? Why not put a GO keyword after each statement?

Did you try sending the message to yourself without the attachments?

How about creating a text box in the report and assigning an hyperlink to opt-out in that?

Please give the details of the error that you get while installing

Are you able to TELNET that server on the SQL server port?

telnet portnumber

I strongly feel that the content of the job has some problems. Since you have merged two maintenance plans, something has gone wrong during the process.

Could you please open the...

The order can be according to your convenience. There is no hard and fast rule as to which of these should be running first.

Login as SA or any user who has System Admin privileges on that instance. Check the permissions for that database.

If nothing has changed in this query, there is no need to change anything here. Looks like some other query which is executed prior to this is causing the dead...