So, are you sure that the version of the trigger that got applied at the subscriber is the correct one? Just trying to think of explanations. I use the NOT FOR REPLICATION on dozens of triggers and all works as expected. Also, when and where do you get the nested error? At the time of […]
2003-05-04
2 reads
Hi, I'm facing a deadlock problem, and I think that it might be a classic one: Some stored procedure use temporary tables (# ones) that are often called. At the beginning of a call, a table is created. At the end of the call, the table is droped. Those two statements require locks on tempdb..sysobjects, […]
2002-03-27
146 reads
I have to create a duplicate of our production server to test a software upgrade. I have never used SQL- don't know scripting etc. But here's the problem: SQL 7, NT 4 box. Built with same logical drive configuration, etc. Magic Enterprise is the application using SQL. After the clean install of SQL and Magic […]
2002-03-12
2 reads
hi, I'm working on the architecture design for a project which will involve normalising data tables from an old Clipper/DBF system. What we plan to do is import the data (via some custom written code - standard INSERTs) from the DBF's into a staging SQL database which will be an exact replica of the DBFs. […]
2002-01-11
5 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers