Viewing 15 posts - 586 through 600 (of 1,158 total)
DKlein (2/3/2012)
To answer my own question, yes. Replication is still working.Thanks,
DK
🙂
The snapshot is not needed when initialising from a backup. I would even go so far as disabling it...
February 4, 2012 at 2:01 am
Completely unfounded. Deadlocks would only occur on the subscriber if the data were being modified (unlikely). There's no more chance now than there was before
February 3, 2012 at 6:57 am
Cadavre (2/2/2012)
Brandie Tarvin (2/2/2012)
I couldn't help myself. I responded to the awkward responder. Maybe if we talk to him, he might start paying more attention to what he's doing.
I made...
February 2, 2012 at 2:30 pm
Oh, and the green "play" button will start the debugger for you
February 2, 2012 at 2:24 pm
Would you like step by step screen shots or to be pointed in the right direction and assisted with learning? If you aren't willing to help yourself then don't expect...
February 2, 2012 at 2:23 pm
You can use sp_addsubscription with @sync_type = N'none' or @sync_type=N'replication support only'
none will do nothing and the subscriber side replication procedures will be untouched.
replication support only will regenerate the ...
February 2, 2012 at 10:03 am
Rofty (1/26/2012)
Wait ... so how do I that?PS: I realised my previous response was epicly idiotic.
Simplest way is to Alter the sp_msdel_tablename stored procedure on the subscriber and add a...
February 2, 2012 at 9:45 am
Business Intelligence Development Studio comes with the SQL tools. Create a new SSIS project and add existing file.
I suggest you do some research into SSIS as I suspect it...
February 2, 2012 at 9:39 am
guerillaunit (2/2/2012)
February 2, 2012 at 9:22 am
Not possible. You will need a named instance for each
Alternatively, you can create one database with each set of tables using a different schema.
February 2, 2012 at 8:18 am
If this is regular you can create a custom SSIS package to wrap it up
February 2, 2012 at 8:17 am
Saga... (2/2/2012)
Thank you Howard & Grant. I will try to make memory availability at least 8Gb
Thats still pretty slim. I have more than that on my Windows 7...
February 2, 2012 at 7:11 am
SQLRNNR (2/2/2012)
putz
a stupid, ignorant person; someone who doesn't pay attention to anything going on; one who makes stupid remarks
Only slightly offensive but since its not used in UK English I'll...
February 2, 2012 at 7:01 am
nature_cbe (2/2/2012)
Count Length
1 10
2 5
3 5
4 ...
February 2, 2012 at 6:35 am
Viewing 15 posts - 586 through 600 (of 1,158 total)