Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Know SQL version
Message
De
07/12/2007 07:37:00
 
 
À
07/12/2007 07:21:59
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01273856
Message ID:
01273858
Vues:
15
>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
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform