SQL Server DBA Tutorial 155-Upgrade of SQL Server 2008 R2 to SQL Server 2012 Part5

In this video you will learn,
1- How to execute Login script on destination server as part of Login transfer from SQL Server 2008R2 to SQL Server 2012
2- What is Orphan Users in SQL Server
3- Limitation of Login Transfer script
4- How to manually give sys admin permissions to a SQL Server Login
5- How to create Linked server using T-SQL Script
6- How to reset Linked Server Security Password
7- How to create SQL Server Login Trigger using T-SQL Script
8- How to modify replication script to point to valid server
9- How to put password in script during replication setup
10- How to create distribution database using T-SQL Script
11- Troubleshooting Replication in SQL Server
Blog post link for the video
sqlage.blogspot...
Visit our website to check out SQL Server DBA Tutorial Step by Step
www.techbrother...