Viewing 15 posts - 361 through 375 (of 576 total)
Triggers is what you need! Just rememeber to place the NOT FOR REPLICATION statement in the Triggers!
August 3, 2004 at 6:59 pm
Make sure that the recovery model is set to "Simple".
You can also periodically shrink the Database.
July 29, 2004 at 11:38 pm
Is the Recovery Model "Simple"?
The "Simple" Recovery Model will truncate the log once the transaction has been comitted.
July 29, 2004 at 6:01 pm
I have seen this before!
BETWEEN perfroms an Inclusive Range where as > and < perfroms an Exculsive Range.
I haven't really made sense of this myself but thats the way it...
July 21, 2004 at 6:08 pm
The first query you need to perform is;
SELECT * FROM Table2 WHERE PrimaryKeyID NOT IN (SELECT PrimaryKeyID FROM Table1)
This will give you the records that are not in Table1 but...
July 20, 2004 at 5:43 pm
As long as the previous SP has has completed and dropped the Temp Table, I couldn't see this is an issue!
July 20, 2004 at 5:30 pm
I have installed configured developed and administered SQL Server Replication for 5 years now! Within that time I have also done the same for Sybase! In terms of replication, they...
July 18, 2004 at 9:32 pm
It's possible that you may have "Auto Close" set for this Database. Can you check to see if this is the case? If it is, turn it off!
July 18, 2004 at 5:49 pm
I have experienced both Microsoft SQL Server Replication & Sybase Server Replication. They both produce the same result however, in comparison to Microsoft SQL Server, the Sybase tools are hopeless,...
July 18, 2004 at 5:19 pm
Alternatively, just limit the result set in your WHERE Clause!
July 14, 2004 at 5:45 pm
Thats correct. I don't believe SQL Server records that sort of information. SQL Server 2005 may do though!
July 14, 2004 at 12:11 am
You have answered your own question!
Just do a TOP 10
As you have stated above, "maybe the first 10 lines", the TOP Clause is what you need!
July 13, 2004 at 8:08 pm
I agree! More thought needs to go into the question!
July 13, 2004 at 6:00 pm
You will have to DROP the Publication, make the modifications on all Databases(Subscribers) and then recreate the publication without doing the initial snapshot. Alternatively, if the Databases are small enough, then just...
July 13, 2004 at 1:14 am
Check to see that SQL Mail is configured and working properley.
July 12, 2004 at 5:50 pm
Viewing 15 posts - 361 through 375 (of 576 total)