how to read first two letters from the string
hi , iam using asp.net with c#.
in my login the user names are 0198, 0276,03....05
when the user logins then based on the first two letters digits 01,02,03
i have to display all departments in a dropdownlist
how to seprate this starting two letters when user login
can you give example which helps me
Answers (2)
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 :)
Accepted 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
1
@Rafnas, already tried, also restarted the service but :(
1
Thanks Daniel,
The error still exists as master/any database was also not accessible.
Logins section displays only builtin\users and sa
0
try running in administrator mode, to do that
right click on SQL Server Management Studio and select run as administrator