multiple instances

Hello,
I have a basic question about running multiple instances.
I would like to install 2 instances of SQL server 2000 sp3 and configure
both to the default port 1433.
I only need one up and running at any one time. So shut down one start up
the other.
Can this work? Or the way the "listener service" is configured during
install it will error on installing the second sql instance? or some other
problem?
Any help would be appreciated.
As long as both aren't running at the same time then they can be configured
to listen on the same port. This can be done most easily with the server
network utility post installation. If you try and have both running, the
second one to start will have errors like "SuperSocket Info: Bind failed on
TCP port 1433." Why do you want to do this ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"greg" <greg@.nospam.com> wrote in message
news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a basic question about running multiple instances.
> I would like to install 2 instances of SQL server 2000 sp3 and configure
> both to the default port 1433.
> I only need one up and running at any one time. So shut down one start up
> the other.
> Can this work? Or the way the "listener service" is configured during
> install it will error on installing the second sql instance? or some
> other
> problem?
>
> Any help would be appreciated.
>
>
>
|||Thanks for the info.
It is a testing box. And 1 product requires case sensitivity on and one
requires it off.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
> As long as both aren't running at the same time then they can be
configured
> to listen on the same port. This can be done most easily with the server
> network utility post installation. If you try and have both running, the
> second one to start will have errors like "SuperSocket Info: Bind failed
on[vbcol=seagreen]
> TCP port 1433." Why do you want to do this ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "greg" <greg@.nospam.com> wrote in message
> news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
up
>
|||greg wrote:[vbcol=seagreen]
> Thanks for the info.
> It is a testing box. And 1 product requires case sensitivity on and
> one requires it off.
>
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
Why can't you run both instances at the same time?
David G.

multiple instances

Hello,
I have a basic question about running multiple instances.
I would like to install 2 instances of SQL server 2000 sp3 and configure
both to the default port 1433.
I only need one up and running at any one time. So shut down one start up
the other.
Can this work? Or the way the "listener service" is configured during
install it will error on installing the second sql instance? or some other
problem?
Any help would be appreciated.As long as both aren't running at the same time then they can be configured
to listen on the same port. This can be done most easily with the server
network utility post installation. If you try and have both running, the
second one to start will have errors like "SuperSocket Info: Bind failed on
TCP port 1433." Why do you want to do this ?
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"greg" <greg@.nospam.com> wrote in message
news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a basic question about running multiple instances.
> I would like to install 2 instances of SQL server 2000 sp3 and configure
> both to the default port 1433.
> I only need one up and running at any one time. So shut down one start up
> the other.
> Can this work? Or the way the "listener service" is configured during
> install it will error on installing the second sql instance? or some
> other
> problem?
>
> Any help would be appreciated.
>
>
>|||Thanks for the info.
It is a testing box. And 1 product requires case sensitivity on and one
requires it off.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
> As long as both aren't running at the same time then they can be
configured
> to listen on the same port. This can be done most easily with the server
> network utility post installation. If you try and have both running, the
> second one to start will have errors like "SuperSocket Info: Bind failed
on
> TCP port 1433." Why do you want to do this ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "greg" <greg@.nospam.com> wrote in message
> news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
up[vbcol=seagreen]
>|||greg wrote:[vbcol=seagreen]
> Thanks for the info.
> It is a testing box. And 1 product requires case sensitivity on and
> one requires it off.
>
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
Why can't you run both instances at the same time?
David G.

multiple instances

Hello,
I have a basic question about running multiple instances.
I would like to install 2 instances of SQL server 2000 sp3 and configure
both to the default port 1433.
I only need one up and running at any one time. So shut down one start up
the other.
Can this work? Or the way the "listener service" is configured during
install it will error on installing the second sql instance? or some other
problem?
Any help would be appreciated.As long as both aren't running at the same time then they can be configured
to listen on the same port. This can be done most easily with the server
network utility post installation. If you try and have both running, the
second one to start will have errors like "SuperSocket Info: Bind failed on
TCP port 1433." Why do you want to do this ?
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"greg" <greg@.nospam.com> wrote in message
news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
> Hello,
> I have a basic question about running multiple instances.
> I would like to install 2 instances of SQL server 2000 sp3 and configure
> both to the default port 1433.
> I only need one up and running at any one time. So shut down one start up
> the other.
> Can this work? Or the way the "listener service" is configured during
> install it will error on installing the second sql instance? or some
> other
> problem?
>
> Any help would be appreciated.
>
>
>|||Thanks for the info.
It is a testing box. And 1 product requires case sensitivity on and one
requires it off.
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
> As long as both aren't running at the same time then they can be
configured
> to listen on the same port. This can be done most easily with the server
> network utility post installation. If you try and have both running, the
> second one to start will have errors like "SuperSocket Info: Bind failed
on
> TCP port 1433." Why do you want to do this ?
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "greg" <greg@.nospam.com> wrote in message
> news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
> > Hello,
> >
> > I have a basic question about running multiple instances.
> >
> > I would like to install 2 instances of SQL server 2000 sp3 and configure
> > both to the default port 1433.
> >
> > I only need one up and running at any one time. So shut down one start
up
> > the other.
> >
> > Can this work? Or the way the "listener service" is configured during
> > install it will error on installing the second sql instance? or some
> > other
> > problem?
> >
> >
> >
> > Any help would be appreciated.
> >
> >
> >
> >
> >
> >
>|||greg wrote:
> Thanks for the info.
> It is a testing box. And 1 product requires case sensitivity on and
> one requires it off.
>
>
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:OoOVIYRkEHA.2908@.TK2MSFTNGP10.phx.gbl...
>> As long as both aren't running at the same time then they can be
>> configured to listen on the same port. This can be done most easily
>> with the server network utility post installation. If you try and
>> have both running, the second one to start will have errors like
>> "SuperSocket Info: Bind failed on TCP port 1433." Why do you want to
>> do this ?
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "greg" <greg@.nospam.com> wrote in message
>> news:%23U1gYoQkEHA.1348@.TK2MSFTNGP15.phx.gbl...
>> Hello,
>> I have a basic question about running multiple instances.
>> I would like to install 2 instances of SQL server 2000 sp3 and
>> configure both to the default port 1433.
>> I only need one up and running at any one time. So shut down one
>> start up the other.
>> Can this work? Or the way the "listener service" is configured
>> during install it will error on installing the second sql instance?
>> or some other
>> problem?
>>
>> Any help would be appreciated.
Why can't you run both instances at the same time?
--
David G.

Multiple Files -- DTS

I have a rather large sale transaction DB. Basic header, and detail tables. I am providing a third party company with daily sales information, and I need to give them back data from about 8 or 9 months ago. I currently have a DTS package that gets sales for the current day, but since I have to go back, I have to manually edit the query in the DTS package, and change the date range...UNLESS ...

Blah, blah, blah. The problem is that they can only take the data in Daily files. So, there would be ONE file for each day. I really don't need to be manually running these jobs, so I'm wondering if someone could point me to a way of writing a package (maybe ActiveX, not sure) that would run through a loop, basically, of dates, and create a seperate file for each day. Versus having to edit a generic DTS package, and changing the date range 350 times...would it be an option to select the current daterange from a table. Then, as a last step, update daterange to the next (or have a daterange column and another column that acts as a 'done this one' and update that column)? If the package simply exports the table contents you could also consider creating a dynamic sp but I am not sure if that's an option for you.|||That does make sense, but I am not sure how I would go about "looping" through the Daterange, and then creating a file for each day based on the query that is in the one DTS package.|||This is what I've done, and it's led me to another question:

@.Date1=(SELECT BeginDate FROM DateRangeTable)
@.Date2=(SELECT EndDate FROM DateRangeTable)

...SELECT BLAH, BLAH...WHERE Date BETWEEN @.Date1 AND @.Date2

UPDATE DateRange SET Loaded='YES' WHERE BeginDate=@.Date1

EXEC master..xp_cmdshell 'REN I:\DailySales ' + @.Date1

--

By itself, the EXEC xp_cmdshell runs just fine. However, when I include The Main query, It doesn't work at all with NO errors...anyone know what gives?|||Does it have to be formatted a certain way? You could certainly do it in ActiveX, or simply use xp_cmdshell to execute BCP:

EXEC master..xp_cmdshell 'bcp ' + 'SELECT BLAH, BLAH...WHERE Date BETWEEN @.Date1 AND @.Date2'|||Yes, the DTS Package has a certain format that I haven't been able to figure out how to match with bcp.|||I haven't worked with BCP for sometime, but it does have a parameter for a "format file". If you can't get BCP to format it the way you want, you can do it in ActiveX.

Multiple Datasources in one report

I am very new to crystal so please excuse if this is a basic request...

We are using Crystal 9.2. I have two datasources, one in oracle and the other in sqlserver. I need to join the two datasources together with the full outer join option, but that option is grayed out in the Links tab in the Database expert window. I basically need to do a UNION ALL between the two datasources, I want to display all the rows from both datasources. Is this possible? What am I missing? Do I need to use a subreport? I need to do grouping/totaling between the two datasources.

What would be ideal, is if I could create a view between the two datasources (using the union all option) and then use that view as the datasource for the report. Is there anything like this available?

Any pointers would be greatly appreciated!Migrate data and keep them in a single datasource