Thanks!
The
select @@version
is a good option too.
Have a nice day!
******
TONY Nascimento
Cape Verde Islands
West Coast Africa
*********************

>>Hi.
>>Sorry about my English!
>>I have 2 instances of SQL running at my server.
>>I believe that they are not from same version.
>>After connecting to them how can I know which
>>version they are and which Service Pack have they
>>been upgraded? Using SQL commands? Which ones?
>>By the way, taking in attention performance (relative
>>to RAM and processor) which option is the best:
>>a) Have 4 databases in 1 instance of SQL;
>>b) Have 2 databases at 2 instances of SQL.
>>Thanks in advance
>>******
>>TONY Nascimento
>>Cape Verde Islands
>>West Coast Africa
>>*********************
>
>Try:
>

>master..xp_msver
>
>-- or
>SELECT @@VERSION
>