Forum Replies Created

Viewing 15 posts - 1,756 through 1,770 (of 9,715 total)

  • RE: SQL Job Reports Emails Failure but Emails are Actually Sending

    That still looks just like the Agent error (what you see when you open up the job history). Not what's written into a text file.

    Try adding the text file as...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 11:00 am

    #1878322

  • RE: Merge Replication

    Alan.B (5/11/2016)

    There are some cases where I have used the merge agent in the past that had nothing to do with merge replication. We were doing replication between Battle Creek...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 8:23 am

    #1878255

  • RE: SSIS Upgrade error about file & project names

    tindog (5/11/2016)

    A bit of a stab in the dark but have you tried deleting the .suo file? (Close the solution first) If it's a straight upgrade and nothing else has...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 7:43 am

    #1878231

  • RE: Merge Replication

    Alan.B (5/11/2016)

    I last did any real replication in SQL Server 2008 but you can do merge in this scenario. You could also have a mix of snapshot and/or transactional and/or...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 7:26 am

    #1878223

  • RE: Merge Replication

    dastagiri16 (5/10/2016)

    Can we configure Merge Replication ..

    Like sever A(publisher) - server b(subscriber) and sever b(publisher) to server C(subscriber) ?

    The only way to know is to try it. But really, this...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 6:53 am

    #1878149

  • RE: SQL Job Reports Emails Failure but Emails are Actually Sending

    I advise going to the Advance tab of the job step and establishing a text log file. Then click the Include Step Output box. This will log everything the step...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 6:50 am

    #1878144

  • RE: Need SQL syntax help -

    mw112009 (5/11/2016)

    Question:

    I need to write the select statement that will pick the members

    who fulfill the following criteria:

    1.) Had membership coverage on the month 201512

    2.) Had coverage in any months from...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 6:46 am

    #1878142

  • RE: pre-workoutideas.com/green-coffee-zt/

    Reported

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 6:42 am

    #1878141

  • RE: Other half took nothing

    Reported

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 11, 2016 at 6:42 am

    #1878140

  • RE: Login failed password did not match for SQL loin

    solomon.jernas (5/9/2016)

    HI

    I can connect SSMS by windows account, it works.

    No problem in windows domain account,

    I can connect Via SQLCMD by SQL account, it works.

    But problem is i could not...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 10, 2016 at 4:44 am

    #1877706

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/9/2016)

    Brandie Tarvin (5/9/2016)

    Ed Wagner (5/9/2016)

    Phil Parkin (5/9/2016)

    Eirikur Eiriksson (5/9/2016)

    Who needs a desk when one can bang ones head against this?

    😎

    Occam's razor clearly does not apply in this case....

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 10, 2016 at 4:39 am

    #1877703

  • RE: Login failed password did not match for SQL loin

    solomon.jernas (5/9/2016)

    SQL port 1433 is listening on, but getting password did not match, even i given correct password in SSMS .

    i guess problem may be SSMS corrupted.

    You seem to be...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 9, 2016 at 11:39 am

    #1877548

  • RE: Are the posted questions getting worse?

    Ed Wagner (5/9/2016)

    Phil Parkin (5/9/2016)

    Eirikur Eiriksson (5/9/2016)

    Who needs a desk when one can bang ones head against this?

    😎

    Occam's razor clearly does not apply in this case. Instead, perhaps, there has...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 9, 2016 at 11:37 am

    #1877547

  • RE: Are the posted questions getting worse?

    Ever have one of those emergency "everything's down", only it's in Test/UAT. But it's still urgent because we're on a deadline to upgrade.

    And, oh, we have some data fixes to...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 6, 2016 at 11:11 am

    #1877214

  • RE: Beginner Help

    pietlinden (5/5/2016)

    Brandie,

    Just wondering... how did you build your machine that you tore apart all the time? A Virtual Machine? I might have to start doing that...

    Back in the day,...

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

    May 6, 2016 at 4:12 am

    #1877065

Viewing 15 posts - 1,756 through 1,770 (of 9,715 total)