How do I unmap a disconnected network drive in Windows 7?

I can't test this here as I'm not on a network, but I think it's a case of doing this:

1. Right-click Network in Windows Explorer.
2. Select Disconnect network drive....
3. In the list that appears, right-click the drive you wish to remove and select Remove.

I think it's something like that but as I say, I can't test it here.

On the command line (substitute your drive letter for z):

net use z: /delete

On the command line, try:

net use

This shows all currently mapped drives. If the one you're looking for is in the list, you can use:

net use x: /delete

where X: is the drive you're trying to remove. But if the drive has been removed, there may be no such drive letter shown. In that case, just type the Remote identifier for the mapping:

net use 192.168.10.11\WorkFiles /delete

For the disconnected drive, for those who have SQL Server Management Studio in your pc, just run this query.

Exec master.dbo.xp_cmdshell 'net use x: /delete'

• change the 'x' according to the drive name..
• not sure if it will work with other database..
• if your xp_cmdshell is not working or inactive, and this error occurs:

SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.

Enable the xp_cmdshell by running this query:

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

There is a more forceful way to get rid of dead links to mapped network drives.

You could delete the reference in your registry.

Just open "regedit.exe" and expand the key "HKEY_CURRENT_USER" and the key "Network". There you will see keys with letters that will represent the Mapped Drive Letters. When you delete a letter on "regedit.exe", the mapped drive letter will vanish on the next Windows restart cycle.