Find all the database files of the current database

Posted Date: 20 Nov 2008	Resource Type: Articles	Category: General
Author: gururajan	Member Level: Gold
Rating:	Points: 5

SQL SERVER 2000:

select name,filename from sysfiles

SQL SERVER 2005:

select name, physical_name from sys.database_files

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Find all the database files of the current database .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: LIfetime Events of a Form
	Previous Resource: Differences Between Properties and Indexers in C#
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

LIfetime Events of a Form
Server Controls in ASP.NET
Enterprise Library Application Blocks
DDL, DML, DCL.
compressed programe
ASP.NET MVC – A Step Ahead Series: Part-II