How does SQL Server treat multiple data loads?

  • If I am viewing data on a SQL Server and an automated process is loading information onto the server at the same time are there any conflict issues,

    Given that the same table is NOT being loaded and viewed at the same time?

  • You should't have any problem. Run sp_who2 and check for another process locking the tables that you are viewing.

  • I'm assuming that you ask this because something went wrong with the load. How many licenses, is the database in sql user mode or dbo use only?

    quote:


    If I am viewing data on a SQL Server and an automated process is loading information onto the server at the same time are there any conflict issues,

    Given that the same table is NOT being loaded and viewed at the same time?


    John Zacharkan


    John Zacharkan

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply