Configuring a Post Snapshot Script
Often in replication we'll need to apply some indexes or permissions to objects created on the subscriber. By setting up a post snapshot script we can apply those changes automatically, leaving one less step for the DBA to do.
|
|
|
|
Duration:
|
5
mins
20
secs
|
|
Skill Level:
|
100
|
|
Rating:
|
4.29
out of 5
|
|
Publish Date:
|
October 02, 2009
|
|
|
|
About the Author
|
|
Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.
|
|
References
|
There are no downloads or recommended reading links for this video
|
|
|
Comments
|
|
You lost me on the error handling in the script
|
|
|
They should have given an explaination why i need to use it and what it is for.
|
|
|
gg
|
|
manu jaidka on
11/16/2009
Nice one. Elaboration on try catch will help.
|
|
|
Wish there was more info on why you need/want this.
|
Must Be Logged In
|