首页 > 未分类 > 据mdf方件查看数据库名称,版本信息
2015九月17

据mdf方件查看数据库名称,版本信息

enjoyasp.net 未分类 评论关闭

dbcc checkprimaryfile('E:dba1.mdf',2)

Syntax:DBCC CHECKPRIMARYFILE ({'PhysicalFileName'} [,opt={0|1|2|3}])

PhysicalFileName is the full path for the primary database file.

opt=0 - checks if the file a primary database file.
opt=1 - returns name, size, maxsize, status and path of all files associated to the database.
opt=2 - returns the database name, version and collation.
opt=3 - returns name, status and path of all files associated with the database.

本文地址:http://enjoyasp.net/?p=3169 , 转载请保留.

本文的评论功能被关闭了.