Member of the LearnItFirst.com Video Training Network Related Video Training Sites: · SQL DTS Training Videos · SQL Programming Videos
     
SQL Server 2000 Training Videos             * SQL DTS Training Videos
* SQL Programming Videos
* More Videobooks...
Email
Password
Register
LearnSqlServer2000.com Subscriber Videos
SQL Server 2000 Videos By Category Home  Subscriber Videos  
Replication in SQL Server 2000 - Video Category (all video categories)
Video Image SQL Server replication is a very popular choice for everything from synchronizing small, handheld devices with SQL Server CE installed to doing complete disaster recovery solutions. This category of videos will help you understand SQL replication and will walk you through setting it up, creating distributors, managing publications and subscribing.

Videos in this Category: orange = video series 
blue = individual video 
Click "Download" to download the video or click the video title for more information
TitleSkillView / DownloadLength
Series (3 videos) - An Overview of Replication: What It Is and How It Works   200 (Click for Videos) 36 mins.
Series (3 videos) - Configuring Transactional Replication in SQL Server 2000   200 (Click for Videos) 47 mins.
< Return to list of all videos
Miscellaneous Bits & Pieces:
You can disable the "sa" account by setting your SQL Server security mode to Windows Authentication Only. You will still have an "sa" account but it will not be able to log in to your SQL Server
Don't forget that calls to @@ERROR and @@ROWCOUNT change after each statement. Most programmers prefer to store these global variables in a local variable immediately for later processing
Many people get confused about licensing for their SQL Server when their SQL Server is used for the company website. Bottom line: buying one license for your SQL Server because the web server is only one user is not sufficient. Microsoft requires that each connection that takes advantage of the data from your SQL Server be licensed.
Video search
Company News
T-SQL training videos
     
Home | About Us | Advertising | Become an Author | Contact Us | Privacy | System Req's | Terms | Testimonials | Work for Us! | Blogs | Site Map Refer a Friend and Get a Free Subscription!
© 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.
7/3/2008 6:22:25 PM