sql-server2008 Database Publishing Subscriptions

Reference Blog Park article http://www.cnblogs.com/tyb1222/archive/2011/05/31/2064944.html

Add a security database

Change the database name SQL statement

Select @ @servernameSelectSERVERPROPERTY ('servername') sp_helpserverexecSp_dropserver@server = 'Guide-sql-bak'execsp_addserver@server ='Guide-sql-bak',@local = 'LOCAL' 

Using SQL Server to publish a database snapshot encounters an error: "XXXXX" access to the path is denied by using SQL Server to publish a DB snapshot in the configuration, if you chose to use SQL Server Agent, and SQL  This error occurs when the login identity used by the Server Agent service does not have read and write access to the location of the snapshot file. The www.2cto.com workaround is to modify the logon identity of the SQL Server Agent service by selecting the SQL Server service in the left column of the program->sql server Configuration manager->- > Right-click on the SQL Server agent row in the right panel, select Properties, and in the dialog box that pops up, select "Built-in account"->localsystem. Note: The same gateway is feasible

sql-server2008 Database Publishing Subscriptions