Results 1 to 6 of 6

Thread: Running .SQL Scripts - sql 2005

  1. 11-20-2006, 04:43 AM #1
    orf
    orf is offline Registered User
    Join Date
    Nov 2006
    Posts
    3

    Running .SQL Scripts - sql 2005

    Hi all

    im new to SQL 2005 and im regularily works with sql 2000 and queryanalyzer as the tool for running .sql scripts..

    in sql 2000 after connceting once to the server i always open .sql files from a folder and running them one by one...

    in sql 2005 after openning each file i have to conncet again to the server.. is it a property or by design???

    tks in advance..
    Or
    Reply With Quote Reply With Quote
  2. 11-20-2006, 08:58 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    It's by design.
    Reply With Quote Reply With Quote
  3. 11-20-2006, 11:29 AM #3
    orf
    orf is offline Registered User
    Join Date
    Nov 2006
    Posts
    3

    Thanks...

    Reasonable design or a bug called design???
    Reply With Quote Reply With Quote
  4. 11-20-2006, 05:16 PM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Should ask Microsoft, I think they like to enforce security.
    Reply With Quote Reply With Quote
  5. 11-21-2006, 02:16 AM #5
    orf
    orf is offline Registered User
    Join Date
    Nov 2006
    Posts
    3
    yeh... tks anyway..
    Reply With Quote Reply With Quote
  6. 11-22-2006, 03:40 PM #6
    jezemine
    jezemine is offline Registered User
    Join Date
    Aug 2006
    Posts
    57
    supposedly in some cases, SSMS will reuse the connection from the currently active window:

    http://blogs.msdn.com/bprang/archive...13/512607.aspx
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules