使用vb.net读取日志文件(在管理员模式下) [英] Read logfile with vb.net (in admin mode)

问题描述

无论何时我们从sql server创建数据库，它都会创建两个文件.我想看看.ldf文件中有什么.通过程序(使用visula basic .net).请指导我:confused :: confused :: confused:

When ever we create database from sql server, it''s create two file. I want to see what''s available inside the .ldf file. Through program (with visula basic .net ). PLease guid me:confused::confused::confused:

推荐答案

正如Simon_Whale所说的那样，它太复杂了，无法在这样的论坛中给出答案这个.

您唯一的希望是使用Google/Bing/Yahoo并收集有关它的一些信息，然后将它们组合起来，直到找到有用的信息为止.

有几个命令可以帮助您入门:-

DBCC-transact-sql命令.使用搜索获取有关此内容的完整详细信息.
fn_dblog-一个未记录的(意味着要当心)SQLServer函数. 此处 [

As Simon_Whale has already said this is far too complicated to be able to give an answer in a forum like this.

Your only hope is to use Google/Bing/Yahoo and gather little bits of info about it and combine them until you find something that works.

There are a couple of commands that might get you started:-

DBCC - a transact-sql command. Use search for full details on this.
fn_dblog - an undocumented (meaning beware) SQLServer function. Here [^] is one article on it. Use search for more info.

There are plenty of articles out there on running Transact-SQL commands from VB. Search for them.

这很复杂，因为信息不是用易于阅读的代码编写的.

您最好从redgate之类的地方使用日志查看器

thats very complicated as the information isn''t written in easy to read code.

your better of looking at using a log viewer from places such as redgate for example

请给我更多有关它的信息，并对其进行详细说明.
你知道做这项工作的存储过程吗??? :((

Please Give me more information about it and more explain it.
do you know store procedure for doing this work??? :((

这篇关于使用vb.net读取日志文件(在管理员模式下)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！