Remove "All" and Keep "select All" from parameters

I know that when you select Multi from the parameter report properties, that it automatically makes "Select All" Available. So how would i take off the "All Value". My users dont want to see All, if Select ALL is available.

How do i exclude from "All" from my report parameter/dataset?

Are you returning "All" from a stored procedure or is it one of your multi value parameter value?

remote perfmon

Hi,
How do i use the performance monitor of my pc to remote performance a
server which is not available in a domain? The server i try to monitor
also has sql server installed on it and i want to log the counters for it.
Is this possible?I haven't tried this but I think all you need to do is establish security
credentials that are recognized by the remote computer before connecting
with perfmon. The easiest way to do this is to map a drive to the remote
machine using the remote machine's local administrator account.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jason" <jasonlewis@.hotmail.com> wrote in message
news:uyo2$ffPGHA.3164@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How do i use the performance monitor of my pc to remote performance a
> server which is not available in a domain? The server i try to monitor
> also has sql server installed on it and i want to log the counters for it.
> Is this possible?

remote perfmon

Hi,
How do i use the performance monitor of my pc to remote performance a
server which is not available in a domain? The server i try to monitor
also has sql server installed on it and i want to log the counters for it.
Is this possible?I haven't tried this but I think all you need to do is establish security
credentials that are recognized by the remote computer before connecting
with perfmon. The easiest way to do this is to map a drive to the remote
machine using the remote machine's local administrator account.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jason" <jasonlewis@.hotmail.com> wrote in message
news:uyo2$ffPGHA.3164@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How do i use the performance monitor of my pc to remote performance a
> server which is not available in a domain? The server i try to monitor
> also has sql server installed on it and i want to log the counters for it.
> Is this possible?

remote perfmon

Hi,
How do i use the performance monitor of my pc to remote performance a
server which is not available in a domain? The server i try to monitor
also has sql server installed on it and i want to log the counters for it.
Is this possible?
I haven't tried this but I think all you need to do is establish security
credentials that are recognized by the remote computer before connecting
with perfmon. The easiest way to do this is to map a drive to the remote
machine using the remote machine's local administrator account.
Hope this helps.
Dan Guzman
SQL Server MVP
"Jason" <jasonlewis@.hotmail.com> wrote in message
news:uyo2$ffPGHA.3164@.TK2MSFTNGP11.phx.gbl...
> Hi,
> How do i use the performance monitor of my pc to remote performance a
> server which is not available in a domain? The server i try to monitor
> also has sql server installed on it and i want to log the counters for it.
> Is this possible?

Remote instance not listed in Available Servers in Enterprise Manager

When using the register available servers in Enterprise Manager, the
named instances on a remote machine are not listed. The unnamed
instance is listed and will register successfully.
I have tried manually typing the names of the remote NAMED instances;
then tried to authenticate and get the message "SQL server does not
exist or access denied".
Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
2 Instances
Unnamed
DEV\DB1
On the remote machine SQL Server 2000 (MSDE Edition) installed
3 Instances;
Unnamed
REM\DB1
REM\DB2
Both machines are on the same domain. All SQL server instances are
running.
I have also used the svrnetcn.exe tool to make sure the Named Pipes
and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
been changed to 1433 on all remote instances. (both machines were
rebooted)
What else can I check ?
Thanks
D> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
Each instance on a machine must listen on a unique TCP port. Consequently,
all of the instances on your REM machine can't be listening on the same 1433
port. Check the errorlog file for those instances for related TCP port
binding errors and change the named instance ports, if needed.
The normal configuration is that the default (unnamed) instance listens on
1433 and named instance ports are determined dynamically. When a client
connects to a named instance, it firsts gets a list of running named
instances via a UDP 1434 request and then connects to the TCP port of the
specified instance. Make sure your firewall allows TCP 1433, UDP 1434 and
TCP traffic on the named instance ports. See
http://support.microsoft.com/kb/287932
--
Hope this helps.
Dan Guzman
SQL Server MVP
"DM" <dmcb73@.gmail.com> wrote in message
news:1190197075.363594.146870@.22g2000hsm.googlegroups.com...
> When using the register available servers in Enterprise Manager, the
> named instances on a remote machine are not listed. The unnamed
> instance is listed and will register successfully.
> I have tried manually typing the names of the remote NAMED instances;
> then tried to authenticate and get the message "SQL server does not
> exist or access denied".
> Local machine; SQL Server 2000 SP4 (Developer Edition) installed.
> 2 Instances
> Unnamed
> DEV\DB1
> On the remote machine SQL Server 2000 (MSDE Edition) installed
> 3 Instances;
> Unnamed
> REM\DB1
> REM\DB2
> Both machines are on the same domain. All SQL server instances are
> running.
> I have also used the svrnetcn.exe tool to make sure the Named Pipes
> and TCP/IP protocols are enabled. The port on the TCP/IP protocol has
> been changed to 1433 on all remote instances. (both machines were
> rebooted)
> What else can I check ?
> Thanks
> D
>