Tutorials to .com

Tutorials to .com » Asp » Database » The implementation of DTC with asp

The implementation of DTC with asp

Print View , by: iSee ,Total views: 9 ,Word Count: 131 ,Date: Tue, 26 May 2009 Time: 10:13 AM

DTC in SQL SERVER is a very useful tool, it allows you to automate the import, export, query, insert, such as a series of data manipulation, we can also call asp He is now my demo for everyone to see
New stored procedure
______________________
CREATE PROCEDURE doPublish
AS
exec master .. xp_cmdshell 'dtsrun / Ssqlserver / Uusername / Ppassword / NPublish'
________________________
/ S server name
/ U username
/ P password
/ Ndtc hold the name of
Asp in this way we can easily call the
cn.Execute ( "doPublish",, 1)
cn is a database connection


ASP Database Related Articles


Can't Find What You're Looking For?


Rating: Not yet rated

Comments

No comments posted.