Viewing 15 posts - 2,716 through 2,730 (of 2,897 total)
" ........ Familiar Creep ...."
I thought you were talking about the guy upstairs in Accounting who's always bothering us !!!
September 16, 2005 at 12:53 pm
Have you done rowcounts to confirm that the tables have the data they should ? Also, it might be better to replicate from A -> B and A-> C. Then...
September 16, 2005 at 11:06 am
"When danger reared its uglu head, Sir Robin turned his tail & fled ......" (pretty close I think)
I have fond memories of my Parents waking us up at 11:00 pm...
September 15, 2005 at 5:16 pm
You could write a script to get counts of your publisher tables and subscription tables and check that the counts match
September 15, 2005 at 9:43 am
Are you using ASP.NET, or "old" ASP ?? In ASP.NET, you can call the DTS, so that it's all part of the application. Write the DTS, then save it as...
September 15, 2005 at 9:36 am
DTS is set up to import "Comma", "Tab", "Semicolon", or "Other" (such as "pipe" or any other character) Comma & Tab are quite common, so bringing in a .CSV or...
September 15, 2005 at 9:29 am
Adam, I think my post the other day was similar to what you encountered .... trying to separate different text records to be imported into SQL. Richard Kemp responded and...
September 15, 2005 at 9:16 am
Just wondering .........
I ran the "TOP SQL CACHE" query listed above, and got results, but when & why would you run that ? I'm not familiar enough with that data...
September 15, 2005 at 9:10 am
Depending on how you have it broken up, you could do your backups, then zip the .BAK files to save space. Then perhaps you could keep more of them on...
September 14, 2005 at 4:12 pm
That sounds like what I need ! Where do you run the FIND command from ?
As a test, I'm trying it from the Windows command line, but I can't get...
September 14, 2005 at 9:32 am
Would it be possible to fix the data, rather than back it out & reload it ? When your "fixed" data comes in, join it to your live table and...
September 14, 2005 at 8:43 am
In BOL, under FIRE_TRIGGERS, ... "No result sets generated by the insert triggers are returned to the client performing the bulk copy operation."
Is that relevant to what you hoped...
September 14, 2005 at 8:38 am
We have a third party application that seems to do deferred updates as part of their processing. I noticed this when analyzing the results of triggers from their replicated tables....
September 13, 2005 at 9:09 pm
Yes, there is an issue with SP4. Go to the "Service Pack" forum, and chaeck out
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=48&messageid=216677
It has a link to another forum with an extensive discussion of the problem. ...
September 13, 2005 at 6:49 pm
Viewing 15 posts - 2,716 through 2,730 (of 2,897 total)