Forum Replies Created

Viewing 15 posts - 5,356 through 5,370 (of 9,722 total)

  • RE: Job failure Notification

    Deepak,

    No matter what you do, there will always be an element of manual work in this process. Someone will forget to add notifications to the job they create, or 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.

  • RE: Are the posted questions getting worse?

    The difference between tech writing and fiction writing?

    Fiction writers get to lie for a living, disguising it as the truth.

    Tech writers have to tell the truth, making sure the truth...

    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.

  • RE: Shrink Database

    SanDroid (8/12/2011)


    Brandie Tarvin (8/12/2011)


    SanDroid (8/11/2011)


    I am only a Microsoft Certified Trainer and Red Cross Volunteer.

    Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused....

    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.

  • RE: Job failure Notification

    Look at sysjobhistory in msdb. The message column will give you minimal details about failures (run_status = 0). The table seldom has the space to store all the details of...

    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.

  • RE: Sharepoint deleting/dropping link to Data Source for SSRS reports

    It sounds like someone or something is removing the data source connection from SSRS.

    Check the report to see where the data source connection is pointing to. Often times, SSRS will...

    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.

  • RE: Transaction log is growing on Mirrored database

    I don't advise shrinking it at all. The log space is growing because the database needs it.

    If you're running out of hard drive space, add more as either a...

    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.

  • RE: Are the posted questions getting worse?

    Hey, all. I don't know much about this subject (Other Wait statistics). Can anyone help this poster? He hasn't had any answers at all since he posted early yesterday:

    http://www.sqlservercentral.com/Forums/Topic1158300-146-1.aspx

    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.

  • RE: What is an associated remote login?

    Linked server is exactly right. Usually, you will have a local login mapped to a remote login to provide access between servers.

    Look up Remote Login Mapping in Books Online 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.

  • RE: SQL Server 2005 Cluster moving to new data center

    IP change may affect your Foundation agents / hubs and your cluster virtual name (may need to refresh the link). Other than that, it shouldn't affect much. (I think.).

    However, 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.

  • RE: ODBC drop and SQL Server

    Depends. Was SQL Server down or restarting during this incident?

    If not, it's probably a network issue or the ODBC was deleted, or the users lost permissions to reach the ODBC,...

    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.

  • RE: Job failure Notification

    I schedule my jobs to print to an error log for each step and check Include Step Output. For SSIS packages, I use the Operating System job step format (instead...

    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.

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (8/12/2011)


    Congratulations and good luck, Lynn.

    Ditto.

    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.

  • RE: Are the posted questions getting worse?

    Roy Ernest (8/11/2011)


    Wonderful. Congratulations.

    Thanks. @=) And thanks to everyone else, too.

    Roy Ernest (8/11/2011)


    How do you make time to write? I have been writing(Planning to write an article) for a long...

    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.

  • RE: To improve the performance of the query.

    sqlmaverick (8/11/2011)


    I don't know how to attach the code separately.

    Putting the code in a code block is relatively easy. When you post, look to the left of the text box...

    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.

  • RE: Shrink Database

    SanDroid (8/11/2011)


    I am only a Microsoft Certified Trainer and Red Cross Volunteer.

    Wow. I'm a Red Cross Volunteer too. I teach swimming. But I'm a little confused. How does Red...

    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.

Viewing 15 posts - 5,356 through 5,370 (of 9,722 total)