question

spatel avatar image
spatel 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
instance
sql.gif (47.9 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
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
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ruancra avatar image
ruancra answered
Try this sp_dropserver 'servername'
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
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
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.