Forum Replies Created

Viewing 15 posts - 2,671 through 2,685 (of 2,897 total)

  • RE: Cannot open User Default Database.

    Why Pubs instead of Master ??   Because Master is too dangerous to mess with  ?

  • RE: Replication problem

    Some more detail perhaps ?   This occurs while creating the publication or subscription ?  At what point in the process ??   What type of replication ?  

  • RE: Cannot open User Default Database.

    I think that was it ... Thanks !.   I set all the group logins to Master & things are back to normal.

  • RE: Need Help Deciding if Replication Would Work in this Situation

    You have to check the Advanced Options box in the create Publication wizard in order to get the option to enable subscriber updates, otherwise the default is no updating.  I...

  • RE: Couldn''''t be a more Newbie question.

    What sort of results are you looking for ?   You want to update the table to look something like this ?  

    September 29, 2005 at 2:45 pm

    #594180

  • RE: Cannot open User Default Database.

    I'm really sorry about the multiple posts.  I was getting the memory errors on the site just as I was trying to post, and it seems to have put miltiple...

  • RE: reinitialization vs. snapshot

    I think you could say that Reinitialization is "flagging" the subscription to get the next snapshot, provided that a new snap shot is run, then the agent is run.  If the...

  • RE: Need Help Deciding if Replication Would Work in this Situation

    Wouldn't transactional replication WITHOUT immediate updating subscribers work ?  Then you'll just be replicating from A to B only. 

  • RE: Service Pack

    FYI ... You might want to re-post this under a SQL Mail title for better feedback.

  • RE: Service Pack

    I've had SQL mail working with Notes .... and I've also had it stop working for no apparent reason. Currently I'm bypassing Notes and bouncing of a different server. We're...

  • RE: Service Pack

    SQL Mail ?  uugghh ........  that's a whole separate issue ... SP4 won't help

  • RE: Service Pack

    Enterprise Manager, right click the server -->> Properties  then look at the "Product version"

    Or run @@version, but that displays the actual build #, which is a little less clear  (eg  8.00.2039...

  • RE: Recover Database from Trn log

    If it's a production DB, then "simple" is not recommended because then you cannot recover to a point in time. You'll only be able to recover back to the last...

  • RE: Recover Database from Trn log

    You can't recover a database from just a transaction log. The TRN contains activity against the database, not the database itself.  The DB is growing, or the log is growing...

  • RE: ALTER TABLE - ADD column

    Yes, the table gets rebuilt .... I just meant to show that a script could be generated of the process and run outside of EM.

  • Viewing 15 posts - 2,671 through 2,685 (of 2,897 total)