SQLSERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿
SQL SERVERÄÜ»ñµÃÁ¬½ÓµÄÓû§µÄIPÂð£¿
Ö÷ÒªÏëʵÏÖÒÔÏ£º
Ò»¸öÓû§Á¬½Óµ½Êý¾Ý¿â£¬°ÑÓû§µÄÓû§ÃûÓëIP¶¼±£´æÔÚÊý¾Ý¿âÖУ¬À´ÊµÏÖÓû§µÇ¼µÄ¹¦ÄÜ¡£
×îºÃÊÇÓû§µ÷ÓÃÒ»¸ö´æ´¢¹ý³Ì£¬°ÑÓû§Ãû×÷²ÎÊý£¬´æ´¢¹ý³Ì¾ÍÄܰÑÓû§µÄÓû§ÃûÓëIP±£´æÏÂÀ´¡£
ÇëÖ¸½Ì£¨Ö»ÓÐ16·ÖÁË£©
SQL code:
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[p_getlinkinfo]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[p_getlinkinfo]
GO
/*--»ñÈ¡Á¬½ÓSQL·þÎñÆ÷µÄÐÅÏ¢
ËùÓÐÁ¬½Ó±¾»úµÄ:²Ù×÷µÄÊý¾Ý¿âÃû,¼ÆËã»úÃû,Óû§Ãû,Íø¿¨ÎïÀíµØÖ·,IPµØÖ·,³ÌÐòÃû
--×Þ½¨ 2003.11--*/
/*--µ÷ÓÃʾÀý
--ÏÔʾËùÓб¾»úµÄÁ¬½ÓÐÅÏ¢
exec p_getlinkinfo
--ÏÔʾËùÓб¾»úµÄÁ¬½ÓÐÅÏ¢,°üº¬ipµØÖ·
exec p_getlinkinfo @includeip=1
--ÏÔʾÁ¬½ÓÖ¸¶¨Êý¾Ý¿âµÄÐÅÏ¢
exec p_getlinkinfo '¿Í»§×ÊÁÏ'
--*/
create proc p_getlinkinfo
@dbname sysname=null, --Òª²éѯµÄÊý¾Ý¿âÃû,ĬÈϲéѯËùÓÐÊý¾Ý¿âµÄÁ¬½ÓÐÅÏ¢
@includeip bit=0 --ÊÇ·ñÏÔʾIPµØÖ·,ÒòΪ²éѯIPµØÖ·±È½Ï·Ñʱ,ËùÒÔÔö¼Ó´Ë¿ØÖÆ
as
declare @dbid int
set @dbid=db_id(@dbname)
create table #tb(id int identity(1,1),dbname sysname,hostname nchar(128),loginname nchar(128),net_address nchar(12),net_ip nvarchar(15),prog_name nchar(128))
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
дÁËÒ»¸öÓÃCÓïÑÔ²Ù×÷sqlserverÊý¾Ý¿âµÄ³ÌÐò£¬ÔÚÎÒ×Ô¼ºµÄ¼ÆËã»úÉÏÔËÐÐûÎÊÌâ¡£µ«µ½Áíһ̨»úÆ÷ÉÏÔËÐÐʱ£¬SQLConnectº¯ÊýÁ¬½ÓÊý¾Ý¿âʧ°Ü£¬×Ðϸ¼ì²éÉèÖö¼Ã»Óз¢ÏÖÎÊÌ⣬µ«¸Ã»úÆ÷µÄ²Ù×÷ϵͳÊÇWindows Server 2003 Enterp ......
xp(sp3)ϵͳ°²×°ÁËsqlserver2000£¬sp3£¬sp4²¹¶¡¶¼´òÁË¡£¶øÇÒ±¾»úÒ²ÄÜÁ¬½Ó·ÃÎÊ¡£
ÎÊÌâÊÇ£º
±¾»útelnet ip 1433 ×ÜÊÇÌáʾÁ¬½Óʧ°Ü£¬
¶øÇÒnetstat -naʱ£¬¿´²»µ½1433¶Ë¿Ú±»Õ¼ÓÃ
(¿Ï¶¨µÄÊÇ£º¶Ë¿ÚÊÇ1433£¬¿ªÆ ......
±ísinger£º
singerID£¬singerName
1£¬ÁõµÂ»ª
2£¬ÕÅѧÓÑ
3£¬¹ù¸»³Ç
4£¬ÀèÃ÷
±ísong£º
songID£¬songName£¬singerID
1£¬ÍüÇéË®£¬1
2£¬ÖйúÈË£¬1
3£¬ÎDZð£¬2
4£¬¶ÔÄã°®²»Í꣬3
......
×î½üÊý¾Ý¿â±»¸Ä£¬Ï뽫֮»Ö¸´µ½ÉÏÖÜǰµÄÊý¾Ý£¬¿ÉÒÔŪÂð£¿
×Ô¼ºÃ»ÓÐÈ¥±¸·Ý¡£
try:
Log Explorer
http://download.csdn.net/source/620271
ѹËõ°üÀïÓÐÒ»¸ö×¢²á»ú£¬ÓÃÀ´²úÉú×¢²áÂë¡£
´ò¿ªlo ......