Can you please tell me if there is any store proc that will show on which drive is the databases, if not, if anyone has a code i will a appreciate.
Thanks in advanceselect * from sysfiles
wll tell you the location of the data files (and trans log files) for that database.
No comments:
Post a Comment