![]() If you are not able to find the file "SqlStudio.bin" at above locations then search this file in system drive and remove or rename it.After removing or renaming, launch the SSMS and you will not see any of the most recently used servers in the list. ![]() Now remove or rename the file "mru.dat" from the location "C:\Documents and Settings\ \Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin" or "C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\SqlStudio.bin" Clear recent connection list from SQL Server 2008 or 2008r2įirst of all make sure that the SSMS is closed. If you are not able to find the file "mru.dat" at above locations then search this file in system drive and remove or rename it.After removing or renaming, launch the SSMS and you will not see any of the most recently used servers in the list. Now remove or rename the file "mru.dat" from the location "C:\Documents and Settings\ \Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat" or "C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\mru.dat" Clear recent connection list from SQL Server 2005įirst of all make sure that the SSMS is closed. To resolve this issue, we should clear this server list from SSMS. Sometimes this list create confusion and we can try to make the connection to SQL Server which does not exist or we does not have access to it. As a result of this SSMS has a list of diffrenet SQL Server which we have used. While working with SQL Server, we connect to the different-different data server. Exception Handling in SQL Server by TRY…CATCH.Different Types of stored procedure sql Server.Definition, Use of Group by and Having Clause.Different Types of Triggers In SQL Server.Create a comma separated list from column using select statement.Delete Duplicate Rows in SQL Server From a Table.Remove unsent database email from SQL Server.Get nth highest and lowest salary of an employee.Get field name, data type and size of database table.Difference between Stored Procedure and Function in SQL Server.Inserted, Logical Deleted table in SQL Server,.Drop all tables, stored procedure, views and triggers.Swap the values of two columns in SQL Server.Clear List of Recent SQL Server Connection From SQL Server Management Studio.How to insert values to identity column in SQL Server.Calculate Running Total, Total of a Column and Row.Understanding SQL Server Case Expression with Example.Difference between CTE and Temp Table and Table Variable.Difference between Primary Key and Unique Key.SQL Integrity Constraints or Constraints.Different Types of SQL Server Functions.Difference between inner join and equi join and natural join.Difference between Primary Key and Foreign Key.JavaScript ES6 Interview Questions Answers BookĪSP.NET Web API Questions and Answers Book NET Framework Questions and Answers BookĪSP.NET and AJAX Questions and Answers BookĮntity Framework 6.x Questions and Answers BookĮntity Framework Core Questions and Answers BookĪzure Administrator Questions and Answers BookĪzure Developer Questions and Answers Book ![]() NET Design Patterns Questions and Answers Book NET Microservices Certification TrainingĪSP.NET MVC with WebAPI Certification TrainingĪWS Solutions Architect Certification TrainingĪzure Fundamentals Certification TrainingĪrtificial Intelligence Certification Courseĭata Science with Python Certification Courseĭocker and Kubernetes Certification Trainingįrontend Foundations Certification Training
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |