- 這篇文章限定好友觀看。
若您是好友，登入後即可閱讀。
- Apr 01 Mon 2013 12:06
get hostid on linux
- Feb 18 Mon 2013 16:02
excel顯示日期格式到秒
[$-409]yyyy-m-d h:mm:ss;@
- Mar 29 Tue 2011 15:24
QUERY LOCK OBJECT ON MS SERVER 2008
select * from sys.dm_tran_locks,sysobjects
where sys.dm_tran_locks.resource_associated_entity_id=sysobjects.id
- Jun 28 Mon 2010 23:11
Could not allocate space for object. because the 'PRIMARY' filegroup is full.
Workaround:
1) Enable file growth for the first data file
2) Add new file
3) Disable file growth for the first data file
- Jun 01 Tue 2010 09:16
hyper-v網路不通需要CONFIG
netsh int tcp set global autotuninglevel=disabled
netsh int tcp set global chimney=disabled
- Oct 08 Thu 2009 18:48
在 SQL Server 的執行個體之間傳送登入和密碼
http://support.microsoft.com/kb/246133/zh-tw
----- Begin Script, Create sp_help_revlogin procedure -----
USE master
- Oct 08 Thu 2009 18:44
SQL 2008 64-bits連線SQL 2000 32-bits linked server出現錯誤訊息已解決
http://support.microsoft.com/kb/906954
對於具名執行個體
osql -E -S <LinkedServerName>\<InstanceName> -i <Location>\instcat.sql
- Sep 15 Tue 2009 00:12
20090913:台中都會公園+望高寮
- Sep 15 Tue 2009 00:09
20090906:台中西屯到東勢
- Jun 19 Fri 2009 11:51
PANASONIC ZS3影片測試-一般畫質-佑佑騎三輪車
- Jun 19 Fri 2009 11:47
PANASONIC ZS3影片測試-HD版本-安安騎三輪車
- Jun 03 Wed 2009 14:48
how to remove hidden device on windows 2008
c:\set devmgr_show_nonpresent_devices=1
c:\ start devmgmt.msc
show hidden device-->remove it
- May 19 Tue 2009 15:19
ORA-04062 -解決方法
- May 05 Tue 2009 16:20
how to check sql 2005 service pack
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')
- Apr 08 Wed 2009 10:01
set trace on oracle db
SQL> exec dbms_system.set_sql_trace_in_session(sid,serial#,true)
PL/SQL procedure successfully completed.
SQL> exec dbms_system.set_sql_trace_in_session(sid,serial#,false)
ORACLE (1)
