Different language instances on same server

Is it possible to install two different SQL server version
instances, for instance, one in english and the other one
in Spanish, in the same server?
We are having a problem in our central server, with a
especific software which runs correctly only in the SQL
server spanish version.
For sure, all collation and language settings have been
tested in the english version with no result.
Thanks in advanceGustavo,
Yes, given you can even install SQL7 and SQL2000 on the same
server - they don't share much at all !
But there are license issues / costs:
http://www.microsoft.com/sql/howtobuy/faq.asp
"SQL Server 2000 Enterprise Edition includes the ability to run multiple instances of SQL Server 2000 on a
single computer. Multiple instances are used by organizations that have several applications running on a
server, but want them to run in isolation so that any problem in one instance will not affect the other
instances.
With SQL Server 2000 Enterprise Edition, you can install multiple instances of SQL Server on the same computer
without having additional licenses. Although SQL Server 2000 Standard Edition will technically support
multiple instances, each instance requires a separate license. "
"Gustavo" <gcarreras@.koppert.es> wrote in message news:002401c39a39$237e29b0$a101280a@.phx.gbl...
> Is it possible to install two different SQL server version
> instances, for instance, one in english and the other one
> in Spanish, in the same server?
> We are having a problem in our central server, with a
> especific software which runs correctly only in the SQL
> server spanish version.
> For sure, all collation and language settings have been
> tested in the english version with no result.
> Thanks in advance

Different language Characters

I have a developer that needs to store different language
characters in a table. What he is doing is designing a web
page, so that someone will have a choice as what language
he will view the web page in. Is it possible to store lets
say Russian or Chinese characters in a SQL Server table?
Does this fall under Unicode data? If you can do this, how
do you get the characters into the coulmns? Any help or
suggestions would be greatly appreciated!!Hello Richard !
Yes, this is UNICODE. How you get the data into the columns ? With an INSERT
? Regardless , your business logic
is on SQL Server or in the frontend, the data is send to SQL Server in
UNICODE and also stored there as this.
Jens Süßmeyer.
"Richard" <richard.peoples@.lacdc.org> schrieb im Newsbeitrag
news:034301c365ce$cce23130$a501280a@.phx.gbl...
> I have a developer that needs to store different language
> characters in a table. What he is doing is designing a web
> page, so that someone will have a choice as what language
> he will view the web page in. Is it possible to store lets
> say Russian or Chinese characters in a SQL Server table?
> Does this fall under Unicode data? If you can do this, how
> do you get the characters into the coulmns? Any help or
> suggestions would be greatly appreciated!!|||Obviously then, I need to have SQL Server installed as Unicode. Correct?
>--Original Message--
>Hello Richard !
>Yes, this is UNICODE. How you get the data into the columns ? With an INSERT
>? Regardless , your business logic
> is on SQL Server or in the frontend, the data is send to SQL Server in
>UNICODE and also stored there as this.
>Jens S=FC=DFmeyer.
>
>"Richard" <richard.peoples@.lacdc.org> schrieb im Newsbeitrag
>news:034301c365ce$cce23130$a501280a@.phx.gbl...
>> I have a developer that needs to store different language
>> characters in a table. What he is doing is designing a web
>> page, so that someone will have a choice as what language
>> he will view the web page in. Is it possible to store lets
>> say Russian or Chinese characters in a SQL Server table?
>> Does this fall under Unicode data? If you can do this, how
>> do you get the characters into the coulmns? Any help or
>> suggestions would be greatly appreciated!!
>
>.
>|||No just change the columns you have to NVARCHAR to store UNICODE. But
remeber --> The Maximum Length will be chopped to 4000 characters.
Jens Süßmeyer.

Differences between Signed Vb Script Class and Vb Script language

on ActiveX Script task

tia

SSIS just lists all the ActiveX scripting languages registered on the machine (so you can add perl or other languages).

I don't remember the details, but on some OSes Signed VB Script language is registered on the machine. The language is the same, but can have comment with digital signature.

BTW, ActiveX Script task is deprecated feature, added to facilitate upgrade from DTS. Use Script Task for any new work.|||

hi Michael,

Thanks a lot for your comments.