chinkao

select * from sys.dm_tran_locks,sysobjects
where sys.dm_tran_locks.resource_associated_entity_id=sysobjects.id

Workaround:
1) Enable file growth for the first data file
2) Add new file
3) Disable file growth for the first data file

http://connect.microsoft.com/SQLServer/feedback/details/524945/can-not-add-data-file-to-the-database-with-fixed-size-files

netsh int tcp set global autotuninglevel=disabled
netsh int tcp set global chimney=disabled

http://support.microsoft.com/kb/246133/zh-tw

----- Begin Script, Create sp_help_revlogin procedure -----

USE master

http://support.microsoft.com/kb/906954

對於具名執行個體

osql -E -S <LinkedServerName>\<InstanceName> -i <Location>\instcat.sql

c:\set devmgr_show_nonpresent_devices=1
c:\ start devmgmt.msc

show hidden device-->remove it

host oerr ora 04062
04062, 00000, "%s of %s has been changed"
// *Cause:  Attempt to execute a stored procedure to serve

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')

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)

find /ABC -mtime +200 -type f -print -exec rm -f {} \;

find /ABC -mtime +300 -type f -print|xargs tar cvf /tmp/uat2_300.tar

SYSADMIN->Security->ORACLE->Register

metalink Doc ID:  394555.1

Use the following command to gather schema statistics: