Forum Replies Created

Viewing 15 posts - 1,426 through 1,440 (of 2,838 total)

  • RE: Strange dm_db_index_physical_stats query problem

    Ninja's_RGR'us (9/23/2011)

    Stefan Krzywicki (9/23/2011)

    Ninja's_RGR'us (9/23/2011)

    yes remove the USE 😀

    Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 11:11 am

    #1385930

  • RE: Strange dm_db_index_physical_stats query problem

    Ninja's_RGR'us (9/23/2011)

    yes remove the USE 😀

    Then the join with sys.indexes won't work. I've never had the need for it, but I'm sure there's a way around it with...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 11:01 am

    #1385921

  • RE: Strange dm_db_index_physical_stats query problem

    Ninja's_RGR'us (9/23/2011)

    Ya in compat 80 you can't use a function as a parameter for another function.

    Compat mode change the way tsql behaves. The "ironic" twist here is that if...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 10:56 am

    #1385913

  • RE: Strange dm_db_index_physical_stats query problem

    Ninja's_RGR'us (9/23/2011)

    Run the code taht fails but from the other db.

    It fails because it's in compatibily mode 80.

    Alternatively you could just swap DB_ID('ABPMaster') with the db id and the code...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 10:47 am

    #1385900

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (9/23/2011)

    Now I feel like an idiot and a little naive for using Amazon so much: http://t.co/gm3hPsGv

    That is 19th century standard practice, it seems barbaric now...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 9:34 am

    #1385855

  • RE: Are the posted questions getting worse?

    Jim Murphy (9/22/2011)

    Say, anyone here know how to admin Sharepoint? Things like changing permissions to the calendar and stuff like that?

    People are asking me but I don't have a...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 8:06 am

    #1385769

  • RE: How to loop through SQL Table from SSIS to get file names and export

    sullyf50 (9/23/2011)

    i am new to this how do i put a new tread

    all i want is some help in exporting all tables in ssis

    If you click the Forums tab on...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 23, 2011 at 8:03 am

    #1385766

  • RE: Are the posted questions getting worse?

    Evil Kraig F (9/22/2011)

    Kiara (9/22/2011)

    L' Eomot Inversé (9/22/2011)

    You can get some mileage (but not much) on some Gaelic from Google Translate by telling it it's Irish; but because the Irish...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 22, 2011 at 4:17 pm

    #1385485

  • RE: Are the posted questions getting worse?

    jcrawf02 (9/22/2011)

    Anybody ever go looking for an answer in the Forums, find the perfectly phrased question for your problem, only to find out it was you who posted it in...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 22, 2011 at 10:44 am

    #1385310

  • RE: Are the posted questions getting worse?

    Roy Ernest (9/22/2011)

    ALZDBA (9/22/2011)

    Roy Ernest (9/21/2011)

    Apologies in advance for the change in topic... 😀

    I want to do a presentation for the SQL saturday that will be conducted in Curacao. Can...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 22, 2011 at 9:45 am

    #1385264

  • RE: Can't establish connection to Oracle

    HowardW (9/22/2011)

    Actually, this is going to be a tricky one to solve. From what I can see, the latest driver that can connect to Oracle 7 (and it actually mentions...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 22, 2011 at 6:30 am

    #1385098

  • RE: Are the posted questions getting worse?

    GilaMonster (9/22/2011)

    Jim Murphy (9/21/2011)

    And where's Gail? Is she not keeping you guys in line?

    Doing the final checks and tweaks on Jonathan's book.

    Keep this lot in line? How would I...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 22, 2011 at 3:54 am

    #1385012

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (9/21/2011)

    Stefan Krzywicki (9/21/2011)

    That sounds pretty funny. I'd think if it were really the best, the consultant would be able to say "Oh, you just have this configured wrong,...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 21, 2011 at 2:10 pm

    #1384795

  • RE: Can't establish connection to Oracle

    Jo Pattyn (9/21/2011)

    I could be that the oracle 11 client is limited to Oracle 9.

    *

    Have to find my oracle support login as it is on metalink

    Yeah, I was worried about...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 21, 2011 at 2:00 pm

    #1384785

  • RE: Can't establish connection to Oracle

    Jo Pattyn (9/21/2011)

    not sure if there were servicenames in 7.2, it is probably a SID.

    What are the results of oracle basic connectivity testing?

    in command prompt:

    tnsping myoldandtrusty

    ->shows location of the oracle...

    --------------------------------------
    When you encounter a problem, if the solution isn't readily evident go back to the start and check your assumptions.
    --------------------------------------
    It’s unpleasantly like being drunk.
    What’s so unpleasant about being drunk?
    You ask a glass of water. -- Douglas Adams

    September 21, 2011 at 1:38 pm

    #1384768

Viewing 15 posts - 1,426 through 1,440 (of 2,838 total)