http://www.sqlmag.com/authors/author/author/5111654/rsscomment/5111654en-USFri, 25 May 2012 10:48:56 GMTFri, 25 May 2012 10:48:56 GMThttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorMon, 10 Jan 2005 08:26:11 GMT
I have the same problem with updating the timestamp column. Is there already a solution?]]>Anonymous User Mon, 10 Jan 2005 08:26:11 GMThttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorhttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorThu, 08 Jul 2004 23:55:26 GMT
can u please elaborate on the procedure to execute the Global Procedure (Listing 4)at regular interval to carry on the replication at regular interval without using the trigger in the Publisher (Source Database).Thanks in Advance.Waiting for reply.]]>RakeshThu, 08 Jul 2004 23:55:26 GMThttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorhttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorTue, 15 Oct 2002 01:36:18 GMT
I get the same error message when trying to update a remote table width a timestamp column.]]>clemensTue, 15 Oct 2002 01:36:18 GMThttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorhttp://www.sqlmag.com/article/com-and-com/setting-sql-server-7-0-and-iis-security#commentsAnchorWed, 24 Oct 2001 09:07:50 GMT
Extremely useful article if, like me, you are new to SQL Server 2000 and have it on an ISP that enforces the use of NT accounts for database connection.]]>Wilf Johnston Wed, 24 Oct 2001 09:07:50 GMThttp://www.sqlmag.com/article/com-and-com/setting-sql-server-7-0-and-iis-security#commentsAnchorhttp://www.sqlmag.com/article/com-and-com/setting-sql-server-7-0-and-iis-security#commentsAnchorTue, 14 Nov 2000 13:36:59 GMT
I found this article extremely useful. However, it appears to work only in circumstances where the ASP pages are available for anonymous viewing. If one wants to allow access certain ASP pages using NTLM authentication to secure access, it is not possible to use the method outlined in the article (at least where the SQL Server and IIS are on different machines), as far as I can tell. The article does not apear to address this point. Is there another way to accomplish this? Thanks.]]>Scott Vanderbilt Tue, 14 Nov 2000 13:36:59 GMThttp://www.sqlmag.com/article/com-and-com/setting-sql-server-7-0-and-iis-security#commentsAnchorhttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchorTue, 24 Oct 2000 13:18:21 GMT
A very good article, but I’m getting security errors when the sp tries to update the destination table, as follows: *********************************************** Server: Msg 7344, Level 16, State 2, Procedure sp_REPL_Pacientes, Line 12 OLE DB provider ’SQLOLEDB’ could not UPDATE table ’[Roadshow].[OffLine].[dbo].[Pacientes]’ because of column ’tsREC’. The user did not have permission to write to the column. [OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.] *********************************** Any suggestions??]]>Decio Novaes Tue, 24 Oct 2000 13:18:21 GMThttp://www.sqlmag.com/article/tsql3/custom-replication#commentsAnchor