ͨ¹ýMSSQL Server Agent Ö´ÐÐDTS °üµÄÎÊÌâ
ÖÆ×÷ÁËÒ»¸öDTS°ü£¬Äܹ»¿ª·¢»·¾³»òÕßÃüÁîÐÐÏÂÕýÈ·µÄÖ´ÐУ¬µ«ÔÚͨ¹ýAgent À´Ö´ÐеÄʱºò×ÜÊDZ¨´í£º
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun OnError: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
»òÕßÊÇÈçÏ´íÎó£º
´íÎóÔ´: Microsoft OLE DB Provider for Oracle °ïÖúÎļþ: °ïÖúÉÏÏÂÎÄ: 0 ´íÎóÏêϸ¼Ç¼: ´íÎó: -2147467259 (80004005); Ìṩ³ÌÐò´íÎó: 0 (0) ×Ö·û´®´íÎó: ûÓз¢ÏÖ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÓÉ Oracle ¹«Ë¾Ìṩ£¬ÊÇ Oracle 7.3.3°æ(»ò¸üÐÂ)¿Í»§¶ËÈí¼þ°²×°µÄÒ»²¿·Ö¡£ ÌṩÕß½«ÎÞ·¨Ê¹ÓÃÖ±µ½ÕâЩ×é¼þ±»°²×°ÎªÖ¹¡£ ´íÎóÔ´: Microsoft OLE DB Provider for Oracle °ïÖúÎļþ: °ïÖúÉÏÏÂÎÄ: 0 DTSRun OnError: DTSStep_DTSExecuteSQLTask_5, Error = -2147467259 (80004005) ×Ö·û´®´íÎó: ûÓз¢ÏÖ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÓÉ Oracle ¹«Ë¾Ìṩ£¬ÊÇ Oracle 7.3.3°æ(»ò¸üÐÂ)¿Í»§¶ËÈí¼þ°²×°µÄÒ»²¿·Ö¡£ ÌṩÕß½«ÎÞ·¨Ê¹ÓÃÖ±µ½ÕâЩ×é¼þ±»°²×°ÎªÖ¹¡£ &
Ïà¹ØÎĵµ£º
½ñÌìÔÚÁÄÌìϵͳÖÐÐèҪϵͳִÐÐÒ»¸ö¶à²ãǶÌײéѯ¡£
Ò»¿ªÊ¼Óï¾äÈçÏÂ×ܳöÏÖ´íÎó£ºÔÀ´ÊÇÔÚ]='123') ºóÎÒ¶à¼ÓÁËÒ»¸ö as tb1
¸ÄΪÈçϺó£¬ÕýÈ·ÔËÐС£
select * from ( select top(10) * from ( select top(100) * from (select [chatcontent].[senderid],[chatcontent].[id] ,[chatcontent].[toid] ,[chatc ......
Êý¾ÝÀàÐÍ
ÀàÐÍ
ÃèÊö
bit
ÕûÐÍ
bit Êý¾ÝÀàÐÍÊÇÕûÐÍ£¬ÆäÖµÖ»ÄÜÊÇ0¡¢1»ò¿ÕÖµ¡£ÕâÖÖÊý¾ÝÀàÐÍÓÃÓÚ´æ´¢Ö»ÓÐÁ½ÖÖ¿ÉÄÜÖµµÄÊý¾Ý £¬ÈçYes »òNo¡¢True »òFa lse ¡¢On »òOff
int
ÕûÐÍ
int Êý¾ÝÀàÐÍ¿ÉÒÔ´æ´¢´Ó- 231( ......
´Ómssql6.5¿ªÊ¼£¬Î¢ÈíÌṩÁËÁ½¸ö²»¹«¿ª£¬·Ç³£ÓÐÓõÄϵͳ´æ´¢¹ý³Ìsp_MSforeachtableºÍsp_MSforeachdb£¬ÓÃÓÚ±éÀúij¸öÊý¾Ý¿âµÄÿ¸ö±íºÍ±éÀúDBMS¹ÜÀíϵÄÿ¸öÊý¾Ý¿â¡£
ÎÒÃÇÔÚmasterÊý¾Ý¿âÀïÖ´ÐÐÏÂÃæµÄÓï¾ä¿ÉÒÔ¿´µ½Á½¸öprocÏêϸµÄ´úÂë
use master
exec sp_helptext sp_MSforeachtable
exec sp_helptext sp_Msforeachdb
sp_M ......
@echo off
:dosmenu
REM Ñ¡Ôñ²Ëµ¥
echo Windows ·þÎñÆô¶¯»ò¹Ø±Õ By hope 2008Äê2ÔÂ7ÈÕ
echo.
echo [1]Æô¶¯Sql Server2005 [2]¹Ø±ÕSql Server2005
echo [3]Æô¶¯Oracle9i [4]¹Ø±ÕOracle9i
echo.
echo ......
Ëø»úÖÆ
NOLOCKºÍREADPASTµÄÇø±ð¡£
1. ¿ªÆôÒ»¸öÊÂÎñÖ´ÐвåÈëÊý¾ÝµÄ²Ù×÷¡£
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. Ö´ÐÐÒ»Ìõ²éѯÓï¾ä¡£
SELECT * from Customer WITH (NOLOCK)
½á¹ûÖÐÏÔʾ"a"ºÍ"a"¡£µ±1ÖÐÊÂÎñ»Ø¹öºó£¬ÄÇôa½«³ÉΪÔàÊý¾Ý¡£(×¢:1ÖеÄÊÂÎñδÌá½») ¡£NOLOCK±íÃ÷ûÓжÔÊý¾Ý±íÌí¼Ó¹²Ï ......