Clear connection history Answer
in [Server Configuration]
|
Prev: Performance and sys.dm_db_index_physical_stats
Next: past comprehension - Timeout expired. SQL server 2008, ADO NET, IIS
From: Niranjan on 16 Dec 2009 00:55 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 16 Dec 2009 16:01
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 |