RE: SQL2K CLONE
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-12
career
RE: Replication through triggers
Hi racosta, quote: Only transactional replication must have primary keys in all the published tables. But you can still use merge or snapshot. are there any pitfalls when implementing merge replication? Cheers, Frank
2003-06-12
1 reads
RE: Stored Procedures parameter
You could consider calling the procedure from a loop, and then using a variable to determine the values being used. Lots of overhead for the server, since loads of results can be generated. If the results pane of QA is 'in text', you messages can appear before the result set of each iteration. Here is […]
2003-06-12
RE: Replication through triggers
You could consider using the triggers to perform the remote updates. To do this you can look at building distributed transactions to perform the actual updates. Remember to set xact_abort option on if trying this method. DTs require RPC which may make the overally transaction quite slow. Best advice Build the primary keys and then […]
2003-06-12
1 reads
RE: Replication through triggers
You can still use merge replication, which actually uses a trigger system to keep track of changes. PK are not required for merge.
2003-06-12
2 reads
RE: Selecting different records from a same column
Still not sure what you want to accomplish. If the idea is to fetch the two indexvalues from the database in a single statement, consider writing a stored procedure. You would pass in the necessary variables and get the two indexes back. CREATE PROCEDURE up_fetchindexvalues @month0 int, @year0 int, @month1 int, @year1 int, @index varchar(10), […]
2003-06-12
RE: Primary key / DTS load question
Thanks to all for your suggestions. mccorks view methodology has worked best here as performance hit is very small on large loads (200,000 - 2m). DDQ of drmccue works fine on anything under 1000 rows. Anythin above that and the individual processing of each row slows things right down.
2003-06-12
1 reads
RE: SQL MAIL - PROBLEMS
Try loading MS Outlook on the server (Outlook 2000 for SQL Server 2000), and set up an Mail Profile for the login which the Server Service uses. You can then test the MAPI separately. Now select that Mail Profile and test. Remember that if any changes are made to the MAPI settings you must restart […]
2003-06-12
RE: Save output of DBCC SHOW_STATISTICS into a table
Auch, didn't look at the Forum, looks like this one should be moved too
2003-06-12
2 reads
RE: SQL MAIL - PROBLEMS
SqlMail works with MAPI 1.0 http://support.microsoft.com/default.aspx?scid=kb;EN-US;311231
2003-06-12
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers