Showing posts with label scheduled. Show all posts
Showing posts with label scheduled. Show all posts

Wednesday, March 28, 2012

Saving Report History

Hi all.

Im struggling with the following problem.

My company produces a report for customers on both an adhoc and a scheduled basis. This report is the same for each customer but the data is obviously different. (filtered by job number)

It is a legal requirement that we keep a copy of each report that is sent to the customer.
It is a company requirement that the data from this report can be rendered into another format.
I am limited to using RS 2000

I have found that I can satisfy the scheduled reports requirement using a data driven subscription and adhoc reporting on job number are no problem either, the problem is saving the reports data so that it can be rendered into another format.

The report history seems to be what I am looking for, as it saves reports in IF that can be rerendered but I am struggling to find a way to generate a report history both on a schedule and an adhoc basis. Am I barking up the wrong tree, is there another way of doing this?

I am not adverse to writing custom data extensions or whatever it takes. :/

Your help would be very much appreciated.

Daren Fox
You can't subscribe to history snapshots, but you can set things up so report subscriptions and history snapshots are generated simultaneously -- set the report execution properties such that a report execution snapshot is generated on the same schedule that you wanted for your subscriptions, then have all execution snapshots also be stored as history snapshots.

Friday, March 23, 2012

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.

sql

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.

Saving Auto Recovery Information

Hi

I am using the Microsoft SQL Server Management Studio to manage our database objects over a VPN connection. At scheduled intervals the system saves recovery information.

The problem is that the location of the recovery files appears to be located on a remote server. This causes the UI to completely freeze while the operation is in progress.

How can I change the location of the recovery files or turn off the Auto Recovery functionality completely.

In VS2005 this is configurable in the Tools-->Options-->Environment settings.

Thanks.

There is not configurable today in SQL 2005. We have a tracking bug for this issue.

Thanks,

Gops Dwarak

|||

Thanks for the reply.

Do you know when a fix may be released for this? Are you aware of how I can get the Enterprise Manager working on the same pc as the SQL Server Management Studio or do I need to uninstall SQL Server 2005?

Regards

David

|||

Enterprise manager and SQL Server Management studio can be run side by side on the same box. Answer is, you do not need to uninstall SQL 2005 to get Enterprise Manger working.

On the fix for the Autorecovery, it is planned to be fixed in next service pack. We are in planning stage for next service pack and to not have dates for this release now.

Thanks,

Gops Dwarak, MSFT

|||

I haven't tried this but this registry mod should disable AutoRecovery. If it doesn't work let me know and I'll dig a bit deeper. All the standard disclaimers about registry manipulation apply.

Go to HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\General\AutoRecover and change the “AutoRecover Enabled” value to zero.

|||

Bruce,

I have tried your fix on an XP SP2 machine and it seems to have worked. The only thing was that the reg key path for me (using SQL Server Management Studio Express) was:

HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\General\AutoRecover

Thanks.

|||

Hi everybody.

I'm having the same problem in Microsoft Visual Studio 2005, Version 8.0.50727.42 (RTM.050727-4200)
Microsoft .NET Framework Version 2.0.50727 but not only the IDE freezes when saving autorecovery information but also when saving any modified file.

Do you guys know of a thread like this related to this issue? Any ideas?

Thanks a lot!

|||

Hi,

I have the same problem.

There is a conflict between the antivirus and the source control.

I did not find a solution yet. Does somebody have an idea?

Thanks.