ramyours2003
SSChampion
Points: 12268
More actions
March 24, 2015 at 8:58 am
#305963
how to identify whether the files are in read write or read only ?
Cadavre
SSC-Forever
Points: 41690
March 24, 2015 at 9:05 am
#1786008
Did you try searching? I'd have thought that a quick Google search would've answered this question for you far quicker than waiting on a forum.
https://msdn.microsoft.com/en-us/library/ms174397.aspx
SELECT file_id,
name,
physical_name,
is_read_only
FROM sys.database_files;
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply