Search Results | SQL Server Performance Forums

need help to automate my report using database mail fin in SQL 2005

Post by: Kohila, Oct 7, 2009 in forum: SQL Server 2008 General Developer Questions

Hi Mani, I have completed my report successfully now. Many thanks[:)]

need help to automate my report using database mail fin in SQL 2005

Post by: Kohila, Oct 6, 2009 in forum: SQL Server 2008 General Developer Questions

Hi Mani, Can i have your advise as how i can add a message in the top of my email. No of open session : 53(this value should ge get from table by...

need help to automate my report using database mail fin in SQL 2005

Post by: Kohila, Oct 5, 2009 in forum: SQL Server 2008 General Developer Questions

Yes now it work, I have done some mistakes in the declaration part.

need help to automate my report using database mail fin in SQL 2005

Post by: Kohila, Oct 5, 2009 in forum: SQL Server 2008 General Developer Questions

Hi Mani, Yes i tried out this below by using the ISnull,but instead of 'blank' value '1900-01-01T00:00:00' value is dispalyed.select B.EIN , B.OUC ,...

need help to automate my report using database mail fin in SQL 2005

Post by: Kohila, Oct 2, 2009 in forum: SQL Server 2008 General Developer Questions

Also my login date and logout date is displayed like 2009-10-02T08:09:35.143. What to remove the T. This is not present when i execute the query in...

need help to automate my report using database mail fin in SQL 2005

Post by: Kohila, Oct 2, 2009 in forum: SQL Server 2008 General Developer Questions

Hi Mani/Satya Many thanks for your assistance. Now i am able to generate the report with HTML format... But still..i am finding an answer how to...

need help to automate my report using database mail fin in SQL 2005

Thread by: Kohila, Sep 29, 2009, 10 replies, in forum: SQL Server 2008 General Developer Questions

Hi SQL Experts, I am tring to send a automated email to my client with daily report using the database mail functionality in the SQL server 5000....