>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
SELECT @@VERSION
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.