The statement looks good to me. Can you send any other mails with db mail ? Is the profile configured correctly ? Try sending a testmail.

Markus

Unfortunately I can't see the error messages so I have to guess about the errors. What you should do is first make sure that there is a login for N800\harihan_lavanya...

Ivan,

the fact that SQL Agent grey's out the Test button seems to be some bug in Management Studio, I have the same problem even after installing SP1.

About SQL Agent not...

Gex,

Can you post your statement plz. It's hard to tell what's wrong without knowing your exact statement. Personally I don't have any problems using the @query parameter.

Markus

Is it possible that your backup file contains more than one backup ? It sounds to me like one of those classical cases where you have two or more backups...

Hi Folks,

as always as soon as you post a problem, suddenly you find the answer. The version is registered in the table sys_config, and somehow the information from this...

Carl,

I can't check it now (no SQL2005 server at hand), but most system tables/views in 2005 are in the sys schema and you have to call them like sys.properties.

Markus

Hi Joe,

thanks for your reply. All the jobs are running fine. The databse is in full recovery mode and transaction log backups are made every hour. The memory (4gb) is...

Dave,

have you tried running DBCC CHECKALLOC ? In my experience errors in checkdb are most of the time related to disk errors.

Also at http://www.sqlfe.com/ you find a utility which enables...

Santhosh,

Exec sp_helptext 'sys.fn_get_sql'  will give you the code for this function, but I don't understand why you would need that.

Markus

Ernie,

did you check that the name of your Excel sheet is actually Sheet1. If you use a non-english version of Excel for example, the sheet will have a different name.

Markus

To be honest, I haven't had alook at sp_blocker_pss80 and who to integrate fn_get_sql_handle but maybe you can find some ideas in this article. http://vyaskn.tripod.com/fn_get_sql.htm

Markus

Derek,

I don't think you can script the actual maintenance plan, but you can script the job(s) created by the maintenance plan. Go to SQL Agent\Jobs and select script job as...

You could use fn_get_sql. This way the statement won't be truncated.

DECLARE @handle binary(20)

SELECT @handle = sql_handle

    FROM master..sysprocesses

    WHERE spid = @@SPID

SELECT [text]

   ...

Dave,

one thing to keep in mind when using different collations on one server is the fact that the tempDB will always have the default server collation. This can cause errors...