Forum Replies Created

Viewing 15 posts - 6,286 through 6,300 (of 9,722 total)

  • RE: Are the posted questions getting worse?

    Every so often, I stop and remember that I learn (or remember) things much better if I have to explain it or teach it to someone else.

    I thought about...

    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.

    March 17, 2011 at 7:38 am

    #1299936

  • RE: backup taking long time

    Ah, yes. The good old network backup. Actually, the bad old network backup.

    Don't use them. Make all your backups locally, then move them over the network. That way, if 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.

    March 17, 2011 at 5:52 am

    #1299880

  • RE: SQL Server Conditional Join

    hector__21 (3/17/2011)

    Brandie Tarvin (3/16/2011)

    You can also put a CASE statement in your ON clause, forcing the code to make up a number or default to a value that will keep...

    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.

    March 17, 2011 at 5:39 am

    #1299873

  • RE: Importing Data from access Database backup

    I'm asking because your reply confused me a bit. Did my response actually help you out / answer your question? Or do still need this answered?

    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.

    March 17, 2011 at 5:25 am

    #1299869

  • RE: LINKED Server does not return all records.

    kashif.nadeem (3/17/2011)

    2) Production database or dev database?

    Production databases both LINKED SERVER DB AND THE ONE WHERE I HAVE CREATED LINKED SERVER.

    Okay. I can understand the Linked Server DB being 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.

    March 17, 2011 at 5:23 am

    #1299868

  • RE: Today's Random Word!

    Donut

    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.

    March 17, 2011 at 4:57 am

    #1299864

  • RE: How to monitor multiple sql servers by a script?

    Grant Fritchey (3/16/2011)

    Brandie Tarvin (3/16/2011)

    There are a lot third party tools for sale that will monitor multiple servers, also. I believe both Imceda and Red Gate have software, along with...

    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.

    March 17, 2011 at 4:56 am

    #1299863

  • RE: SQL Mail

    GSquared (3/16/2011)

    Brandie Tarvin (3/16/2011)

    I'm not sure what you mean by "and the end". Could you clarify?

    Notifications on jobs are not related to job steps and not configured by step. They...

    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.

    March 17, 2011 at 4:55 am

    #1299862

  • RE: Are the posted questions getting worse?

    Jeff Moden (3/16/2011)

    Craig Farrell (3/16/2011)

    GilaMonster (3/16/2011)

    I object, I'm a model of good behaviour

    well, compared to others on that list anyway...

    Isn't that like saying you're a 'nice' barbarian because you only...

    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.

    March 17, 2011 at 4:51 am

    #1299858

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/16/2011)

    Buck has clothing problems.

    TMI! TMI!

    Someone get me the brain bleach!

    :sick:

    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.

    March 16, 2011 at 12:36 pm

    #1299582

  • RE: SQL Mail

    I'm not sure what you mean by "and the end". Could you clarify?

    Notifications on jobs are not related to job steps and not configured by step. They are a separate...

    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.

    March 16, 2011 at 12:35 pm

    #1299581

  • RE: How to script a remove 'IDENTITY(1,1)'

    edvard 19773 (3/15/2011)

    I have app. 150 tables in the DB, which i control and uses.

    The customer has two tables, which they use as their link to my db.

    And they claim...

    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.

    March 16, 2011 at 12:33 pm

    #1299579

  • RE: Identity column gernerating non unique value

    Just a thought. Identity_Insert could be set ON for that table and data coming from elsewhere is forcing duplicate values in.

    Or someone might have reseeded the table.

    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.

    March 16, 2011 at 12:29 pm

    #1299576

  • RE: Job appears to run successfully, but doesn't.

    I agree with Steve. It sounds like the code is missing something or deliberately excluding something.

    Do a search in the catalog views for a proc with that name, 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.

    March 16, 2011 at 12:26 pm

    #1299574

  • RE: SQL Server Conditional Join

    You can also put a CASE statement in your ON clause, forcing the code to make up a number or default to a value that will keep the records that...

    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.

    March 16, 2011 at 12:24 pm

    #1299573

Viewing 15 posts - 6,286 through 6,300 (of 9,722 total)