winmansoft (1/21/2013)
If i create a file group with read only then how can i insert the values to the table?
You can't. That's what read only means.
What is the use of read only file group?
Historical data. Static lookups. Anything that doesn't change.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability