From: esquel@sommarskog.se   
      
   redbull (redbull@libero.it) writes:   
   > I am developing/testing a program written in vb with stored procedure.   
   > I run 2 processes of this program ( 1 in realease in mode and the other   
   > in debug mode for tesing concurrency). At same time I wanna keep open   
   > sqlserver management studio but I can't: impossible to open the physical   
   > file:"pleiadi.mdf", system operative error 32:"32 file is used by   
   > another process)" microsfot sql server error: 5120)   
      
   Am I right to guess that your connection string includes   
      
      UserInstance=true   
      
   and   
      
      AttachDBFilename=....   
      
      
   In such case you are starting up two user instances, that both tries   
   to attach the same file.   
      
   Unless you have any particular reason to use these options, I would   
   suggest that you remove them, and specify the database name with the   
   connection-string property Initial Catalog.   
      
   If you want to use user instance and the AttachDBFileName option,   
   you need to have multiple instances of the database file, and   
   construct the path to AttachDBFilename accordingly.   
      
   > On the other hand, if database is open with sqlsms, when i try to launch   
   > my program i get the error:   
   > Impossibile to open the defult user database: user 'evs_I5-PC\evs_I5'   
   > can't access   
      
   When you connect with SSMS you connect to the parent instance for the   
   user instances.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)