external image not rendering when generated from aspx page

I'm having problems displaying images generated by aspx pages from a report. It works fine if I point the external value to a static image on the web. I can paste the url to the page into IE and it generates the image with no issues. What am I doing wrong? I used a textbox to verify that the correct url is being generated (= Parameters!MYPROJECT_URL.Value & Parameters!MYPROJECT_NO.Value).

Are there any issues with generating external images with reporting services?

I have installed SP1 for MS 2005...shouldn't I see some sort of visual confirmation in Management studio when I click the Help Menu->about? saying the version is MS SQL Server 2005? how do I verify that the upgrade was successful?

You can check if the upgrade is successful from the error logs, they contain the build number on the top.

|||Check if ASPX pase generate the image have anonymouse accesssql

Extended Events (XEvent) in Katmai

In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are.

Thanks.

This needs to be posted in the Katmai forum instead of here; hang on and I'll see if I can move it.

|||

Thanks for moving the post - I didn't know there were dedicated Katmai forums.

I found some of what I'm looking for in SQL Server 2008 Books Online->Database Engine->Operations->Monitoring->SQL Server Extended Events.

I would appreciate any other pointers.

Thanks again.

|||

I suspect that what is in Books Online is the only content available at this point. The How-to topics in the Books Online section you reference do contain quite a few examples. If you have specific questions, I recommend posting them in the SQL Server Katmai Manageability & Tools or SQL Server Katmai Database Engine forums.

Also, I strongly encourage you to click the Feedback button on any of the extended event Books Online topics and provide comments/suggestions for those topics that need more details or examples. You may or may not get a direct response from the writer, but the writer will receive your comments in the form of a documentation bug. We rely on customer feedback to know which topics need to be improved.

Regards,

Gail

|||

Check out the Books Online for the examples...

http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=7460

Extended Events (XEvent) in Katmai

In this blog posting: http://blogs.msdn.com/tvoellm/archive/2007/08/02/check-out-xevent-in-sql-2008-ctp2.aspx Extended Events are mentioned. The author says that the documentation has lots of examples. I can't find them. I would be grateful to anyone who can tell me exactly where they are.

Thanks.

This needs to be posted in the Katmai forum instead of here; hang on and I'll see if I can move it.

|||

Thanks for moving the post - I didn't know there were dedicated Katmai forums.

I found some of what I'm looking for in SQL Server 2008 Books Online->Database Engine->Operations->Monitoring->SQL Server Extended Events.

I would appreciate any other pointers.

Thanks again.

|||

I suspect that what is in Books Online is the only content available at this point. The How-to topics in the Books Online section you reference do contain quite a few examples. If you have specific questions, I recommend posting them in the SQL Server Katmai Manageability & Tools or SQL Server Katmai Database Engine forums.

Also, I strongly encourage you to click the Feedback button on any of the extended event Books Online topics and provide comments/suggestions for those topics that need more details or examples. You may or may not get a direct response from the writer, but the writer will receive your comments in the form of a documentation bug. We rely on customer feedback to know which topics need to be improved.

Regards,

Gail

|||

Check out the Books Online for the examples...

http://connect.microsoft.com/SQLServer/Downloads/DownloadDetails.aspx?DownloadID=7460

Exporting Stored Procedures

I have to retrieve all the stored procedures in a certain database via a aspx page. My problem is that I have basically no idea how to do it. I did manage to get all the data as XML and reconstruct the database (pain). All I need now (I hope) is the sprocs. I do not have any other access to the database. And I'm a novice with SQL Server. Any guidance is appreciated.

SteveSomething like:

select text
from syscomments
where text like 'create procedure%'

|||Thank you very much.

I also have to restore the sprocs. Should I select all the columns in syscomments and sysobjects for the relevent rows and insert them into the new db? Will that do it?

Thanks again,

Steve|||NO, I do not recommend this approach.. Why are you looking to perform these activities through an asp.net application?|||I have a client with a developer problem. They asked me to coordinate with the developer to facilitate moving the site. Despite the developer's statements that I could access the SQL Server, he only gave me FTP access to the site. Eventually, I find out that he is intentionally being difficult, refusing to assist unless the client paid him more money. Apparently a _lot_ more money. I found in his connection code where he recently changed the pw to the database, to something other than what he told me. I assume the developer is being unreasonable to the point where it is cheaper to have me do it the "hard" way. Oh yeah, this is a classic ASP app, which I have no experience with either.

So... I had to use an aspx page to get the data via XML. Easy enough, but restoring it was a bit more challenging. I finally have the tables restored properly; now all I need is the stored procedures (I hope).

I did get the procedures (thanks again), however I had to get all the rows because none of the sprocs begin with the string you suggested, and I'm wanderin' around in the dark.

I'm amazed I've accomplished what I have. It's a good thing .NET is so smart. :)

Steve|||Thanks to your help, I was able to completely reconstruct the database!

I had to manually re-add the stored procedures, views & triggers I got from your suggestion. In the end, it was the easiest way.

Thanks again,

Steve

exporting sql 2005 table to access

Hi All

what is the best way (and how please) to export one table from sql 2005 table to access table with aspx 2.0 NET

thanks

daniel cohen

wrong forum.

try this one instead: http://forums.asp.net/54/ShowForum.aspx