From: Niranjan on
C:\Documents and Settings\[Username]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM

change [Username] by your username of system

This help is only for XP OS.
here you will find a mru.dat.
Delete that file.
When SMSS start next time it will create new file.



MohitKGupt wrote:

Do you mean in the SQL Server Logs?
22-Jun-07

Do you mean in the SQL Server Logs? You can use sp_cycle_errorlog to cycle
the log into Archive logs...


--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005

Previous Posts In This Thread:

On Friday, June 22, 2007 12:29 PM
Darren.Ratcliff wrote:

Clear connection history
Hello

Does anybody know how to clear the logon/connection history in SQL
Management Studio 2005.

Many thanks

Darren

On Friday, June 22, 2007 1:44 PM
MohitKGupt wrote:

Do you mean in the SQL Server Logs?
Do you mean in the SQL Server Logs? You can use sp_cycle_errorlog to cycle
the log into Archive logs...


--
Mohit K. Gupta
B.Sc. CS, Minor Japanese
MCTS: SQL Server 2005


Submitted via EggHeadCafe - Software Developer Portal of Choice
Visual Studio.NET: Cool Debugging Tricks
http://www.eggheadcafe.com/tutorials/aspnet/9015d813-2cbd-4004-bb20-af0b319f0ad5/visual-studionet-cool-d.aspx
From: Aaron Bertrand on
Caution: this isn't the only thing you lose when you blow away this file.
See this blog post (and more importantly the follow-up comments):

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/03/18/managing-the-mru-
list-for-the-connect-to-server-dialog-in-ssms.aspx




On 12/16/09 12:55 AM, in article 2009121605543yadavniranjan01(a)gmail.com,
"<Niranjan yadav>" <> wrote:

> C:\Documents and Settings\[Username]\Application Data\Microsoft\Microsoft SQL
> Server\90\Tools\ShellSEM
>
> change [Username] by your username of system
>
> This help is only for XP OS.
> here you will find a mru.dat.
> Delete that file.
> When SMSS start next time it will create new file.
>
>
>
> MohitKGupt wrote:
>
> Do you mean in the SQL Server Logs?
> 22-Jun-07
>
> Do you mean in the SQL Server Logs? You can use sp_cycle_errorlog to cycle
> the log into Archive logs...
>
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
> Previous Posts In This Thread:
>
> On Friday, June 22, 2007 12:29 PM
> Darren.Ratcliff wrote:
>
> Clear connection history
> Hello
>
> Does anybody know how to clear the logon/connection history in SQL
> Management Studio 2005.
>
> Many thanks
>
> Darren
>
> On Friday, June 22, 2007 1:44 PM
> MohitKGupt wrote:
>
> Do you mean in the SQL Server Logs?
> Do you mean in the SQL Server Logs? You can use sp_cycle_errorlog to cycle
> the log into Archive logs...
>
>
> --
> Mohit K. Gupta
> B.Sc. CS, Minor Japanese
> MCTS: SQL Server 2005
>
>
> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Visual Studio.NET: Cool Debugging Tricks
> http://www.eggheadcafe.com/tutorials/aspnet/9015d813-2cbd-4004-bb20-af0b319f0a
> d5/visual-studionet-cool-d.aspx