Results 1 to 2 of 2

Thread: User creation script SQL and VBScript

  1. #1
    Join Date
    Dec 2003
    Posts
    43

    User creation script SQL and VBScript

    We have a vbscript that creates user accounts based on fields in a SQL 2000 database. I have created a view that gathers the necessary fields and the vbscript SELECT * from this view.

    The problem is that when I run the same query, SELECT * FROM viewname, it works fine using query analyzer but when run from the script it holds locks on the tables and blocking occurs.

    Should I look to change the vbscript or could I use lock hints in my view to prevent this? Thanks.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    I'll use lock hint.

Posting Permissions

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