Changing and setting drive lebels via C#

Question

Could anyone out there provide some insight into how to alter drive labels via C# using WMI or something else? To clarify, in an explorer window you will not that the C:\ drive for instance is normally labelled by default as "LOCAL DRIVE". I want to enumerate the drives on a local system, and apply specific labels to each one debending on their drive letter.

Answer 1

Hey Devendra

There might be any software glitches, take the backup of your database from the physical path located at

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA

 

then reinstall the Sql Server again, then try attaching all your database.

 

Hope this helps :) 

Answer 2

Go to > Security > Logins > Right click to the user > Properties

On the left navigation move to > User Mapping > Check the database and in the "Database role membership for: <>" check "db_owner"

  

Or just restart the SQL service, sometime it also helps 

Answer 3

@Rafnas, already tried, also restarted the service but :(

Answer 4

Thanks Daniel, The error still exists as master/any database was also not accessible. Logins section displays only builtin\users and sa

Answer 5

try running in administrator mode, to do that

right click on SQL Server Management Studio and select run as administrator