Is it installed on local machine or remote server?

Try out this way

go to C:\Users\\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell

and rename regsvr.xml to some other name for ex. regsvr_old.xml

Now open Management studio , it will create new regsvr.xml and than...

check out this link may be helps to solve your issue

http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ310834

obtain the latest service pack for Microsoft SQL Server version you installed

from an SSMS query window. go to Query, Query Options, Execution. What is the value for Execution time-out?

Open the Management Studio, click on the “Help” of Menu Bar and then on “About”. A new window will appear, where you will see some thing like if you...

Did you solve this error ? I am getting this error too and i am working on it. please let me know if you found any solution please.

You can check out from here also

« SQL SERVER – Recycle Error Log – Create New Log file without Server RestartSQLAuthority News – SQL Server Denali CTP1 – Release...

SQL Server 2008 R2 (RTM build 10.50.1600) is the second release of SQL Server 2008 (SP1: 10.0.2521. It is considered to be a minor version upgrade of SQL Server 2008....

worked with this options

,@attach_query_result_as_file = 1

,@query_attachment_filename ='Results.xls'

but data in file is not in particular order or the result in excel file can not see like...

Yes it works for me too now ..Thanks RNNR... but result in e-mail so weired format..

Can we do in excel format ?

yes my dbmail profile works fine...you can check the error message in above posts.

Yes it is there..i executed and working fine in SSMS

Here is nice articles that you can check

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'My Profile' ,

@recipients = 'My email ADD' ,

@subject = 'Job Summary'

,@query...