Viewing 15 posts - 3,136 through 3,150 (of 6,216 total)
We've had a few threads and some articles on this. In particular Robert Marda has written about it quite a bit, here is a good place to start:
http://www.sqlservercentral.com/columnists/rmarda/dynamicsqlversusstaticsqlp1.asp
Andy
October 3, 2002 at 4:06 pm
Sure its working correctly on the orig server? Tried sp_refreshview on it? Shots in the dark. All tables in the view in the same db?
Andy
October 3, 2002 at 3:21 pm
Wont hurt anything..in the log anyway! Transaction cant be removed until processed by the logreader. This true even for local things that dont get replicated like index rebuilds that generate...
October 3, 2002 at 2:18 pm
I've used them in Access via a DSN quite a bit, only issue I've seen there is that Access doesnt look at the underlying tables and so doesnt know what...
October 3, 2002 at 1:12 pm
More servers can get expensive in a hurry, hardware + software + manpower. It is ridiculous. Whats worse to me is when your INTERNAL users go, hey, I need a...
October 3, 2002 at 11:45 am
Possibly raiserror would cause it to fail, have not tried it. You could write a flag to a table/file, then have the next step check it to see whether or...
October 3, 2002 at 11:38 am
Not one that they plan to fix I think. Merge replication has some other limitations, limiting the table size to around 6k characters.
If you rename your current table, split it...
October 3, 2002 at 5:12 am
Split the table in to two or more, replicate separately, create a view so you can work with it as one (if you must!).
Andy
October 2, 2002 at 7:02 pm
I'd say one advantage that's easy to sell and take advantage of is that it's cheap. You can do some small projects using MSDE, gives you a chance to show...
October 2, 2002 at 6:56 pm
Give them a process that inserts a row in a table, run a job that checks and manages the agents. Right now I do the same thing using Outlook, checking...
October 2, 2002 at 7:12 am
CE supports merge replication if you install SQL CE, I've seen some demos that looked good. Only downside I saw is that changes are done at the row level, not...
October 2, 2002 at 6:32 am
October 2, 2002 at 6:09 am
Give me a day or two I'll see what I can find. Kinda busy at work these days!
Andy
October 1, 2002 at 8:45 pm
Interesting idea. I'll have to think about that for a while!
Andy
October 1, 2002 at 8:43 pm
October 1, 2002 at 6:07 pm
Viewing 15 posts - 3,136 through 3,150 (of 6,216 total)