Jump To VB.NET

훔... 오늘 멋질것 같은 툴을 하나 발견했습니다.

^^

그것은... 그것은... 여기에서 받으실수 있습니다. ㅋㅋㅋ

두 Version의 assembly 를 비교할 수 있는 툴입니다.

행복한 고수되셔요...


woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

간단한 소개입니다.

The Debug Diagnostic Tool (DebugDiag) is designed to assist in troubleshooting issues such as hangs, slow performance, memory leaks or fragmentation, and crashes in any user-mode process. The tool includes additional debugging scripts focused on Internet Information Services (IIS) applications, web data access components, COM+ and related Microsoft technologies.

여기 서 다운로드 받으실수 있습니다.

유용한 툴이 나온 듯 합니다.


행복한 고수되십시요...

woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\\\\

Linked DB  조회
Select * FROM SYSSERVERS

Linked DB 생성
/****** 개체:  LinkedServer [GRAY_TEST]    스크립트 날짜: 11/02/2009 21:36:16 ******//*
EXEC master.dbo.sp_addlinkedserver @server = N'GRAY_TEST', @srvproduct=N'.', @provider=N'OraOLEDB.Oracle', @datasrc=N'gray_test'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'collation compatible', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'data access', @optvalue=N'true'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'dist', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'pub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'rpc', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'rpc out', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'sub', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'connect timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'collation name', @optvalue=null
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'lazy schema validation', @optvalue=N'false'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'query timeout', @optvalue=N'0'
GO
EXEC master.dbo.sp_serveroption @server=N'GRAY_TEST', @optname=N'use remote collation', @optvalue=N'true'
go
EXEC sp_addlinkedsrvlogin 'GRAY_TEST','false',null,'test_account','test_password'
go


행복한 고수되셔요...


woojja ))*
\\\\\\\\\\\\\\\\\\\\\\\\