Forum Replies Created

Viewing 15 posts - 151 through 165 (of 279 total)

  • RE: Problema when a JOB execute a stored Procedure

    Can you provide the table definition of TRA_LOTE_DOC_TRANSPORTE ?

    Also, did you try the commands I posted previously?

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Problema when a JOB execute a stored Procedure

    I recall having had a similar issue, and I am not sure if this was what solved the problem.

    Alter the Stored procedure and add this above the ALTER line:

    SET ANSI_NULLS...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Select first record from duplicate records

    :hehe: I wish I had these canned answers too... I used to refer users on a different forum to this link...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: SQL Sever Native client license

    Well, again....it depends on your Server licensing scheme.... IF the server is licensed per CPU, then yes, you could say your client access is "free", but if your server is...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: SQL Sever Native client license

    It depends on what type of licensing your SQL Server/Instance is licensed with.

    If the server is licensed per Server, you would need a CAL (Client Access License).

    If the server is...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: how much RAM(memory) used by sql server 2005

    Paul White (9/11/2009)

    I just read it. Um. Trying to be positive here: ok - he meant well. 😛

    Sorry dude, but that's muddled advice right there, and what isn't...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: how much RAM(memory) used by sql server 2005

    Another great read on these always confusing settings is from Vipul Shah's SQL Blogs

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Maximum size of a database that SQL Server 2005 clustered allows

    That's correct, you are more likely to hit hardware limitations than DB size limitations (for both clustered and non-clustered)....

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Maximum size of a database that SQL Server 2005 clustered allows

    I don't think there is any difference in the limits between clustered and non-clustered, but seriously are you getting anywhere close to 524,258 terabytes to start worrying about it????

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Blocking

    .... a cluster failover is not more than a shutdown on one side and restart on the other one, which involves the rollback anyway when the DB is started up.....

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Are there issues with ONLINE INDEX REBUILD

    wjones21 (8/31/2009)


    Richard M (8/31/2009)


    wjones21 (8/31/2009)


    My company is obviously concerned about the 10 hour+ exposure without a backup

    We also change the T-Log backup to every 5 minutes so it doesn't grow...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Are there issues with ONLINE INDEX REBUILD

    wjones21 (8/31/2009)


    My company is obviously concerned about the 10 hour+ exposure without a backup

    Why 10+ Hours? Unless your hardware is on the low end and with slow disks it shouldn't...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: DBMail Profiles

    I might be mistaken, but If I recall correctly you can setup different connectors, possibly even on different IP's on Exchange so that messages sent to that internal IP get...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: SQL licensing for a training version of a web site

    If I read correctly how MS Licenses the Developer Edition:

    SQL Server 2005 Developer Edition is licensed per developer and must be used for designing, developing, and testing purposes only.

    Testing ...

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • RE: Round a price

    Krasavita (8/18/2009)


    no, how would I get ext_PriceClass.Price Thank you

    ... umm.. not sure I follow you there. That would be the field selected in your query?

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

Viewing 15 posts - 151 through 165 (of 279 total)