Forum Replies Created

Viewing 15 posts - 8,386 through 8,400 (of 9,720 total)

  • RE: I am getting the below error while executing the Job. Can any one advice me on this

    NP. Glad we could help.

    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: Microsoft Documentation

    Sounds like you had a cache problem. Happens sometimes.

    No worries. Glad we could try to help, anyway. @=)

    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: Microsoft Documentation

    Wait, nevermind.

    Tools-> Options works for all.

    Then go to Help -> Online.

    At the top is the various types (online first or local first). On the left, underneath that, are check boxes....

    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: Microsoft Documentation

    Ken,

    How are you accessing BOL? Via the program files menu or via SSMS?

    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: Stored Procedures

    You're absolutely right, JacekO. There's nothing left to be said on the subject except, from what I read, you are the only person you proved your point to. I didn't...

    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: Stored Procedures

    lee.pollack (3/19/2009)


    please remember that my company is still using sql2000 - so WHILE does not exist for me

    Lee,

    You can also nest IF...ELSE statements and CASE statements. It could 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.

  • RE: Stored Procedures

    JacekO (3/19/2009)


    The SQL Server transactions can be called nested transactions but they are not. Plain and simple. If they were nested they should work the way I described. There might...

    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: Stored Procedures

    Lee,

    Before I go any further, Label 1 confuses me.

    label1:

    -- 1st check - do we have a customer record in CP

    IF EXISTS (Select * From DATABASE.OWNER.TABLE 6 WHERE cust_id = @memvar...

    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: Stored Procedures

    JacekO (3/19/2009)


    From my point of view they are not nested but maybe I could call them chained. To explain how I understand the term nested I provided an example...

    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: Microsoft Documentation

    Ah. I forgot local help could be disabled.

    But shouldn't he still be getting something from the online stuff, assuming he has a network connection?

    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: Microsoft Documentation

    Wow. That's a new one.

    You say it was working before?

    Has anything changed since then? Any programs removed from your box? Anything added (service packs,etc.)?

    Check Windows Explorer and see if you...

    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: Stored Procedures

    Nesting is a broad term. You can nest triggers, stored procedures, transactions, IF..Else statements and loops.

    Basically, a "nest" is when you embed one thing inside of another and the internal...

    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: Stored Procedures

    I should also clarify that I don't advocate nested stored procedures (which is different from nested transactions).

    I've never had any reason to use them, though, and I know of at...

    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: Stored Procedures

    Lee,

    I think you misunderstood me. Nested transactions can be wonderful things, if you need them. If you don't, I don't advise indulging because it's a lot of wasted effort.

    What I'm...

    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 2005 DBmail via SMTP server

    At this point, you need to contact the help desk of your third party mail server and maybe even engage Microsoft in the problem. It sounds like an issue on...

    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 - 8,386 through 8,400 (of 9,720 total)