Forum Replies Created

Viewing 15 posts - 16,726 through 16,740 (of 19,560 total)

  • RE: Error on TSQL

    Could you provide sample data?

    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

  • RE: invalid login for user on sql 2000 standard

    Good to hear.

    Thanks for updating back to the thread.

    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

  • RE: DB security

    You're welcome.

    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

  • RE: Inserting zero in Identity Column

    I think your app is not creating the table as it should. Using DBCC CheckIDent will permit you to verify the identity value of the table before you insert...

    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

  • RE: Unable to find table in the database

    K. Thx

    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

  • RE: Are the posted questions getting worse?

    Lynn Pettis (3/8/2010)


    Should have posted this Saturday.

    My daughter, Kirisa, made the JV squad during tryouts. This weekend (Friday and Saturday) she played 3 games at the Mesa Ridge Tournament...

    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

  • RE: Replication Issue - URGENT - Please help!

    You're welcome.

    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

  • RE: Index size

    Roy Ernest (3/8/2010)


    Good One jason... No Cursors.. 🙂

    I could use that script as well...

    Thanks Roy.

    Just pounded it out today.

    I tried assigning "NULL" to the variable like:

    Set @DBName = NULL

    That doesn't...

    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

  • RE: Replication Issue - URGENT - Please help!

    Angelindiego (3/8/2010)


    One more piece of info I wanted to share....I opened up the replication script for TESTBED and it has in there the variable @replication_DDL = 1 (I think that...

    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

  • RE: Replication Issue - URGENT - Please help!

    Angelindiego (3/8/2010)


    My question is this: I found this code (see below)....can I incorporate it WITHIN my other alter script, or do I need to break out the replicated tables...

    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

  • RE: Are the posted questions getting worse?

    Got it.

    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

  • RE: Converting Access Queries with iff() and DLookup() to SQL Server

    Paul White (3/8/2010)


    Ok, so I was bored :laugh:

    err...Understatement??:-P

    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

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/8/2010)


    Ok..I am hooked...What does it depend on?

    Who pays for the trip. :-P:-D:-P:-D:-P

    Being the multicentair that I am, it would seriously depend on time of year, who else is...

    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

  • RE: Are the posted questions getting worse?

    Roy Ernest (3/8/2010)


    Thanks for giving me a count on the number of attendees for SQL Saturday.

    A theoretical question....

    If a SQL Saturday was arranged in our tiny island of Curacao,...

    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

  • RE: Are the posted questions getting worse?

    GilaMonster (3/8/2010)


    george sibbald (3/8/2010)


    ok, now is this a double bluff or is jason not paying attention?

    Somehow I suspect the latter. 🙂

    hmmm.

    Jason must not be paying attention. I thought George...

    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

Viewing 15 posts - 16,726 through 16,740 (of 19,560 total)