Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Argentina
    Posts
    26

    Unanswered: Two connections inserting in the same table

    Hi,

    Is there anyway for two (not bound) connections to insert rows in the same table at the same time? (and, is it possible for one connection to delete some rows while the other one is inserting other rows in the same table at the same time?)
    Can I force the level of granularity that has to be used with a certain table? If I set this granularity level to row level, will different connections be able to insert rows into a same table simultaneously?



    Thanks,

    Federico

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to books online for Locking Architecture topic.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •