Forum Replies Created

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

  • RE: Need help with an ERROR message

    Architecture matters. Is the application housed locally, or are the remote users trying to log into the database directly from their long distance away?

    SQL Server has a very SMALL...

  • RE: ODBC Compatibility

    There is no easy answer to this question, because there's no way to tell what 'tricks' your VS 5 implementation is using with SQL 6.5 that is incompatible with SQL...

  • RE: select query in reporting services

    Sounds to me like a chained list - for each entry in Pulldown A, give me all possible choices from Pulldown B. Won't a nested double query work for...

  • RE: Cannot disable NTgroup users using Alter Logins script

    It occurs to me that there's a problem with 'disabling' the password, depending on how the ID is used. IF you have administrative rights to the machine, then you...

  • RE: Deadlocks

    GilaMonster (7/15/2008)

    Try doing a save-as

    http://download.microsoft.com/download/f/1/c/f1cf7b8d-7fb9-4b71-a658-e748e67f9eba/RowVersioningBasedIsolation.doc

    I've greatly enjoyed this thread, and a belated congratulations, Gail, on being named an MVP!

    Thanks. It's turning out to be a very good year.

    The problem was...

  • RE: Deadlocks

    Jonathan Kehayias (7/15/2008)


    Kimberly Tripp wrote an excellent WhitePaper on Row Versioning-based Transaction Isolation that I would recommend as a read for this topic:

    She covers in depth the comparison of this...

  • RE: Alter table script in SQL server 2005 Express

    If I understand everyone else's responses correctly, then

    1. You only want to control the column order to support smooth internal operation and enhance efficiency within SQL Server's internals.

    2....

  • RE: Cannot disable NTgroup users using Alter Logins script

    What Login are you using to disable? If you can't 'trump' the NT login, then you don't have sufficient rights, and that would trigger the error message.

    Can YOU login...

  • RE: case sensitive schema

    Simon_L (7/1/2008)


    steve smith (6/30/2008)


    Why bother with standards?

    A question I seem to get asked more and more ..

    "agile standards " anybody ?!

    And, if standards aren't agile, how long...

  • RE: Remote link issue

    balbirsinghsodhi (6/30/2008)


    Looks to me weird problem. I am running distributed quries on the server and it's working fine with all the tables except one. I am getting following error while...

  • RE: case sensitive schema

    Why bother with standards? Because the improve predictability and allow one to focus on the important issues, like what does the code say? What is expected behavior, and...

  • RE: replication problem over vpn

    Having just come from the same church, different pew, check the following:

    Surface configuration: Make sure that TCP/IP is enabled for SQL Server, and experiment with Named Pipes turned off...

  • RE: Connecting from SQL Server A to SQL Server B fails

    For those of you who wondered what might have happened.... I had confused myself by entering a Windows login and password into a SQL Server place for login and password,...

  • RE: Connecting from SQL Server A to SQL Server B fails

    Sorry for the lagged response - I was diverted for a bit, but am now back.

    Noeld - 'named' subscription? This is a push, not a pull.

    Everyone - on a...

  • RE: TCP/IPtricks in Merge Replication?

    noeld (6/4/2008)


    HOSTS or LMHOSTS are a way to BYPASS DNS queries. so your network client does not need to resolve the Computer Name.

    I can appreciate the use to avoid DNS...

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