Forum Replies Created

Viewing 15 posts - 3,526 through 3,540 (of 9,725 total)

  • RE: Are the posted questions getting worse?

    I'm still at work 2 hours past leaving time. And going to get caught in rush hour traffic. JOY. :crying:

    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.

    July 3, 2013 at 2:56 pm

    #1629681

  • RE: Database in suspected mode

    Brandie Tarvin (7/2/2013)

    You really need to get HIRE someone with replication experience...

    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.

    July 2, 2013 at 11:42 am

    #1629232

  • RE: Database in suspected mode

    You really need to get someone with replication experience in your environment to temporarily help you with 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.

    July 2, 2013 at 10:48 am

    #1629215

  • RE: Are the posted questions getting worse?

    GilaMonster (7/2/2013)

    Brandie, you can be sooo evil. 🙂

    Hee. If he can be vague, so can I. @=)

    EDIT: Oh, wait. You meant the OTHER post. (I am cackling right now. Is...

    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.

    July 2, 2013 at 8:16 am

    #1629112

  • RE: Database in suspected mode

    Krasavita (7/2/2013)

    Before I delete it,is there way to find out what was execly replicating from one db to another? thank you

    Didn't you make those notes before you deleted the...

    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.

    July 2, 2013 at 7:43 am

    #1629079

  • RE: Database in suspected mode

    At a guess, you'll have to delete the job, create a new publication, and create a new job for the publication. Books Online should have the information you need.

    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.

    July 2, 2013 at 6:48 am

    #1629042

  • RE: Are the posted questions getting worse?

    jasona.work (6/25/2013)

    GilaMonster (6/24/2013)

    You shrunk a database? How could you???

    :hehe:

    Uhh, with this:

    DBCC SHRINKFILE('WBT', 150000)

    😉

    Blasphemy. Sheer Blasphemy.

    Someone take away his golden SysAdmin key. Expel him from the ranks of the SQL Conspiracy...

    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.

    June 25, 2013 at 5:47 am

    #1627068

  • RE: SQL Server Agent jobs running under SA

    jasona.work (6/21/2013)

    Likely if you don't think you're using it, you're probably not (Filestream that is), but easy enough to check:

    exec sp_configure 'filestream access level'

    If the config value is 0, then...

    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.

    June 21, 2013 at 9:19 am

    #1626373

  • RE: SQL Server Agent jobs running under SA

    Well, neither of the jobs did what I needed them to do. They both used the domain account properly. So that test is a bust. I'll have to hope I...

    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.

    June 21, 2013 at 8:49 am

    #1626355

  • RE: SQL Server Agent jobs running under SA

    Steve Thompson-454462 (6/21/2013)

    I may be a little out of depth here, but is there any chance someone set up a proxy and put that in the Run As option for...

    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.

    June 21, 2013 at 8:06 am

    #1626332

  • RE: SQL Server Agent jobs running under SA

    wolfkillj (6/20/2013)

    Well, I have to say I'm stumped.

    Just to clarify, I understood from what you've posted that the SQL Agent service startup account is a Windows domain account that is...

    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.

    June 21, 2013 at 5:54 am

    #1626290

  • RE: SQL Server Agent jobs running under SA

    jasona.work (6/20/2013)

    OK, I don't know if this might help, but I found a similar issue elsewhere:

    Link to topic

    ...

    (PS, I do see on one of my servers in sysprocesses an NTLogin...

    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.

    June 21, 2013 at 5:48 am

    #1626289

  • RE: Possible article on persisting last SSRS parameter choices

    NP. Look forward to seeing the article.

    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.

    June 21, 2013 at 5:41 am

    #1626284

  • RE: SQL Server Agent jobs running under SA

    foxxo (6/21/2013)

    I'd like to question if it is actually running as sa.

    Is it the same if you use sys.dm_exec_sessions rather than the old sysprocesses?

    Also can you write the current security...

    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.

    June 21, 2013 at 4:43 am

    #1626272

  • RE: Possible article on persisting last SSRS parameter choices

    Check out this link: http://www.sqlservercentral.com/articles/SQLServerCentral/69267/%5B/url%5D

    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.

    June 21, 2013 at 4:22 am

    #1626262

Viewing 15 posts - 3,526 through 3,540 (of 9,725 total)