resize the multi select drop down

I need to resize (increase the width of) the multi select drop down box in report manager. Has anyone had any luck doing this?The width is not configurable. This is a suggestion I have seen several times and it is under consideration for future versions of the Reporting Services product.

resetting database

hi!
i'm new to sql server and enterprise manager and i accidentally deleted all data in a table. how do i recover them? the table (CaptureManager) is still there but empty. i have the following information:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CaptureManager]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CaptureManager]
GO

CREATE TABLE [dbo].[CaptureManager] (
[ID] [tinyint] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [varchar] (75) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ext] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO

The easiet way is to restore the database from backup and do INSERT INTO the old table which means everything remains the same you just return the deleted data. The Backup and restore Wizard lets you restore the database with any name you like. Hope this helps.|||unfortunately, i dont have a backup.|||If you buy some expensive log viewing software you may still have the original inserts logged. But really the chance of getting your data back is pretty minimal. I guess it's called learning by your mistakes, sorry :(
|||Try this link to test drive some tools. Hope this helps.
http://www.sql-server-performance.com/greg_robidoux_interview.asp

Reset Report Manager

I've done something bad that prevents Report Manager from running. Every time I try to call it up in a browser, I get error messages complaining about a null object.

Is there a way to get the report manager to "start fresh"? For example, would deleting the entries in the catalog table do the trick.

Thanks for any help.

What exception do you see in the report server log file?|||

The log shows:

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\ReportServerWebApp__04_18_2006_07_52_53.log</Path>
<SystemName>MERCURY</SystemName>
<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>
<OSVersion>5.2.3790.65536</OSVersion>
</Header>
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!4/18/2006-07:52:54:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!1!4/18/2006-07:52:55:: Unhandled exception: System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

|||

I found my problem.

I had authentication mode set to "None" in web.config. As soon as I changed it to "Windows" the problem went away.

Requsting advice on nightly backup

This is our current schedule for SQL backup:
Backups created by Enterprise Manager
Nightly backup 12:00midnight - Complete backup checked, Transaction Log Backup not checked
Weekly optimization on Saturday - Optimization and Ingetrigy checked.
Transaction Logs Every hour 8am to 9pm - Transaction Log Backup checked.
Is it overkill to include the Transaction Log backup on our Nightly backup ?
Thanks
--
Message posted via http://www.sqlmonster.comHi Jeffrey,
If you are ending transaction log backup at 9 PM and want to take
transaction log backup again at midnight, it will have 3 hrs of transactions.
But you are anyways taking full back up at midnight. I do not understand why
you want to take nightly transaction log backup.
If my understanding is wrong, please update me with more information.
--
Thanks
GYK|||Hi GYK,
I don't want to do transaction logs again. Sorry a bit dizzy doing this backup plan. You confirmed what I was second guessing that if I have 3 hours of transactions between 9pm and 12 (which is rare) they would be part of the complete backup at midnight with no need for the TRN backup.
Thanks
Jeff
--
Message posted via http://www.sqlmonster.com|||Keep in mind that the FULL and DIFFERNTIAL database backups are independent
from the LOG transaction log backups.
The transaction log will not remove transactions from the files until after
a transaction log backup is performed if you are running any recovery mode
except simple. A FULL nor a DIFFERENTIAL database backup does NOT remove
transactions from the transaction log regardless of the recovery model.
Sincerely,
Anthony Thomas
"Jeffrey Sheldon via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:418f0f5db2de404da1b2043e344372d5@.SQLMonster.com...
Hi GYK,
I don't want to do transaction logs again. Sorry a bit dizzy doing this
backup plan. You confirmed what I was second guessing that if I have 3
hours of transactions between 9pm and 12 (which is rare) they would be part
of the complete backup at midnight with no need for the TRN backup.
Thanks
Jeff
--
Message posted via http://www.sqlmonster.com

Repot Manager Hangs

This happens very frequently on our server and I can't determine the cause.
The basic issue is that SRs gets into a state where it hangs, you can't
render reports,you can't even vire proprties, navigate folder etc, so I know
its not extenal data sources.
One things I tried was disabling Script Blocking which was enabled on our
antivirus. This is mentioned in this Kb:
http://support.microsoft.com/kb/295375/en-us
I also set the IIS Idle rest to 8 hours. But that wasn't the initial issue.
I've been looking at perfmon (thread counts, pages\sec, disk queues, working
set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
I appreciate any addiional info on things to try.
Thanks,
-pWhat version?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> This happens very frequently on our server and I can't determine the
> cause.
> The basic issue is that SRs gets into a state where it hangs, you can't
> render reports,you can't even vire proprties, navigate folder etc, so I
> know
> its not extenal data sources.
> One things I tried was disabling Script Blocking which was enabled on our
> antivirus. This is mentioned in this Kb:
> http://support.microsoft.com/kb/295375/en-us
> I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> issue.
> I've been looking at perfmon (thread counts, pages\sec, disk queues,
> working
> set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> I appreciate any addiional info on things to try.
> Thanks,
> -p|||SQL 2005 w/ latest SPs and fixes.
"Bruce L-C [MVP]" wrote:
> What version?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Peaboy" <Peaboy@.discussions.microsoft.com> wrote in message
> news:96C28CF8-0A0B-4C75-9811-5884A172385E@.microsoft.com...
> > This happens very frequently on our server and I can't determine the
> > cause.
> > The basic issue is that SRs gets into a state where it hangs, you can't
> > render reports,you can't even vire proprties, navigate folder etc, so I
> > know
> > its not extenal data sources.
> >
> > One things I tried was disabling Script Blocking which was enabled on our
> > antivirus. This is mentioned in this Kb:
> > http://support.microsoft.com/kb/295375/en-us
> >
> > I also set the IIS Idle rest to 8 hours. But that wasn't the initial
> > issue.
> >
> > I've been looking at perfmon (thread counts, pages\sec, disk queues,
> > working
> > set, etc.) and I'm not seeing some obvious resource constraint\bottleneck.
> >
> > I appreciate any addiional info on things to try.
> >
> > Thanks,
> > -p
>
>