.NET Framework 2.0 question - continued...

Hi,

I have a few more questions related to my .NET Framework 2.0 question thread posted last week. I know that some of these questions will go beyond the realm of SQL-NS and into the SQL Server 2005 world, but my belief is that you guys will already know the answers.

Lets say I have an IIS web server on Windows 2003 Server with the following software already installed:

1. SQL Server 2000 client software
2. .NET Framework 1.1
3. MDAC 2.X

Now I create a SQL-NS application hosted on a new separate Windows 2003 Server running SQL Server 2005. Let's say I decide to install .NET Framework 2.0 on my web server so that I can run a VS 2005 ASP.NET subscription management app on the web server. Would I also need to install SQL Server 2005 client software on the web server? My belief is that .NET Framework 2.0 apps will only need ADO.NET 2.0 that is included in the Framework install (but I am not 100% certain).

Also, what if my subscription management ASP.NET application also maintains it's own custom SQL 2005 database outside of the SQL-NS subscription management API? Again, is Framework 2.0 all I require (i.e. ADO.NET 2.0) or might I also require the SQL 2005 client software?

Is there any other required client software I may be missing for my scenario described above?

Again, sorry for crossing the realm into SQL Server 2005.

PeterWhen you say SQL Server 2005 client software do you mean the NS 2.0 client software or MDAC?

To use the NS API for SQL Server 2005, you'll need to install the NS client software on your web server (client). If you do not plan to use the NS API from the web server, you do not need to install it.

SQLClient in the .Net Framework 2.0 requires MDAC 2.8. As such anything that uses SQLClient to communicate with a SQL Server database (SQL Server 2005 or other version) will need MDAC 2.8 to be deployed on the client computer. This includes the NS API.

If you're trying to access SQL Server 2005 using Native code. You'll need to install SNAC that comes with SQL Server 2005.

Regarding other client software - this really depends on what your applicaiton is trying to do. I am not aware of other software you'd need specifically for using NS client API or SQL Client.

-Lukasz|||Peter,
Your ASP.NET 2.0 subscription management application will need to call the NS subscriber/subscription APIs, which are packaged as part of the NS client components. YOu can install these independently of the other SQL Server client components, from the "Advanced" screen in SQL 2005 setup.

You may also need the SQL Native Client to be installed. However, I'm not an expert on that, so I can't say for sure. You may have better luck in one of the other SQL forums.
-shyam

*= Left Outer Join

I have three related tables A,B and C. In sql server 2000 I can run next query:
select * from
A left outer join B on A.fk=B.i
left outer join C on B.fk=C.i
but below query give me an "invalid outer combination" error:
select * from
A,B,
where
A.fk*=B.id an
B.fk*=C.i
It seems outer combinations configured in where clause are limited to two tables, although I have seen some examples of more than two tables in the web (but unfortunately author didnâ't inform about sql version). Has changed the behaviour of *= changed in the 2000 versionWhy do you want to use deprecated syntax that will not be supported in a
future version?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in message
news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com...
> I have three related tables A,B and C. In sql server 2000 I can run next
query:
> select * from
> A left outer join B on A.fk=B.id
> left outer join C on B.fk=C.id
> but below query give me an "invalid outer combination" error:
> select * from
> A,B,C
> where
> A.fk*=B.id and
> B.fk*=C.id
> It seems outer combinations configured in where clause are limited to two
tables, although I have seen some examples of more than two tables in the
web (but unfortunately author didnâ?Tt inform about sql version). Has
changed the behaviour of *= changed in the 2000 version?
>|||Thatâ's very true Aaron, but I',m using an automatic persistence tool which generates this kind of joins and I can't do anything about. So, if possible, I would like to know why it doesn't works in sql server 2000 (in order to complain) and if there would be a way to circumvent the problem in the mean time.
-- Aaron Bertrand - MVP wrote: --
Why do you want to use deprecated syntax that will not be supported in
future version
--
Aaron Bertran
SQL Server MV
http://www.aspfaq.com
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in messag
news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com..
> I have three related tables A,B and C. In sql server 2000 I can run nex
query
>> select * fro
> A left outer join B on A.fk=B.i
> left outer join C on B.fk=C.i
>> but below query give me an "invalid outer combination" error
>> select * fro
> A,B,
> wher
> A.fk*=B.id an
> B.fk*=C.i
>> It seems outer combinations configured in where clause are limited to tw
tables, although I have seen some examples of more than two tables in th
web (but unfortunately author didnâ?Tt inform about sql version). Ha
changed the behaviour of *= changed in the 2000 version
>|||There are restriction for old-style joins. I don't know them all by heart
(you should be able to find them in Books Online), but I believe that one is
that you can't do more than one OJ in a query. You really need to get a
version of your tool that supports the new proper way to specify an outer
join.
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in message
news:3DF4DD3C-DF25-42C6-B8C4-5B504F1E5A04@.microsoft.com...
> That's very true Aaron, but I',m using an automatic persistence tool which
generates this kind of joins and I can't do anything about. So, if
possible, I would like to know why it doesn't works in sql server 2000 (in
order to complain) and if there would be a way to circumvent the problem in
the mean time.
> -- Aaron Bertrand - MVP wrote: --
> Why do you want to use deprecated syntax that will not be supported
in a
> future version?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "David Palomar" <anonymous@.discussions.microsoft.com> wrote in
message
> news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com...
> > I have three related tables A,B and C. In sql server 2000 I can run
next
> query:
> >> select * from
> > A left outer join B on A.fk=B.id
> > left outer join C on B.fk=C.id
> >> but below query give me an "invalid outer combination" error:
> >> select * from
> > A,B,C
> > where
> > A.fk*=B.id and
> > B.fk*=C.id
> >> It seems outer combinations configured in where clause are limited
to two
> tables, although I have seen some examples of more than two tables in
the
> web (but unfortunately author didnâ?Tt inform about sql version). Has
> changed the behaviour of *= changed in the 2000 version?
> >

*= Left Outer Join

I have three related tables A,B and C. In sql server 2000 I can run next que
ry:
select * from
A left outer join B on A.fk=B.id
left outer join C on B.fk=C.id
but below query give me an "invalid outer combination" error:
select * from
A,B,C
where
A.fk*=B.id and
B.fk*=C.id
It seems outer combinations configured in where clause are limited to two ta
bles, although I have seen some examples of more than two tables in the web
(but unfortunately author didn’t inform about sql version). Has changed th
e behaviour of *= changed i
n the 2000 version?Why do you want to use deprecated syntax that will not be supported in a
future version?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in message
news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com...
> I have three related tables A,B and C. In sql server 2000 I can run next
query:
> select * from
> A left outer join B on A.fk=B.id
> left outer join C on B.fk=C.id
> but below query give me an "invalid outer combination" error:
> select * from
> A,B,C
> where
> A.fk*=B.id and
> B.fk*=C.id
> It seems outer combinations configured in where clause are limited to two
tables, although I have seen some examples of more than two tables in the
web (but unfortunately author didn?Tt inform about sql version). Has
changed the behaviour of *= changed in the 2000 version?
>|||That’s very true Aaron, but I',m using an automatic persistence tool which
generates this kind of joins and I can't do anything about. So, if possibl
e, I would like to know why it doesn't works in sql server 2000 (in order to
complain) and if there wou
ld be a way to circumvent the problem in the mean time.
-- Aaron Bertrand - MVP wrote: --
Why do you want to use deprecated syntax that will not be supported in a
future version?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in message
news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com...
> I have three related tables A,B and C. In sql server 2000 I can run next
query:
> A left outer join B on A.fk=B.id
> left outer join C on B.fk=C.id
> A,B,C
> where
> A.fk*=B.id and
> B.fk*=C.id
tables, although I have seen some examples of more than two tables in the
web (but unfortunately author didna?Tt inform about sql version). Has
changed the behaviour of *= changed in the 2000 version?
>|||There are restriction for old-style joins. I don't know them all by heart
(you should be able to find them in Books Online), but I believe that one is
that you can't do more than one OJ in a query. You really need to get a
version of your tool that supports the new proper way to specify an outer
join.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in message
news:3DF4DD3C-DF25-42C6-B8C4-5B504F1E5A04@.microsoft.com...
> That's very true Aaron, but I',m using an automatic persistence tool which
generates this kind of joins and I can't do anything about. So, if
possible, I would like to know why it doesn't works in sql server 2000 (in
order to complain) and if there would be a way to circumvent the problem in
the mean time.
> -- Aaron Bertrand - MVP wrote: --
> Why do you want to use deprecated syntax that will not be supported
in a
> future version?
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "David Palomar" <anonymous@.discussions.microsoft.com> wrote in
message
> news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com...
next
> query:
to two
> tables, although I have seen some examples of more than two tables in
the
> web (but unfortunately author didn?Tt inform about sql version). Has
> changed the behaviour of *= changed in the 2000 version?|||Thanks for the clue Tibor, i'll try to follow it.
-- Tibor Karaszi wrote: --
There are restriction for old-style joins. I don't know them all by heart
(you should be able to find them in Books Online), but I believe that one is
that you can't do more than one OJ in a query. You really need to get a
version of your tool that supports the new proper way to specify an outer
join.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"David Palomar" <anonymous@.discussions.microsoft.com> wrote in message
news:3DF4DD3C-DF25-42C6-B8C4-5B504F1E5A04@.microsoft.com...
> That's very true Aaron, but I',m using an automatic persistence tool which
generates this kind of joins and I can't do anything about. So, if
possible, I would like to know why it doesn't works in sql server 2000 (in
order to complain) and if there would be a way to circumvent the problem in
the mean time.
in a
> future version?
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
message
> news:5F0EAF81-A9CD-4E0C-A57D-DC5CC8CDB47F@.microsoft.com...
next
> query:
to two
> tables, although I have seen some examples of more than two tables in
the
> web (but unfortunately author didna?Tt inform about sql version). Ha
s
> changed the behaviour of *= changed in the 2000 version?

**find related objects**

Hi
I'm working with SQL 2000, how can I find login name L1 is the owner of
which objects() in which dbs?in other word, when I want to delete a login
name in login list an error appears with the context of "you can n't
delete it because it's owns some objects in some DBs".
any help would be grateful
Try this one
CREATE FUNCTION dbo.RoleCheckUser
(
@.UserName sysname,
@.RoleName sysname
)
RETURNS BIT
AS
BEGIN
DECLARE @.RetVal BIT
SET @.RetVal = 0
SELECT @.RetVal = 1
WHERE EXISTS
(
SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid
WHERE
users.name = @.UserName
AND groups.name = @.RoleName
)
RETURN @.RetVal
END
GO
-- Syntax to use the created function
SELECT dbo.RoleCheckUser('dbo', 'db_owner')
G
<R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000, how can I find login name L1 is the owner of
> which objects() in which dbs?in other word, when I want to delete a login
> name in login list an error appears with the context of "you can n't
> delete it because it's owns some objects in some DBs".
> any help would be grateful
|||Thanks for your reply, but let me explain my question in another way,
I want a list which shows me L1 had created which objects for example:
L1:
DB1 View1
DB1 table41
DB2View2
DB2View3
DB2Storeprocedure1
then I can go to those databases and I can change the owner of each object
and finally be able to delete th L1 completey.
I would be grateful if you could help me.
On Sun, 19 Feb 2006 13:00:44 +0200, Uri Dimant <urid@.iscar.co.il> wrote:

> Try this one
> CREATE FUNCTION dbo.RoleCheckUser
> (
> @.UserName sysname,
> @.RoleName sysname
> )
> RETURNS BIT
> AS
> BEGIN
> DECLARE @.RetVal BIT
> SET @.RetVal = 0
> SELECT @.RetVal = 1
> WHERE EXISTS
> (
> SELECT *
> FROM sysmembers membs
> JOIN sysusers users on membs.memberuid = users.uid
> JOIN sysusers groups on membs.groupuid = groups.uid
> WHERE
> users.name = @.UserName
> AND groups.name = @.RoleName
> )
> RETURN @.RetVal
> END
> GO
> -- Syntax to use the created function
> SELECT dbo.RoleCheckUser('dbo', 'db_owner')
> G
>
> <R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
>
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/
|||You can query sysobjects in a database to find all objects
owned by a user - something like:
SELECT name, xtype
FROM sysobjects
WHERE uid = user_id('YourUser')
-Sue
On Mon, 20 Feb 2006 08:18:40 +0330, R-M <R> wrote:
[vbcol=seagreen]
>Thanks for your reply, but let me explain my question in another way,
>I want a list which shows me L1 had created which objects for example:
>L1:
>--
>DB1 View1
>DB1 table41
>DB2View2
>DB2View3
>DB2Storeprocedure1
>then I can go to those databases and I can change the owner of each object
>and finally be able to delete th L1 completey.
>I would be grateful if you could help me.
>On Sun, 19 Feb 2006 13:00:44 +0200, Uri Dimant <urid@.iscar.co.il> wrote:

**find related objects**

Hi
I'm working with SQL 2000, how can I find login name L1 is the owner of
which objects() in which dbs?in other word, when I want to delete a login
name in login list an error appears with the context of "you can n't
delete it because it's owns some objects in some DBs".
any help would be gratefulTry this one
CREATE FUNCTION dbo.RoleCheckUser
(
@.UserName sysname,
@.RoleName sysname
)
RETURNS BIT
AS
BEGIN
DECLARE @.RetVal BIT
SET @.RetVal = 0
SELECT @.RetVal = 1
WHERE EXISTS
(
SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid
WHERE
users.name = @.UserName
AND groups.name = @.RoleName
)
RETURN @.RetVal
END
GO
-- Syntax to use the created function
SELECT dbo.RoleCheckUser('dbo', 'db_owner')
G
<R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000, how can I find login name L1 is the owner of
> which objects() in which dbs?in other word, when I want to delete a login
> name in login list an error appears with the context of "you can n't
> delete it because it's owns some objects in some DBs".
> any help would be grateful|||Thanks for your reply, but let me explain my question in another way,
I want a list which shows me L1 had created which objects for example:
L1:
--
DB1 View1
DB1 table41
DB2 View2
DB2 View3
DB2 Storeprocedure1
then I can go to those databases and I can change the owner of each object
and finally be able to delete th L1 completey.
I would be grateful if you could help me.
On Sun, 19 Feb 2006 13:00:44 +0200, Uri Dimant <urid@.iscar.co.il> wrote:

> Try this one
> CREATE FUNCTION dbo.RoleCheckUser
> (
> @.UserName sysname,
> @.RoleName sysname
> )
> RETURNS BIT
> AS
> BEGIN
> DECLARE @.RetVal BIT
> SET @.RetVal = 0
> SELECT @.RetVal = 1
> WHERE EXISTS
> (
> SELECT *
> FROM sysmembers membs
> JOIN sysusers users on membs.memberuid = users.uid
> JOIN sysusers groups on membs.groupuid = groups.uid
> WHERE
> users.name = @.UserName
> AND groups.name = @.RoleName
> )
> RETURN @.RetVal
> END
> GO
> -- Syntax to use the created function
> SELECT dbo.RoleCheckUser('dbo', 'db_owner')
> G
>
> <R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
>
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/|||You can query sysobjects in a database to find all objects
owned by a user - something like:
SELECT name, xtype
FROM sysobjects
WHERE uid = user_id('YourUser')
-Sue
On Mon, 20 Feb 2006 08:18:40 +0330, R-M <R> wrote:
[vbcol=seagreen]
>Thanks for your reply, but let me explain my question in another way,
>I want a list which shows me L1 had created which objects for example:
>L1:
>--
>DB1 View1
>DB1 table41
>DB2 View2
>DB2 View3
>DB2 Storeprocedure1
>then I can go to those databases and I can change the owner of each object
>and finally be able to delete th L1 completey.
>I would be grateful if you could help me.
>On Sun, 19 Feb 2006 13:00:44 +0200, Uri Dimant <urid@.iscar.co.il> wrote:
>

**find related objects**

Hi
I'm working with SQL 2000, how can I find login name L1 is the owner of
which objects() in which dbs?in other word, when I want to delete a login
name in login list an error appears with the context of "you can n't
delete it because it's owns some objects in some DBs".
any help would be gratefulTry this one
CREATE FUNCTION dbo.RoleCheckUser
(
@.UserName sysname,
@.RoleName sysname
)
RETURNS BIT
AS
BEGIN
DECLARE @.RetVal BIT
SET @.RetVal = 0
SELECT @.RetVal = 1
WHERE EXISTS
(
SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid
WHERE
users.name = @.UserName
AND groups.name = @.RoleName
)
RETURN @.RetVal
END
GO
-- Syntax to use the created function
SELECT dbo.RoleCheckUser('dbo', 'db_owner')
G
<R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL 2000, how can I find login name L1 is the owner of
> which objects() in which dbs?in other word, when I want to delete a login
> name in login list an error appears with the context of "you can n't
> delete it because it's owns some objects in some DBs".
> any help would be grateful|||Thanks for your reply, but let me explain my question in another way,
I want a list which shows me L1 had created which objects for example:
L1:
--
DB1 View1
DB1 table41
DB2 View2
DB2 View3
DB2 Storeprocedure1
then I can go to those databases and I can change the owner of each object
and finally be able to delete th L1 completey.
I would be grateful if you could help me.
On Sun, 19 Feb 2006 13:00:44 +0200, Uri Dimant <urid@.iscar.co.il> wrote:
> Try this one
> CREATE FUNCTION dbo.RoleCheckUser
> (
> @.UserName sysname,
> @.RoleName sysname
> )
> RETURNS BIT
> AS
> BEGIN
> DECLARE @.RetVal BIT
> SET @.RetVal = 0
> SELECT @.RetVal = 1
> WHERE EXISTS
> (
> SELECT *
> FROM sysmembers membs
> JOIN sysusers users on membs.memberuid = users.uid
> JOIN sysusers groups on membs.groupuid = groups.uid
> WHERE
> users.name = @.UserName
> AND groups.name = @.RoleName
> )
> RETURN @.RetVal
> END
> GO
> -- Syntax to use the created function
> SELECT dbo.RoleCheckUser('dbo', 'db_owner')
> G
>
> <R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
>> Hi
>> I'm working with SQL 2000, how can I find login name L1 is the owner of
>> which objects() in which dbs?in other word, when I want to delete a
>> login
>> name in login list an error appears with the context of "you can n't
>> delete it because it's owns some objects in some DBs".
>> any help would be grateful
>
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/|||You can query sysobjects in a database to find all objects
owned by a user - something like:
SELECT name, xtype
FROM sysobjects
WHERE uid = user_id('YourUser')
-Sue
On Mon, 20 Feb 2006 08:18:40 +0330, R-M <R> wrote:
>Thanks for your reply, but let me explain my question in another way,
>I want a list which shows me L1 had created which objects for example:
>L1:
>--
>DB1 View1
>DB1 table41
>DB2 View2
>DB2 View3
>DB2 Storeprocedure1
>then I can go to those databases and I can change the owner of each object
>and finally be able to delete th L1 completey.
>I would be grateful if you could help me.
>On Sun, 19 Feb 2006 13:00:44 +0200, Uri Dimant <urid@.iscar.co.il> wrote:
>> Try this one
>> CREATE FUNCTION dbo.RoleCheckUser
>> (
>> @.UserName sysname,
>> @.RoleName sysname
>> )
>> RETURNS BIT
>> AS
>> BEGIN
>> DECLARE @.RetVal BIT
>> SET @.RetVal = 0
>> SELECT @.RetVal = 1
>> WHERE EXISTS
>> (
>> SELECT *
>> FROM sysmembers membs
>> JOIN sysusers users on membs.memberuid = users.uid
>> JOIN sysusers groups on membs.groupuid = groups.uid
>> WHERE
>> users.name = @.UserName
>> AND groups.name = @.RoleName
>> )
>> RETURN @.RetVal
>> END
>> GO
>> -- Syntax to use the created function
>> SELECT dbo.RoleCheckUser('dbo', 'db_owner')
>> G
>>
>> <R> wrote in message news:ops47uo6j3mw7tkz@.system109.parskhazar.net...
>> Hi
>> I'm working with SQL 2000, how can I find login name L1 is the owner of
>> which objects() in which dbs?in other word, when I want to delete a
>> login
>> name in login list an error appears with the context of "you can n't
>> delete it because it's owns some objects in some DBs".
>> any help would be grateful
>>

**fetch the related tables of a particular table**

Hi
I'm working with SQL server 2000, and I want to know how can I find the
list of tables which have relation to a particular table. in another word,
would it be possible to fetch the name of those tables by a simple Sql
statement?
Any help would be greatly appreciated.Hi
Look at INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS.
John
<R> wrote in message news:ops6lmu3xamw7tkz@.system109.parskhazar.net...
> Hi
> I'm working with SQL server 2000, and I want to know how can I find the
> list of tables which have relation to a particular table. in another word,
> would it be possible to fetch the name of those tables by a simple Sql
> statement?
> Any help would be greatly appreciated.

** critical issue with SSIS ** Please help!

Hi all of you,

This post is related with this one, previously opened:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=620243&SiteID=1

Moreover, this post is related too (IMHO) with

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=430406&SiteID=17

Following with my research I've seen that DTS.DLL is installed on:

1)My root c:

2)%systemroot%\system32

2)c:\archivos de programa\...\90\

3)c:\archivos de programa\...\80\

It seems that BIDS is trying to call, at first, to this COM CCW component.

So that, all has been deleted phsyically from my workstation and unregistered.

Sql Server 2005 full installation again and... the problem lives yet.

I'm desperate

I'm afraid I cannot help, never seen this issue, but if it really is that important I'd strongly recomend you contact MS Support. It will be easier for them to diagnose a problem with you in real-time over forum posts.|||Thanks Darren

(Select All) continued

Hey All,
I've found another problem related to everyone's select all hack which is
using a union and an extra check.
I have a simple Customers drop down and I want to display the (All
Customers) option.
So, I took Reddy's advice and tried this:
WHERE (Customer IN (@.Customer) or '(All Customers)' in(@.Customer))
This works until you try to set '(All Customers)' as the non-queried default
value. The worst part is that it works in the VS Preview mode, then does NOT
work from the report server.
Basically, it just ignores the default value.
Anyone know why this might be the case?
StevenYou may need to delete the deployed report from RS and then redeploy. There
is a problem where parameter values get incorrectly updated if you redeploy
over the top.
Taz