Categories
How-To Software Technical

Remove database from read only mode, error 5120

I posted about setting a Microsoft SQL Database into ‘read only’ mode as part of an upgrade. Today I need to go back and make some changes on the now legacy system. To handle this request I needed to change back to its normal state, this is when I encountered the error 5120. In the […]

Categories
How-To Software Technical

Identify Microsoft SQL Server version & edition

I wanted to┬ádetermine which version of Microsoft SQL Server 2008 was running on one of my servers. So I opened up SQL Server Management Studio (SSMS), and ran the following command as a new query window: SELECT SERVERPROPERTY (‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’) The following results are returned: -The product version (for example, 10.0.1600.22) -The […]

Categories
How-To Software Technical

Admin Access – SQL Server 2008 R2

Recently I was asked to assist someone with access to a Microsoft SQL 2008 R2 Server. Under normal conditions I would simple add them, but this isn’t the normal. I do not have access I need, so I will add myself so that I can add them. Issue: No one seems to have admin access […]