Solving this problem is very easy:
- Go to control panel.
- search for services.
- Open Local services window from your search results
- Restart your MSSQLSERVER service.
Screenshot of the steps:
More Related Contents:
- What is the best way to create and populate a numbers table?
- Sql Server string to date conversion
- SQL Server query to find all permissions/access for all users in a database
- How to get Time from DateTime format in SQL?
- Natural (human alpha-numeric) sort in Microsoft SQL 2005
- SQL Server IN vs. EXISTS Performance
- How much size “Null” value takes in SQL Server
- SQL Server Pivot Table with multiple column aggregates
- PIVOT in sql 2005
- What is the maximum characters for the NVARCHAR(MAX)? [duplicate]
- Atomic UPSERT in SQL Server 2005
- SQL Server sp_msforeachtable usage to select only those tables which meet some condition
- Is it possible to force row level locking in SQL Server?
- SQL Server ORDER BY date and nulls last
- SQL Server – Dynamic PIVOT Table – SQL Injection
- How to remove accents and all chars a..z in sql-server?
- Find non-ASCII characters in varchar columns using SQL Server
- How to query values from xml nodes?
- How to query for Xml values and attributes from table in SQL Server?
- Unable to begin a distributed transaction
- What happens to the primary key Id when it goes over the limit?
- What is the point of “Initial Catalog” in a SQL Server connection string?
- How do you kill all current connections to a SQL Server 2005 database?
- SQL Server recursive query
- Milliseconds wrong when converting from XML to SQL Server datetime
- Why is casting from float to varchar being rounded in SQL Server?
- Difference between database and schema
- What are row, page and table locks? And when they are acquired?
- Cross Domain SQL Server Logins Using Windows Authentication
- Forgot SQL Server Password