The Below Procedure i am using to get Job Summary. but i want to get result of this proc in e-mail ( Excel File would be better).

USE [msdb]

GO

/****** Object: ...

Thanks for the link SQL RNNR.

I am trying with the query explained on your blog to execute SP but keep saying like this

Msg 22050, Level 16, State 1,...

I tired with this option but i am getting blank excel file in mail.

nice script ,

can we so setup like the result of this procedure we get in mail with excel format file?

i did try with SSIS but iw as getting blank e-mail. did not try with SSRS. if you help me in detail so can try with SSRS.

Thanks

Yes i do have SSIS ,SSRS both.

Try this hope this one helps you out.

http://www.sqldbadiaries.com/2010/12/24/the-backup-data-is-incorrectly-formatted/

thanks folks for nice reply . I did with Detach and Attach Option and it looks good now.

Wonderful that really helps me . nice explanation . Yes i am regular member of SQLSERVERCENTRAL.com but i was posting and checking stuff related to DBA only but now i...

I do have sql server enterprise installed and have some books also ,i am just confused from where to start first.

but thanks for guidence.

happy Holidays and Marry Xmas

You can download this

http://www.microsoft.com/download/en/details.aspx?id=15220

This is good documentation from Dell

http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf

You can download SQL Server 2008 Upgrade Advisor tool which is very useful tool.

You can download tool...

You should be a sysadmin to run sql agent job or you can assign this role

SQLAgentOperatorRole :members have additional permissions on local jobs and schedules. They can execute,...

did you try to kill that Session?

SQLAgentUserRole is the least privileged of the SQL Server Agent fixed database roles. It has permissions on only operators, local jobs, and job schedules. Members of SQLAgentUserRole have permissions on...

Very good script .i found which i was looking for.