disks when doing mirroirng

Hi,
I'm using SQL 2005 with 2 identical servers
I want to use Mirroring between the two.
I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
services)
each server has 6 disks.
what is the best configuration of these disks ?
3 RAID1, 1 RAID1 + RAID5 ?
and where should i put things ?
e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
If all drives are the same size and type, for fault tolerance:
1- Mirror of two disks for OS and SQL Server
2- Create two mirrors (2 drives each) and then create a stripe with parity
between both mirrors (RAID 0). I will put the data and log files there.
This way, you can have 3 failed disks (one failed disk on each mirror) and
the system will still be online. Also RAID 0 will give you better performance.
Another option would be to create a RAID 5 with for the data and the files,
which will give you a good performance for reads (not as good for wites..)
and you will be having more space for storage for the data and the logs,
compared with the first option
"raviv762@.gmail.com" wrote:

> Hi,
> I'm using SQL 2005 with 2 identical servers
> I want to use Mirroring between the two.
> I'll have on both SQL Engine, SSIS & Reporting services (no Analysis
> services)
> each server has 6 disks.
>
> what is the best configuration of these disks ?
> 3 RAID1, 1 RAID1 + RAID5 ?
> and where should i put things ?
> e.g. OS, data files, log files, tempDB, reporting services, SSIS ..
>

Disconnected Edit in SSIS 2005

Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in SQL
Server 2005 Integration Services ? If so, What ?
Thanks.In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:
> In SSIS you can accomplish editing packages without a connection to the SQL
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the folder
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> > Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> > SQL
> > Server 2005 Integration Services ? If so, What ?
> >
> > Thanks.
>
>

Disconnected Edit in SSIS 2005

Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in SQL
Server 2005 Integration Services ? If so, What ?
Thanks.In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:

> In SSIS you can accomplish editing packages without a connection to the SQ
L
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the fold
er
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio
or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
>
>

Disconnected Edit in SSIS 2005

Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in SQL
Server 2005 Integration Services ? If so, What ?
Thanks.
In SSIS you can accomplish editing packages without a connection to the SQL
Server Several different ways.
If you are using file system deployment you can just make sure that your
development folder for the dtsx files is something different then the folder
that the agent is executing packages from.
If you are using SQL Server deployment then every package that you are
working is essentially disconnected. You have to deploy it to the sql
server using the deploy option inside of the business intelligence studio or
a package installer.
In both cases, you do not need any type of connection to the SQL server
until you deploy. You will lose some niceties that way since you cant
connect to get column or table info.
Make sense?
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/
"DXC" <DXC@.discussions.microsoft.com> wrote in message
news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
> Is there a match for SQL Server 2000 DTS Package "Disconnected Edit" in
> SQL
> Server 2005 Integration Services ? If so, What ?
> Thanks.
|||No it doesn't. Here is why,
I imported a DTS package from a SQL Server 2000 server to 2005 Integration
services on another SQL Server 2005 computer. Regardles of where I open it,
it takes at least 20 second to scroll the horizantal bar 1 inch. I am
assuming that it is trying to check the resources/connections even though
they don't exists on the new server. This is why I thought that disconnected
edit may help to speed editing the DTS package or the SSIS package since it
has been converted..........
Thanks.
"Warren Brunk" wrote:

> In SSIS you can accomplish editing packages without a connection to the SQL
> Server Several different ways.
> If you are using file system deployment you can just make sure that your
> development folder for the dtsx files is something different then the folder
> that the agent is executing packages from.
> If you are using SQL Server deployment then every package that you are
> working is essentially disconnected. You have to deploy it to the sql
> server using the deploy option inside of the business intelligence studio or
> a package installer.
> In both cases, you do not need any type of connection to the SQL server
> until you deploy. You will lose some niceties that way since you cant
> connect to get column or table info.
> Make sense?
>
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> Tech Blog - www.technologyis.com
> */
>
> "DXC" <DXC@.discussions.microsoft.com> wrote in message
> news:32FB5B16-0012-4DD8-98CF-E52CF07BB77C@.microsoft.com...
>
>
sql

Disaster Recovery Scenarios for Analysis Services

Hi

I am trying to find disaster recovery scenarios for Analysis Services which seems to be lacking. Is there anything documented.

Thanks

Steve -

I am not aware of any disaster recovery document that talks specifically about Analysis Services.

The bits and pieces of disaster recovery information are scattered in Books Online: you might look in Backup/Restore, Failover Clustering, server sync… But I don’t see any one topic in BOL that brings it all together.

I asked members of the Analysis Services team and they said the same thing.

Thanks,

Don

|||I thought as much. Thanks for asking.|||Which version of Analysis Services?

Disappearing parameter values

I have an ASP.NET application with a page which has a Reportviewer control
linked to a Reporting Services report on a Remote Server. I pass parameters
into it OK including the name of the database which is then referenced by a
dynamic connection string. The database is the first parameter. Other
parameters have dropdown lists based on datasets using the dynamic connection
string.
All of this works fine, but...
When I hide some of the parameters, because I know what value is required,
the value is not acceoted, nor does the report use the default value. It is
as though hiding the parameter prevents the list of available values being
requeried; consequently the passed in value is ignored as it does not match
an available value!
Can anyone help please?
Thanks
GeorgeGeorge,
I assume you are setting the Visible property of some web control that
holds the value of your report parameter. You should set the Visibility
Style of the control to 'hidden' so that it still gets rendered into the web
form but is not 'seen' in the web browser. This way the controls value is
still within the form and viewstate when the form is posted back.
Hope I made the correct assumption and this helps.
thx
-jsh
"George Davies" wrote:
> I have an ASP.NET application with a page which has a Reportviewer control
> linked to a Reporting Services report on a Remote Server. I pass parameters
> into it OK including the name of the database which is then referenced by a
> dynamic connection string. The database is the first parameter. Other
> parameters have dropdown lists based on datasets using the dynamic connection
> string.
> All of this works fine, but...
> When I hide some of the parameters, because I know what value is required,
> the value is not acceoted, nor does the report use the default value. It is
> as though hiding the parameter prevents the list of available values being
> requeried; consequently the passed in value is ignored as it does not match
> an available value!
> Can anyone help please?
> Thanks
> George|||Thanks jsh for replying so promptly
I'm not sure I've explained the problem correctly, as I could not find the
Visibility Style for the control as you suggested. I am using RS2005 and
ASP.NET 1.1 with a ReportViewer control linked to a deployed remote report.
But I think you may be on to something as the problem does not arise when
designing the report, nor in Report Manager, only when I run it from within
the ASP ReportViewer control as a Remote Report.
The parameter is passed into the Reporting Services report OK, but when the
Report Server processes the parameters it first takes the name of the
database as the first parameter, then it recognises that there are cascading
parameters because the dropdown lists require data from tables which have
been queried using the dynamic connection string. At this point it seems to
assume that because it is going to refresh the dropdown lists that it can no
longer rely on the selections supplied in the other parameters and scrubs
them i.e. it insists that the user rekey each of the parameter values
wherever the dropdown lists use the dynamic connection string.
This causes two problems:
1 When I want a parameter value hidden, it is impossible to set it and the
report fails with e.g. "Parameter zzz does not have a value". I could get
round this by using two parameters for each value, one for when I want to
force the parameter to be a certain value and hide it with no associated
dropdown list, and one for when I want to show it and ask the user to pick
from a list. Messy, but I could get the report SQL to test for either of the
values in the two parameters. But this still leaves problem number 2...
2 When cascading parameters are used, each time the user picks a value, it
postbacks to the server. This is not very clever of Reporting Services. It
should post back when the value for a parameter is changed where that
parameter is used by other parameters, not when a parameter changes which
uses the value from another parameter.
The long and short of it is that with eight parameters, the selection of
report options is excruciatingly slow and won't be acceptable to my users.
If you or anyone else can shed any light on this problem, I would be really
grateful.
Thanks again and best wishes
George
"jsh02_nova@.hotmail.com" wrote:
> George,
> I assume you are setting the Visible property of some web control that
> holds the value of your report parameter. You should set the Visibility
> Style of the control to 'hidden' so that it still gets rendered into the web
> form but is not 'seen' in the web browser. This way the controls value is
> still within the form and viewstate when the form is posted back.
> Hope I made the correct assumption and this helps.
> thx
> -jsh
> "George Davies" wrote:
> > I have an ASP.NET application with a page which has a Reportviewer control
> > linked to a Reporting Services report on a Remote Server. I pass parameters
> > into it OK including the name of the database which is then referenced by a
> > dynamic connection string. The database is the first parameter. Other
> > parameters have dropdown lists based on datasets using the dynamic connection
> > string.
> >
> > All of this works fine, but...
> >
> > When I hide some of the parameters, because I know what value is required,
> > the value is not acceoted, nor does the report use the default value. It is
> > as though hiding the parameter prevents the list of available values being
> > requeried; consequently the passed in value is ignored as it does not match
> > an available value!
> >
> > Can anyone help please?
> >
> > Thanks
> >
> > George

disabling the SQL Server Service (2005)

Hello:
I know that there are times when certain SQL services, like the browser
service, can be disabled when the service is not needed.
I recently read somewhere that there are times when one would want to
actually disable the SQL Server service. Why is that? Isn't the Server
service the service that runs the database engine?
Thanks!
childofthe1980s> Isn't the Server
> service the service that runs the database engine?
Correct. The only reason I can see is if you don't *want* to start the SQL S
erver instance for some
reason, and don't want to be able to start it by mistake...
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in messa
ge
news:26F95D22-EFA0-485F-8E29-A426AF4122EC@.microsoft.com...
> Hello:
> I know that there are times when certain SQL services, like the browser
> service, can be disabled when the service is not needed.
> I recently read somewhere that there are times when one would want to
> actually disable the SQL Server service. Why is that? Isn't the Server
> service the service that runs the database engine?
> Thanks!
> childofthe1980s

disabling the SQL Server Service (2005)

Hello:
I know that there are times when certain SQL services, like the browser
service, can be disabled when the service is not needed.
I recently read somewhere that there are times when one would want to
actually disable the SQL Server service. Why is that? Isn't the Server
service the service that runs the database engine?
Thanks!
childofthe1980s> Isn't the Server
> service the service that runs the database engine?
Correct. The only reason I can see is if you don't *want* to start the SQL Server instance for some
reason, and don't want to be able to start it by mistake...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"childofthe1980s" <childofthe1980s@.discussions.microsoft.com> wrote in message
news:26F95D22-EFA0-485F-8E29-A426AF4122EC@.microsoft.com...
> Hello:
> I know that there are times when certain SQL services, like the browser
> service, can be disabled when the service is not needed.
> I recently read somewhere that there are times when one would want to
> actually disable the SQL Server service. Why is that? Isn't the Server
> service the service that runs the database engine?
> Thanks!
> childofthe1980s

Disabling Export to Excel Sheets In MS SQL Reports 2005

Hello All,

Can i disable export to Excel sheet in ms sql server 2005 reporting services.

This is due to security reasons as the client doesnt want the reports to be send via mail.

Can someone provide the solution on how to disable export to excel

Thanks

Pritam Shetty

Look at the article here:

http://msdn2.microsoft.com/en-us/library/ms156281.aspx

This will only disable the option in the Report Manager, URL access will be still allowed.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I'm a little concerned about something...

>>

This is due to security reasons as the client doesnt want the reports to be send via mail.

<<

Disabling export doesn't prevent the reports from being sent email. Someone can still select the text on the page and dump it into an e-mail message from the HTML version, or Save the page As and attach the result to an email.

>L<

|||

Hello Lisa,

Indirectly i will be disabling all the options.

As of the copy paste thing the clients are ok with it.

But They have just asked to disble the export feature.

So i m just going with it as of now

Thanks & Regards

Pritam Shetty

Disabled or Locked Date Parameters

Hi
I'm fairly new to Reporting Services. We have three or four parameters in
our reports. The FirstDate and LastDate parameters (datetime) are disabled
or locked until we fill in information in the other parameter fields. If the
date parameters are first in the list, they are not disabled or locked. But
we would like them to be last most of the time. Is there a way to "unlock"
them so they are enabled when the report is run instead of having to fill out
the other parameters first?
TIA
MarieJOn Apr 19, 8:08 am, MarieJ <Mar...@.discussions.microsoft.com> wrote:
> Hi
> I'm fairly new to Reporting Services. We have three or four parameters in
> our reports. The FirstDate and LastDate parameters (datetime) are disabled
> or locked until we fill in information in the other parameter fields. If the
> date parameters are first in the list, they are not disabled or locked. But
> we would like them to be last most of the time. Is there a way to "unlock"
> them so they are enabled when the report is run instead of having to fill out
> the other parameters first?
> TIA
> MarieJ
As long as they are not dependent on preceding report parameters, they
should not appear locked. Make sure that the datasets that are
sourcing the parameters are not dependent on the wrong parameters
themselves. To check this, select the Data tab and select the correct
Dataset name from the drop-down list and select the Edit Selected
Dataset [...] button and then check the parameter mappings of the
dataset via the Parameters tab. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Disable Totals in Cube Browser

Hi there,

Does anyone know of a way to disable the subtotal column in Analysis Services 2005 cube browser?

Dave

Unfortunately, I don't think you can turn totals off. Is there a particular reason why you want to (keeping in mind that the cube browser in BI Dev Studio and in SSMS are really only for developer/administrator use)?

Dave Fackler

disable the service manager

Is there anyway I can disable the service manager from running. I have a
sql server that several users connect to via terminal services and they all
get the service manager in the system tray. I want to remove this but don't
know how.It's probably in the Startup group for the Default User. Simply remove it's
shortcut from Startup
--
HTH
Ryan Waight, MCDBA, MCSE
"sarah" <sarahkingswell@.hotmail.com> wrote in message
news:OgtXgxBjDHA.3264@.TK2MSFTNGP11.phx.gbl...
> Is there anyway I can disable the service manager from running. I have a
> sql server that several users connect to via terminal services and they
all
> get the service manager in the system tray. I want to remove this but
don't
> know how.
>

Disable the "All" option in a parameter

Does anyone know how to disable the option "All" in a parameter which is in a 2005 reporting Services Report based on a 2005 AS Cube?

Thanks in advance,

Pieter

The only way I found, is to build another dataset based on sql query returning the same data.
Regards
Ayzan
|||

Thanks for your reply

This is not a good option because the options given in the parameter have to be limited by the role which the cube user is in.

But thanks anyway.

Pieter

|||

If your roles are correctly set, the "All" option will displays informations for all the items your user can access.

Regards

Ayzan

|||

Yes that is correct, but it does not give me the solution for my problem.

From Microsoft I got this information: "The <Select All> option in the parameter drop down is only a UI item. This will be removed with the SP1 release. "

So 'll wait for the SP I guess!

Thanks for your help!

Disable Right Click?

Is there anyway to disable mouse right click events in Reporting Services
Reports?
I am using RS 2005.
On custom web pages, I can either use javascript/vbscript or set
oncontextmenu="return false".
How can I accomplish the same results using Reporting Services?
I've been searching and find no built-in property for my desired result. I
do have access to Visual Studio 2005, is there a custom way to provide what I
need using VB.Net or other method?
I realize that even if possible, users can probably get around it, but at
least it will limit users from exporting data to Excel for example.
Thanks!labsRcool@.community.nospan wrote:
> Is there anyway to disable mouse right click events in Reporting Services
> Reports?
> I am using RS 2005.
> On custom web pages, I can either use javascript/vbscript or set
> oncontextmenu="return false".
> How can I accomplish the same results using Reporting Services?
> I've been searching and find no built-in property for my desired result. I
> do have access to Visual Studio 2005, is there a custom way to provide what I
> need using VB.Net or other method?
> I realize that even if possible, users can probably get around it, but at
> least it will limit users from exporting data to Excel for example.
> Thanks!
I also responded to your other posting. It seems that you should
design a custom interface in VB.NET that allows a user to view the
report in some manner; but not actually have access to the report to
export it. I believe that an application can customize user access
much better.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thanks EMartinez for your input.
When you say "VB.Net", are you refering to creating custom asp.net webpages
via vb.net, or are you suggesting the only way to accomplish my goal is to
move away from webpages all to gether?
Thanks
"EMartinez" wrote:
> labsRcool@.community.nospan wrote:
> > Is there anyway to disable mouse right click events in Reporting Services
> > Reports?
> >
> > I am using RS 2005.
> > On custom web pages, I can either use javascript/vbscript or set
> > oncontextmenu="return false".
> >
> > How can I accomplish the same results using Reporting Services?
> >
> > I've been searching and find no built-in property for my desired result. I
> > do have access to Visual Studio 2005, is there a custom way to provide what I
> > need using VB.Net or other method?
> >
> > I realize that even if possible, users can probably get around it, but at
> > least it will limit users from exporting data to Excel for example.
> >
> > Thanks!
> I also responded to your other posting. It seems that you should
> design a custom interface in VB.NET that allows a user to view the
> report in some manner; but not actually have access to the report to
> export it. I believe that an application can customize user access
> much better.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>|||On Mar 2, 5:10 pm, labsRc...@.community.nospan
<labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> Thanks EMartinez for your input.
> When you say "VB.Net", are you refering to creating custom asp.net webpages
> via vb.net, or are you suggesting the only way to accomplish my goal is to
> move away from webpages all to gether?
> Thanks
> "EMartinez" wrote:
> > labsRc...@.community.nospan wrote:
> > > Is there anyway to disable mouse right click events in Reporting Services
> > > Reports?
> > > I am using RS 2005.
> > > On custom web pages, I can either use javascript/vbscript or set
> > > oncontextmenu="return false".
> > > How can I accomplish the same results using Reporting Services?
> > > I've been searching and find no built-in property for my desired result. I
> > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > need using VB.Net or other method?
> > > I realize that even if possible, users can probably get around it, but at
> > > least it will limit users from exporting data to Excel for example.
> > > Thanks!
> > I also responded to your other posting. It seems that you should
> > design a custom interface in VB.NET that allows a user to view the
> > report in some manner; but not actually have access to the report to
> > export it. I believe that an application can customize user access
> > much better.
> > Regards,
> > Enrique Martinez
> > Sr. SQL Server Developer
You should be able to use VB.NET to create custom web pages w/various
access levels.
Regards,
Enrique Martinez
Sr. SQL Server Developer|||Thank for your input.
I will attempt custom asp.net approach,
Thanks!
"EMartinez" wrote:
> On Mar 2, 5:10 pm, labsRc...@.community.nospan
> <labsRcoolcommunitynos...@.discussions.microsoft.com> wrote:
> > Thanks EMartinez for your input.
> >
> > When you say "VB.Net", are you refering to creating custom asp.net webpages
> > via vb.net, or are you suggesting the only way to accomplish my goal is to
> > move away from webpages all to gether?
> >
> > Thanks
> >
> > "EMartinez" wrote:
> >
> > > labsRc...@.community.nospan wrote:
> > > > Is there anyway to disable mouse right click events in Reporting Services
> > > > Reports?
> >
> > > > I am using RS 2005.
> > > > On custom web pages, I can either use javascript/vbscript or set
> > > > oncontextmenu="return false".
> >
> > > > How can I accomplish the same results using Reporting Services?
> >
> > > > I've been searching and find no built-in property for my desired result. I
> > > > do have access to Visual Studio 2005, is there a custom way to provide what I
> > > > need using VB.Net or other method?
> >
> > > > I realize that even if possible, users can probably get around it, but at
> > > > least it will limit users from exporting data to Excel for example.
> >
> > > > Thanks!
> >
> > > I also responded to your other posting. It seems that you should
> > > design a custom interface in VB.NET that allows a user to view the
> > > report in some manner; but not actually have access to the report to
> > > export it. I believe that an application can customize user access
> > > much better.
> >
> > > Regards,
> >
> > > Enrique Martinez
> > > Sr. SQL Server Developer
>
> You should be able to use VB.NET to create custom web pages w/various
> access levels.
> Regards,
> Enrique Martinez
> Sr. SQL Server Developer
>

disable log on user login events

my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?Originally posted by timothymo
my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.

will this cause problem to the server? as each entry will cause a open/close action.

if yes, how can i disable them?

Hi.... :)

Open / Close of DB file is not an issue its an configuration setting in Select DB Right click /Property / Options tab - Auto Close on-Off. This is to release the resource while DB is not in use. When any user use this DB the DB file will be opened.

If you don't want to use the login to be logged disable Server property / Security - Audit level (None or failure)

Cheers ,

Shaji

Disable local report cache

Does anyone know how to disable caching of local reports with
Reporting Services 2005?On Dec 9, 4:12 pm, lachlan.h...@.gmail.com wrote:
> Does anyone know how to disable caching of local reports with
> Reporting Services 2005?
This article should be helpful.
http://www.databasejournal.com/features/mssql/article.php/3695721
Regards,
Enrique Martinez
Sr. Software Consultant

Disable exporting in RS

Hi,

I would like to know if it is possible to disable the exporting option for individual reports in Reporting Services. I have seen a post explaining how to disable it for all reports (editing the config file on the reportserver) but the problem in my case is that I still need my users to have the exporting option for a majority of the reports. There are only a few reports that I need to disable this option for. Does anyone know if this is possible?

Thanks in advance

No it is not possible without writing your own UI.

I would like to understand the scenario more. Why would you want to allow users access to some of the reports only in a particular format?

Disable calendar control RS 2005

Is there a way to disable the calendar control in Reporting Services 2005?Hi Larry,
Solutions to this that have worked for me are:
If you mean the default calendar controls that collect parameter information
when the parameter is a date, then like any other, these parameters can be
marked as 'hidden'. To do this, click on the layout tab and select
Report->Report Parameters. When you select the relevant parameter in the
list box on the left, there is a checkbox option to hide it. The parameter
will require its value sourcing by means appropriate to how you are
rendering the report.
If you want to enter the parameter value as normal, but not with the
calendar control, change the type of the parameter to string and convert its
value in the stored procedure. This will make it show as a textbox instead.
Ed Allison
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:12E64B9A-656B-4844-A74D-AD4F645A0AFB@.microsoft.com...
> Is there a way to disable the calendar control in Reporting Services 2005?|||Thanks Ed, That worked perfectly. Even better, I don't have to do any
conversions, I simply make date/time parameters string parameters and the
reports work exactly as before without the calendars. Hopefully the
usefulness of the calendar will improve with the next service pack and we can
start using them again.|||What don't you like about the date picker? Seems like a normal date picker
to me. What are you looking for it to do?
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:29C652EC-CDB7-4923-9B43-137C203F5AE5@.microsoft.com...
> Thanks Ed, That worked perfectly. Even better, I don't have to do any
> conversions, I simply make date/time parameters string parameters and the
> reports work exactly as before without the calendars. Hopefully the
> usefulness of the calendar will improve with the next service pack and we
> can
> start using them again.
>|||One three separate servers I've installed RS on. When the reports are
deployed to the server the calendar exhibits two problems.
1) The buttons move around as you click through months.
2) The calendar will pause after about 7 clicks and after a few more it will
close.
I've seen it work on a Microsoft desktop but so far I'm unable to resolve
why we have the behavior here, just that's it's consistent and I can't get
rid of it.