Hi guys
I am trying to open a database which is on a shared drive. The database is
stored in the 'my network places'. Now when I try to copy  the database into
my hard disk, it says "sharing violation, file in use' whereas nobody else is
using it except me.
SQL does not recognise the shared path as it is installed locally on my hard
disk.
Im using sql server 2005
PLease help guys

I'm not clear on what you mean by the last part of "SQL does
not recognise the shared path as it is installed locally on
my hard disk". You don't want to use network shares for SQL
Server data, log files.
In terms of not being able to access the files to copy to
your hard drive, you can use FileMon from sysinternals to
see what process or what user has the files in use:
http://www.sysinternals.com/Utilities/Filemon.html

-Sue

On Sun, 5 Nov 2006 11:39:02 -0800, mita
<m***@discussions.microsoft.com> wrote:

Show quoteHide quote

Utility for Table Schemas
Table Changes
repost: SqlServer 2005 => SMS => Object Explorer => Programability Filter question
SQL Server 2000: Stored Procedure to tell file size & free space
Query Analyser - output SQL commands to Results pane