Any way to use params in a SELECT...IN query?

I wish to execute a query like this:
SELECT name FROM Owner WHERE ownerID IN (@.ownerIDs)
Is there any way to accomplish that? I'm using ADO.NET to execute this..
Thanks,
Pablo
--
Sleep till the end, true soul and sweet!
Nothing comes to thee new or strange.
Sleep full of rest from head to feet;
Lie still, dry dust, secure of change.
-- Alfred Tennyson (1809-1892)
-- To J. S.
Pablo Montilla
www.odyssey.com.uyCheck out http://www.sommarskog.se/dynamic_sql.html#List
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Pablo Montilla" <melkor@.odyssey.com.uy> wrote in message
news:op.typkr1dkcj6shk@.chimera.odyssey.com.uy...
>I wish to execute a query like this:
> SELECT name FROM Owner WHERE ownerID IN (@.ownerIDs)
> Is there any way to accomplish that? I'm using ADO.NET to execute this..
> Thanks,
> Pablo
> --
>
> Sleep till the end, true soul and sweet!
> Nothing comes to thee new or strange.
> Sleep full of rest from head to feet;
> Lie still, dry dust, secure of change.
> -- Alfred Tennyson (1809-1892)
> -- To J. S.
> Pablo Montilla
> www.odyssey.com.uy|||Pablo,
I think Tibor meant:
Arrays and Lists in SQL Server
http://www.sommarskog.se/arrays-in-sql.html
AMB
"Pablo Montilla" wrote:
> I wish to execute a query like this:
> SELECT name FROM Owner WHERE ownerID IN (@.ownerIDs)
> Is there any way to accomplish that? I'm using ADO.NET to execute this..
> Thanks,
> Pablo
> --
>
> Sleep till the end, true soul and sweet!
> Nothing comes to thee new or strange.
> Sleep full of rest from head to feet;
> Lie still, dry dust, secure of change.
> -- Alfred Tennyson (1809-1892)
> -- To J. S.
> Pablo Montilla
> www.odyssey.com.uy
>|||On Sat, 15 Sep 2007 20:22:00 -0300, Alejandro Mesa
<AlejandroMesa@.discussions.microsoft.com> wrote:
> Pablo,
> I think Tibor meant:
> Arrays and Lists in SQL Server
> http://www.sommarskog.se/arrays-in-sql.html
> AMB
>
Many thanks for the links!
Regards,
Pablo
--
Don't vote. The government will get in.
-- Anarchist's Slogan
Pablo Montilla
www.odyssey.com.uy

Any comments on DCPROMO to promote domain controller on SQL Server?

We're planning to make our SQL server act as a passive domain controller
and are considering the use of DCPromo to accomplish this. Anybody have
comments regarding their experience changing the Domain Controller roles
on an active SQL server? We've all seen problems in the past monkeying
with core components on stable systems...
Thanks in advance.It is generally not recommende to put SQL on a domain controller ( because
of potential security issues and the DC is likely busy anyway.)
however, the thing that comes to mind is that when the box gets promoted to
a DC, the Domain Controller Security policy now applies to the machine in
addition to the local policies...
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Rusty" <aid940one@.nospam.ohwhocares.com> wrote in message
news:40193732.7020809@.nospam.ohwhocares.com...

quote:

---

> We're planning to make our SQL server act as a passive domain controller
> and are considering the use of DCPromo to accomplish this. Anybody have
> comments regarding their experience changing the Domain Controller roles
> on an active SQL server? We've all seen problems in the past monkeying
> with core components on stable systems...
> Thanks in advance.
>

---

Any comments on DCPROMO to promote domain controller on SQL Server?

We're planning to make our SQL server act as a passive domain controller
and are considering the use of DCPromo to accomplish this. Anybody have
comments regarding their experience changing the Domain Controller roles
on an active SQL server? We've all seen problems in the past monkeying
with core components on stable systems...
Thanks in advance.It is generally not recommende to put SQL on a domain controller ( because
of potential security issues and the DC is likely busy anyway.)
however, the thing that comes to mind is that when the box gets promoted to
a DC, the Domain Controller Security policy now applies to the machine in
addition to the local policies...
--
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Rusty" <aid940one@.nospam.ohwhocares.com> wrote in message
news:40193732.7020809@.nospam.ohwhocares.com...
> We're planning to make our SQL server act as a passive domain controller
> and are considering the use of DCPromo to accomplish this. Anybody have
> comments regarding their experience changing the Domain Controller roles
> on an active SQL server? We've all seen problems in the past monkeying
> with core components on stable systems...
> Thanks in advance.
>