Forum Replies Created

Viewing 15 posts - 2,866 through 2,880 (of 2,893 total)

  • RE: Subset Data Extraction: Pull or Destructive method?

    How frequently do you need to refresh the data ??

    I use transactional & snapshot replication to get subsets of production databases to other databases. Then users can query the subsets...

  • RE: Scheduled job won''''t run

    What does it show under "Next Run Date"  ??

    Sometimes I've had the job enabled, but the schedule was not enabled. They both must be enabled.

    Perhaps there's an "end date" in...

  • RE: Moving database from one server to another

    If you backup the database on the "old" server, then do a restore on the "new" server, it will create the database as part of the restore.  You might want...

  • RE: Adding a column and moving its position on a table being replicated

    I had to do something similar a while ago.  I think I did something along the lines of:

    - Script out the steps to delete the publication and save it. 

    -...

  • RE: Why do they make it difficult

    You can use "snapshot" replication instead of "transactional" replication for tables that don't have a primary key.  This will replace the table each time instead of just sending changes, so...

  • RE: transactional replication distribution

    You want to set up replication on other servers (B & C) that's the same as what you have now (server A)?

     

    If you just want to copy the publication, you can...

  • RE: Change dbo login name

     

    What about making objects DBO owner to start with, such as tables and stored procs ?

    Does a user have to be a System Administrator in order for their...

  • RE: Worst Practices - Objects Not Owned by DBO

    Does a user have to be a System Administrator in order for their objects to automatically be DBO owner ?

  • RE: Dropping publication

    Not sure, but how about using sp_droppullsubscription first to get rid of the orphan subscription, then maybe you can drop the publication ? (Either through EM or manually via...

  • RE: can I alter a table column name thru TSQL

    I go into EM, make all the changes, choose "Save change script" to capture all the commands, then exit without saving the actual changes.

    Or sometimes I do save the actual...

  • RE: Jobs not running at all

    The job itself is enabled, but how about the schedule entry ? Right click the job >> Properties >> Schedules >> Edit ......... Is the enabled...

  • RE: list user sprocs that contain a certain word

    I did this recently .......

    I just used Enterprise Manager to generate a SQL script for all SPs, but put them all to one file big on your C drive, then...

  • RE: Backing up Tran Log

    Use SIMPLE if going back to the last FULL backup is good enough (usually used in test or light usage environments).

    Use FULL if you want the security of...

  • RE: where do you have your backups go?

    Similarly to others here, I back up to another drive, deleting the previous day's backup. After the backup, the network backup copies my backup to tape. I also backup...

  • RE: RE: Add new tables for replication

    You should be able to add it through Enterprise Manager ...... That's how I do it.

Viewing 15 posts - 2,866 through 2,880 (of 2,893 total)