New SQL Server 2005 Video Tutorial: Part 1 - How to Make a Table Read-Only in SQL Server

Part 1 - How to Make a Table Read-Only in SQL Server - view details

You are probably already familiar with the idea of how to make an entire database read-only but, if you want to make one or more tables read-only (but not the entire database), it gets complicated fairly quickly. This video, part one in our series on how to make tables read-only in SQL Server 2008/SQL Server 2005, outlines the four steps you must take to make a SQL table read only.

Highlights from this video:

• Differences between making a database read-only and a table read-only
  
• What steps do you have to take to make a table read-only?
  
• What are filegroups?
  
• How do filegroups help?
• What are the TSQL commands to add a new filegroup or modify a file group?

and much more

---

• Source: http://www.learnsqlserver.com
• Category: Miscellaneous - Topics That Don't Fit Anywhere Else!
• Skill Level: 500 (Advanced)
• Length: 9:15 (16.0MB)
• Applies to Versions: SQL Server - All Versions
• Full Details

---

To download this video, log in, then visit the video's detail page and click "download". This is a subscriber-only video so a subscription is required.

Note: You must have the TSCC codec installed to view this video

---

Keywords Associated with this video: performance tuning, advanced, filegroups, data files, read only