Post reply

Using Excel''s Microsoft Query on SQL Server 2000 (Locks?)

  • May 8, 2006 at 11:42 pm

    #114539

    Hi,

    SQL Server 2000 Database, 80 odd users hammering Order Entry and now I've got a guy who wants to use Microsoft Query on the Transactional DB to run live reports.

    I am a little unsure as to whether this tool will create any locks or create unexpected results.

    Any advice or direction as to where I could find possibly find an article on this would be greatly appreciated.

    My gut says don't do it.

    Thanks in advance

    Gavin

  • May 10, 2006 at 10:33 am

    #637055

    Of course there is always the possibility of creating locks whether it's running a badly written query in Query Analyzer or a poorly written report (doesn't matter if it's Access, Excel, Crystal, etc.)  If you have the option to say "no", do so.  I saw a query once was killing a database that was 3 pages long--not kidding.  A user created a report in Excel and basically joined many tables and had many conditions, but didn't realize that he was getting a Cartesian result.  He doesn't create reports any more 🙂

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

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