Monday, December 3, 2007

How to determine which file to attach

How to determine which file to attach

Step 1

User can find out which are the file attached to a particular database in this case it is Demo by simply using the following command,

USE Demo

EXEC SP_HELPFILE

The SQL Analyzer will return a list of file associated with this file.

No comments: