Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SSIS Training Videos · SQL Programming Tutorials
   
SQL Server Training Videos
SQL Server DBA Videos in Series Home  Subscriber Videos  

How to Make a Table Read Only in SQL Server 2005/2008 (Video Series)

Video Image Video Category: Miscellaneous - Topics That Do Not Fit Anywhere Else!

Skill Level: 500 (Advanced)

Versions/Editions Covered: SQL Server 2005 , SQL Server 2000 , SQL Server 2008
Do you have a SQL Server table that you need to make read only? It's quite easy in SQL Server to make an entire database read only but how do you make a single table read-only? It takes quite a few steps actually.

This video series, a three-part series, shows you how to mark an individual SQL table as read-only. Along the way, you'll learn a little about the architecture of SQL Server 2008/2005 including a little about filegroups and data files. For many people, this advanced technique - making one or more tables read-only - is a performance tuning technique. Is it for you? Watch this series and find out!

Videos in this Series:


Miscellaneous Bits & Pieces:
The command-line command "xcopy" has been improved to allow you to create decrypted files at the destination (hint: use the /g option)
Want to see something cool? Run DBCC OPENTRAN (<insert your database name here >) WITH TABLERESULTS to view the most recent transaction details
The TIMESTAMP data type name was replaced in Microsoft SQL Server 2000 by the ROWVERSION data type. They are the same; nothing changes but the name

Other Websites We Offer
LearnVBProgramming.com
Don't Forget!
100% Money Back Guarantee
 
   
 
About Us Video Playback Subscriptions More Video Training More
 
© Copyright 2004-2008 LearnItFirst.com LLC. All rights reserved. All trademarks remain the property of their respective owners. This site is not affiliated in any way with the Microsoft Corporation. Refer a Friend and Get a Free Subscription!
 
11/20/2008 11:48:31 PM