Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can i select all dbname but filter system databases?
Message
De
23/08/2011 04:40:28
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
How can i select all dbname but filter system databases?
Versions des environnements
SQL Server:
SQL Server 2005
Application:
Desktop
Divers
Thread ID:
01521570
Message ID:
01521570
Vues:
84
I want to select all dbname, but filter System Databases (master,model,msdb,tempdb).
I see the Microsoft Sql Server Management Studio group master,model,msdb,tempdb to System Databases.
But i don't know how to filter ? Thank you ~~~
EXEC sp_databases

select * from   sys.master_files 
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform