Viewing 15 posts - 721 through 735 (of 5,103 total)
You can set up transactional replication and then ensure two things:
- Don't replicate "deletes"
- Prevent updates to unique columns from being replicated as "delete+insert" instead of "updates"
As long as...
January 13, 2009 at 11:03 am
Good call about the schema changes! I was not considering that the PO could want that but it is entirely possible.
January 13, 2009 at 10:58 am
SQL Server does not even let the creation script succeed for char(9000)
January 13, 2009 at 10:05 am
As long as your "changes" are not too big any of the tools above or some scripting with the free "tablediff.exe" will do it!
January 13, 2009 at 9:39 am
I agree with RBarryYoung. A "double" hop replication is the best way here. Merge replication does NOT uses the distributor except for "historic" information. It is definitely Doable but not...
January 13, 2009 at 9:08 am
Yes it is possible but you should ensure that the "inside" can get to the DMZ and NOT the other way around.
January 13, 2009 at 7:44 am
weirdlNet (1/8/2009)
I failed to recreate a publication that I have previously removed on my testing server.
After I removed the publication, I restored the database from a backup copy...
January 13, 2009 at 7:40 am
renu.ap (1/9/2009)
Im having similar issue. log file at subscriber grows larger while archiving data at publisher.giving large head ache.
pls suggest soln.......
if transactional integrity is not a problem at susbcriber take...
January 9, 2009 at 10:26 am
Lowell (1/7/2009)
urgent? if you had read the chapter or listened to the lecture in class....
hehe ... You got that RIGHT!
January 7, 2009 at 2:39 pm
You should profiler and find the offending query!
January 7, 2009 at 2:38 pm
vick.ram79 (1/7/2009)
solves the problem. Like:
with myCTE(
somedata)
as(SELECT TOP 5 somedata FROM Table2 order by...
January 7, 2009 at 2:27 pm
I am assuming you
want this:
set @_AsOfDate = @pAsOfDate
set @_AsOfDate = dbo.svf_GetPriorMonthEndDate_asofdate()
to be this :
set @_AsOfDate = dbo.svf_GetPriorMonthEndDate_asofdate(@pAsOfDate)
January 7, 2009 at 1:42 pm
there is no "THEN" in TSQL use BEGIN...END if you need demarcation.
January 7, 2009 at 1:39 pm
You could try to move the logs using FTP then you don't need a domain account for the copy just FTP access.
January 7, 2009 at 1:24 pm
Viewing 15 posts - 721 through 735 (of 5,103 total)