SQL Server Profiler with C#

上传者: jljsmu | 上传时间: 2019-12-21 20:00:54 | 文件大小: 2.94MB | 文件类型: rar
找了很长时间资料,用C#实现的对SQL2008 数据库进行客户端执行SQL进行跟踪,可以捕获所有客户端对数据库的操作sql。将捕获到数据库操作存为日志,实现数据库内容的实施备份。主要使用了sql 2008 SDK的这两个动态库Microsoft.SqlServerConnectionInfoExtended.dll Microsoft.SqlServer.ConnectionInfo.dll ,程序中存日志的没有写,还有多线程操作DatagridView时程序无响应的问题,没有解决。

文件下载

资源详情

[{"title":"( 56 个子文件 2.94MB ) SQL Server Profiler with C#","children":[{"title":"SqlTrace","children":[{"title":"Form1.Designer.cs <span style='color:#111;'> 17.92KB </span>","children":null,"spread":false},{"title":"Program.cs <span style='color:#111;'> 469B </span>","children":null,"spread":false},{"title":"app.config <span style='color:#111;'> 117B </span>","children":null,"spread":false},{"title":"SqlTrace.sln <span style='color:#111;'> 857B </span>","children":null,"spread":false},{"title":"obj","children":[{"title":"x86","children":[{"title":"Release","children":[{"title":"SqlTrace.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.47KB </span>","children":null,"spread":false},{"title":"GenerateResource-ResGen.write.1.tlog <span style='color:#111;'> 374B </span>","children":null,"spread":false},{"title":"SqlTrace.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 5.46KB </span>","children":null,"spread":false},{"title":"SqlTrace.pdb <span style='color:#111;'> 21.50KB </span>","children":null,"spread":false},{"title":"SqlTrace.exe <span style='color:#111;'> 17.00KB </span>","children":null,"spread":false},{"title":"SqlTrace.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"TempPE","children":[{"title":"Properties.Resources.Designer.cs.dll <span style='color:#111;'> 4.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"GenerateResource-ResGen.read.1.tlog <span style='color:#111;'> 290B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferences.cache <span style='color:#111;'> 6.70KB </span>","children":null,"spread":false}],"spread":true},{"title":"Debug","children":[{"title":"SqlTrace.csproj.FileListAbsolute.txt <span style='color:#111;'> 1.39KB </span>","children":null,"spread":false},{"title":"GenerateResource-ResGen.write.1.tlog <span style='color:#111;'> 986B </span>","children":null,"spread":false},{"title":"SqlTrace.Form1.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"DesignTimeResolveAssemblyReferencesInput.cache <span style='color:#111;'> 5.39KB </span>","children":null,"spread":false},{"title":"SqlTrace.pdb <span style='color:#111;'> 31.50KB </span>","children":null,"spread":false},{"title":"SqlTrace.exe <span style='color:#111;'> 16.50KB </span>","children":null,"spread":false},{"title":"ResolveAssemblyReference.cache <span style='color:#111;'> 24.85KB </span>","children":null,"spread":false},{"title":"SqlTrace.Properties.Resources.resources <span style='color:#111;'> 180B </span>","children":null,"spread":false},{"title":"GenerateResource.read.1.tlog <span style='color:#111;'> 2B </span>","children":null,"spread":false},{"title":"TempPE","children":[{"title":"Properties.Resources.Designer.cs.dll <span style='color:#111;'> 4.50KB </span>","children":null,"spread":false}],"spread":false},{"title":"GenerateResource-ResGen.read.1.tlog <span style='color:#111;'> 838B </span>","children":null,"spread":false},{"title":"GenerateResource.write.1.tlog <span style='color:#111;'> 2B </span>","children":null,"spread":false}],"spread":false}],"spread":true}],"spread":true},{"title":"bin","children":[{"title":"Release","children":[{"title":"SqlTrace.tdf <span style='color:#111;'> 724B </span>","children":null,"spread":false},{"title":"SqlTrace.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"Microsoft.SqlServer.ConnectionInfoExtended.dll <span style='color:#111;'> 93.84KB </span>","children":null,"spread":false},{"title":"SqlTrace.pdb <span style='color:#111;'> 21.50KB </span>","children":null,"spread":false},{"title":"SqlTrace.exe <span style='color:#111;'> 17.00KB </span>","children":null,"spread":false},{"title":"SqlTrace.exe.config <span style='color:#111;'> 117B </span>","children":null,"spread":false},{"title":"SqlTrace.vshost.exe <span style='color:#111;'> 11.34KB </span>","children":null,"spread":false},{"title":"DevComponents.DotNetBar.Design.dll <span style='color:#111;'> 363.50KB </span>","children":null,"spread":false},{"title":"SqlTrace.vshost.exe.config <span style='color:#111;'> 117B </span>","children":null,"spread":false},{"title":"Microsoft.SqlServer.ConnectionInfo.dll <span style='color:#111;'> 149.84KB </span>","children":null,"spread":false},{"title":"DevComponents.DotNetBar2.dll <span style='color:#111;'> 4.34MB </span>","children":null,"spread":false}],"spread":false},{"title":"Debug","children":[{"title":"SqlTrace.tdf <span style='color:#111;'> 724B </span>","children":null,"spread":false},{"title":"SqlTrace.vshost.exe.manifest <span style='color:#111;'> 490B </span>","children":null,"spread":false},{"title":"Microsoft.SqlServer.ConnectionInfoExtended.dll <span style='color:#111;'> 93.84KB </span>","children":null,"spread":false},{"title":"SqlTrace.pdb <span style='color:#111;'> 31.50KB </span>","children":null,"spread":false},{"title":"SqlTrace.exe <span style='color:#111;'> 16.50KB </span>","children":null,"spread":false},{"title":"SqlTrace.exe.config <span style='color:#111;'> 117B </span>","children":null,"spread":false},{"title":"SqlTrace.vshost.exe <span style='color:#111;'> 11.34KB </span>","children":null,"spread":false},{"title":"SqlTrace.vshost.exe.config <span style='color:#111;'> 117B </span>","children":null,"spread":false},{"title":"Microsoft.SqlServer.ConnectionInfo.dll <span style='color:#111;'> 149.84KB </span>","children":null,"spread":false},{"title":"DevComponents.DotNetBar2.dll <span style='color:#111;'> 4.34MB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"Form1.cs <span style='color:#111;'> 4.14KB </span>","children":null,"spread":false},{"title":"SqlTrace.csproj <span style='color:#111;'> 4.75KB </span>","children":null,"spread":false},{"title":"SqlTrace.suo <span style='color:#111;'> 20.00KB </span>","children":null,"spread":false},{"title":"Form1.resx <span style='color:#111;'> 6.40KB </span>","children":null,"spread":false},{"title":"Properties","children":[{"title":"AssemblyInfo.cs <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false},{"title":"Settings.Designer.cs <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"Resources.resx <span style='color:#111;'> 5.48KB </span>","children":null,"spread":false},{"title":"Settings.settings <span style='color:#111;'> 249B </span>","children":null,"spread":false},{"title":"Resources.Designer.cs <span style='color:#111;'> 2.79KB </span>","children":null,"spread":false}],"spread":true}],"spread":false}],"spread":true}]

评论信息

  • 挖宝人 :
    有很大的参考意义,不错
    2020-05-23
  • Castiel丶Luo :
    有借鉴作用,还行
    2018-11-26
  • Ljx_Csharp :
    可以用,但是不是我想要的。
    2018-11-14
  • 假博士 :
    bu不错 正在学习,有一个框架需要用到sql
    2018-09-26
  • kyangh :
    还没打开就被杀毒软件删了
    2017-11-16

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明