asked
instances, how to remove names instance
Hi I have default instance and named instance as (local). in the drop down list how can i remove this named instance. sonu-pc is the default instance as this is the name of my computer. also in the window i have this express instance appearing though i have removed this, it still appears inthe drop down list for server names. how do i clear.![alt text][1] [1]: /storage/temp/665-sql.gif
The list itself is stored in application data store of your windows user profile. The solution is to delete the file that stores the server list. A description can be found here: [How to remove “Server name” items from history of SQL Server Management Studio][1] Please note, if you are on Windows 7 and above that the location of the user profile has changed. [1]:
http://stackoverflow.com/questions/1059105/how-to-remove-server-name-items-from-history-of-sql-server-management-studio
Try this sp_dropserver 'servername'
No, that won't do the job. What [sp_dropserver][1] does is remove the knowledge of a SQL Server instance from SQL Server itself - ie removes a reference to something like a linked server or a remote server. [1]:
http://msdn.microsoft.com/en-us/library/ms174310.aspx
14 People are following this question.
