Information générale
Forum:
Microsoft SQL Server
>I have a large number of databases, and I need to check on the Data files - File name - location Transaction files - file name and location Recover methord on all the databases Is there a way of doing this other that viewing the Properties screen of each database
Use the sp_helpdb stored procedure. If you just execute "sp_helpdb" it will give you info on all the databases, if you pass it a database name "sp_helpdb 'northwind'" it will also give you the file alocation properties for that database.
See the BOL for more info.
Cheers,
Eric Stephani
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement