Forum Replies Created

Viewing 15 posts - 18,526 through 18,540 (of 19,560 total)

  • RE: script task transformation sql comand

    rdowty (3/19/2008)

    You must use an ADO.NET connection manager rather than an OLE DB or SQL Native connection manager. I just figured this out today, having run into the exact...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:39 pm

    #1095661

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/22/2009)

    Lynn Pettis (12/22/2009)

    Hey, this is the BEST place to waste time. I enjoy my time out in the desert!

    Which place are you from Lynn and Jason?

    Hail most...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:34 pm

    #1095658

  • RE: SQL Mail

    Bru Medishetty (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    GSquared (12/22/2009)

    There are detailed instructions online at MSDN.com for setting this up, and the pros and cons of doing so.

    In my own experience, it was a...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:20 pm

    #1095645

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/22/2009)

    Bru Medishetty (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Bru Medishetty (12/22/2009)

    Our good old friend has another doubt anyone care to answer ?

    http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

    Recollect some of his / her famous threads.

    Lock Pages in Memory

    How to...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:17 pm

    #1095640

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Lynn Pettis (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Bru Medishetty (12/22/2009)

    Our good old friend has another doubt anyone care to answer ?

    http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

    Recollect some of his / her famous threads.

    Lock Pages in Memory

    How...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:16 pm

    #1095639

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Bru Medishetty (12/22/2009)

    Our good old friend has another doubt anyone care to answer ?

    http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

    Recollect some of his / her famous threads.

    Lock Pages in Memory

    How to see password

    How...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:15 pm

    #1095638

  • RE: SQL Mail

    CirquedeSQLeil (12/22/2009)

    GSquared (12/22/2009)

    There are detailed instructions online at MSDN.com for setting this up, and the pros and cons of doing so.

    In my own experience, it was a major pain and...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:11 pm

    #1095633

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Lynn Pettis (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Bru Medishetty (12/22/2009)

    So do I, but I'm not holding my breathe.

    As evidenced by the green complexion of Yoda. I on the other hand,...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 1:08 pm

    #1095630

  • RE: Are the posted questions getting worse?

    Lynn Pettis (12/22/2009)

    CirquedeSQLeil (12/22/2009)

    Bru Medishetty (12/22/2009)

    Our good old friend has another doubt anyone care to answer ?

    http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

    Recollect some of his / her famous threads.

    Lock Pages in Memory

    How to see password

    How...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:55 pm

    #1095620

  • RE: Are the posted questions getting worse?

    Bru Medishetty (12/22/2009)

    Our good old friend has another doubt anyone care to answer ?

    http://www.sqlservercentral.com/Forums/Topic838140-5-1.aspx

    Recollect some of his / her famous threads.

    Lock Pages in Memory

    How to see password

    How to know 32...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:50 pm

    #1095616

  • RE: SQL Mail

    GSquared (12/22/2009)

    There are detailed instructions online at MSDN.com for setting this up, and the pros and cons of doing so.

    In my own experience, it was a major pain and other...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:49 pm

    #1095614

  • RE: SQL Server Auditing - Yeah that again

    We've used serverside triggers and database triggers to track logons. It helped us to locate users abusing a userid and password that they should not have been using. ...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:46 pm

    #1095609

  • RE: Sql 2005 Enterprise on Windows 2003 server Enterprise x86 (32bit) - Memory Allocation

    If you are using SQL Server 2005 to configure memory to use more than 2 GB of physical, see the following topics in SQL Server 2005 Books Online:

    Memory Architecture

    Server Memory...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:42 pm

    #1095604

  • RE: GMT vs Local Time

    I think Arizona has it right (no DST)

    😛

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:08 pm

    #1095587

  • RE: DTS package with parameter in Like statement

    Which of the results do you expect should return?

    Please provide sample data and table definitions for the best chance at getting an accurate answer to your question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 22, 2009 at 12:02 pm

    #1095582

Viewing 15 posts - 18,526 through 18,540 (of 19,560 total)