Thanks John.

Hi All,

Thank you for your replies. It worked. Now I need to do the same thing for views and functions also. I need to script...

can i use SQL DMO inside ASP.NET? I do not have any idea about SQL DMO. will it allow to pass variables? can you give me a sample?

Thanks,

Sridhar.

No I need the output in the format

store week sales

A sep-week3 100.00

B ...

Hi Keith,

I would like to try the sql option but I didn't understand exactly what you said. I have a table called store_sales....

As I said before I don't have DBA permissions to the database. So I cannot execute xp_sendmail.

Thank you all. The problem is I don't have speakers to my computer in work. so I was trying to find a solution that would display like a pop-up window...

Hi Dilip,

Thank you very much for the reply. I am not a DBA. So I am not sure whether I can put this...

Thank you All

Thanks Remi Gregoire. The whole purpose of displaying it single rows is to copy it and paste in the excel. so I want each column name in a separate column...

Thank you.

Hi,

Thanks for the reply and advise. we are using asp.net datagrid to display the results. And it seems that we cannot do that functionality in datagrid....

Hi All,

Thanks for the reply. This is for reporting in ASP.Net DataGrid. I am still not sure how to use just one table. Could you explain in...

Hi All,

Thanks for the replies. It worked. Here is the situation why I am using Dynamic Sql. If there is another approach to this please...

Hi,

I tried by right clicking on selected portion and changing font. But it is changing font color for the whole script not just for the selected portion....