Data change event

Let's say I want to have a Web page that will be showing live data change in
a SQL table? Is it possible to have on SQL side some kind of listener that
will propogate changes to the Web page?
ThanksMarkgoldin wrote:
> Let's say I want to have a Web page that will be showing live data change
in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
I've always done the opposite, have the Web page query the database
whenever it needs to be refreshed. Even if you build a component with
ActiveX or Java it would still require the client to continually connect
to the data source to determine if there were changes. If you aren't
particular about how it works then just have the Web page refresh itself
on a regular basis, it's alot easier.
gorf|||If you are using SQL Server 2005, then lookup Query Notification in BOL. If
you are using an earlier version, then, as far as I know, you have to have
your application poll the database to look for changes.
"Markgoldin" <Markgoldin@.discussions.microsoft.com> wrote in message
news:D9064F07-0DB3-4687-B562-DF800DD8DA64@.microsoft.com...
> Let's say I want to have a Web page that will be showing live data change
> in
> a SQL table? Is it possible to have on SQL side some kind of listener that
> will propogate changes to the Web page?
> Thanks

Dangerous Bug in SSIS?

Hi,

I recently seemed to have found a major bug in SSIS packages...
Well i was just showing the new SSIS to a few work collegues when i suddenly decided to show how cool it was to be able to minimize and maximize tasks containers.

Well the bug just showed up when i maximized the container again and there it was... the Conditional precedences where gone... no more visible..

Everyone is experiencing the same problem? Solutions?
Best Regards,
Luis Sim?es

Luis,
If you try and recreate the constraints it won't let you because it says the constraints already exist.

So yes, there is a bug - but I would hardly call it major. It doesn't stop the package from running successfully.

Log it at the feedback centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||And how do i change the conditions now?

The precedences are invisible... that's bad... What if someone else must use the package?

Best Regards,|||

I had the same issue with tasks inside a sequence container. The workflow arrows appeared to be missing, but they were still there, just invisible. I got them to reappear by minimizing and then expanding the sequence container.

Not a dangerous bug, just an annoying one.

Dangerous Bug in SSIS?

Hi,

I recently seemed to have found a major bug in SSIS packages...
Well i was just showing the new SSIS to a few work collegues when i suddenly decided to show how cool it was to be able to minimize and maximize tasks containers.

Well the bug just showed up when i maximized the container again and there it was... the Conditional precedences where gone... no more visible..

Everyone is experiencing the same problem? Solutions?
Best Regards,
Luis Sim?es

Luis,
If you try and recreate the constraints it won't let you because it says the constraints already exist.

So yes, there is a bug - but I would hardly call it major. It doesn't stop the package from running successfully.

Log it at the feedback centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||And how do i change the conditions now?

The precedences are invisible... that's bad... What if someone else must use the package?

Best Regards,|||

I had the same issue with tasks inside a sequence container. The workflow arrows appeared to be missing, but they were still there, just invisible. I got them to reappear by minimizing and then expanding the sequence container.

Not a dangerous bug, just an annoying one.

Dangerous Bug in SSIS?

Hi,

I recently seemed to have found a major bug in SSIS packages...
Well i was just showing the new SSIS to a few work collegues when i suddenly decided to show how cool it was to be able to minimize and maximize tasks containers.

Well the bug just showed up when i maximized the container again and there it was... the Conditional precedences where gone... no more visible..

Everyone is experiencing the same problem? Solutions?
Best Regards,
Luis Sim?es

Luis,
If you try and recreate the constraints it won't let you because it says the constraints already exist.

So yes, there is a bug - but I would hardly call it major. It doesn't stop the package from running successfully.

Log it at the feedback centre: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

|||And how do i change the conditions now?

The precedences are invisible... that's bad... What if someone else must use the package?

Best Regards,|||

I had the same issue with tasks inside a sequence container. The workflow arrows appeared to be missing, but they were still there, just invisible. I got them to reappear by minimizing and then expanding the sequence container.

Not a dangerous bug, just an annoying one.

Damaged PDF files

Hi,
I have created a web application with ASP.Net 2.0. I also have created a
report using Reporting Services 2005. After showing the report on the
screen, I give the suer the possibility to export to report. One of the
possibilities is PDF. Now we have some troubles with this export.
On some PC's after saving or opening the PDF we got the message :
"There was an error opening this document. The file is damaged and could
not be repaired"
It only appears on some PC's, on other PC's exporting the same documents
works fine. It also didn't have any effect on the version of Acrobat. The
problems comes with Acro v 5, 7 and 8. Even after upgrading, deinstalling,
rebooting, installing a newer version the problem still exists on those PC's.
So I hope that someone have a solution for this as we don't know if it's a
problem with reporting services or with acrobat.
Txs in advance.On Apr 30, 4:36 am, Cipidos <Cipi...@.discussions.microsoft.com> wrote:
> Hi,
> I have created a web application with ASP.Net 2.0. I also have created a
> report using Reporting Services 2005. After showing the report on the
> screen, I give the suer the possibility to export to report. One of the
> possibilities is PDF. Now we have some troubles with this export.
> On some PC's after saving or opening the PDF we got the message :
> "There was an error opening this document. The file is damaged and could
> not be repaired"
> It only appears on some PC's, on other PC's exporting the same documents
> works fine. It also didn't have any effect on the version of Acrobat. The
> problems comes with Acro v 5, 7 and 8. Even after upgrading, deinstalling,
> rebooting, installing a newer version the problem still exists on those PC's.
> So I hope that someone have a solution for this as we don't know if it's a
> problem with reporting services or with acrobat.
> Txs in advance.
I've never seen this occur before; however, from what you are saying,
it seems that it is a non-Reporting Services issue. Traditionally, if
it was SSRS, then all of the machines would be behaving the same way.
It may not be related to Acrobat either; however, I'm not sure what
could be causing the problem (missing Adobe update, missing MS Office
update, etc). Sorry that I could not be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant