Showing posts with label std. Show all posts
Showing posts with label std. Show all posts

Thursday, March 8, 2012

Data-driven subscriptions - SQLRS Ent vs Std

I want to use data-driven subscriptions but cannot create one - the "New
data-driven subscription" button does not appear in Report manager. I
believe this may be because I'm running SQLRS Standard - can someone confirm
this please?
If true, is there an easy way to upgrade to SQLRS Enterprise or do I have to
uninstall Std and do a fresh install of Enterprise? Is there a way to save
and restore all my subscriptions?
thanks
PeterThe data Driven Subscriptions are only part of the enterprise version. I
don't think you have to uninstall to put in the entprise license. It won't
affect your subscriptions.
Stuart
"PeterB" wrote:
> I want to use data-driven subscriptions but cannot create one - the "New
> data-driven subscription" button does not appear in Report manager. I
> believe this may be because I'm running SQLRS Standard - can someone confirm
> this please?
> If true, is there an easy way to upgrade to SQLRS Enterprise or do I have to
> uninstall Std and do a fresh install of Enterprise? Is there a way to save
> and restore all my subscriptions?
> thanks
> Peter|||From Microsoft Website
Evaluation, Developer, or Enterprise Edition of SQL Server 2005. Support for data-driven subscriptions is not available in Standard, Workgroup, or SQL Server Express Editions. For more information, see Features Supported by the Editions of SQL Server 2005.
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Wednesday, March 7, 2012

Databse is lost

Hi,
I am using windows server STD 2003, with SP1, with SQL server 2000 with SP1.
The database stops working almost every 24 hours. I have to stop/kill
services and then start again to get it back up.
Kindly advise.
ThanksYou would want to start by checking the SQL Server error
logs and the Windows event logs. There should be something
logged to give you some clues as to what is going on with
your SQL Server.
-Sue
On Mon, 15 May 2006 22:35:01 -0700, Al Gates
<AlGates@.discussions.microsoft.com> wrote:

>Hi,
>I am using windows server STD 2003, with SP1, with SQL server 2000 with SP1
.
>The database stops working almost every 24 hours. I have to stop/kill
>services and then start again to get it back up.
>Kindly advise.
>Thanks