Example : How to remove the following errors from MS SQL Server 2014.

Network-related or instance-specific error occurred while establishing a connection to   SQL Server …

 - Goto 'Run' - Type 'Services.msc' - search and right click on          
   'Sql Server(MSSQLSERVER)' - select and click 'Refresh' and then     
   click on 'Start' - Restart/Reconnect Sql Server 2014.
Example : How to save or store data by modifying/editing tables in MS SQL Server 2014.
- Open Sql Server 2014 - Tools - Options - Select/click   
  'Designers' option from left pane area - Uncheck the 'Prevent   
  saving changes that require table re-creation' option - Ok.
Example : Locate/Find the place where MS SQL Server 2014 database file exists.
The path is = C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\Database_file_name.

Loading


0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.