Viewing 6 posts - 1 through 6 (of 6 total)
I found the cause.
On the SQL server where the job was created, IS was not installed.
The dtexec executable is present, but it seems you have to install the complete integration...
May 28, 2014 at 3:00 am
I know this is an old post, but I would advise to be very careful with this script.
In bol under indexproperty:
IsPageLockDisallowed
Page-locking value set by the ALLOW_PAGE_LOCKS option of...
March 4, 2013 at 3:58 am
/3gb switch in boot.ini not implemented
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Enterprise" /fastdetect /PAE
January 15, 2010 at 5:55 am
This is strange.
I had exactly the same problem yesterday (is same day as DBA_Help) on 2 servers.
both are on SQL 2005 SP3 (9.0.4207) and have 16 GB ram. They are...
January 15, 2010 at 2:08 am
My experience:
In general, it is best to leave auto create statistics and auto update statistics on.
In this case, statistics are automatically recalculated after a big change of the data.
However, I...
August 7, 2008 at 4:12 am
Maby to late but
try
SELECT @sql_handle-2 = sql_handle FROM sys.dm_exec_requests WHERE session_id = @@spid and sql_handle IS NOT NULL
July 30, 2008 at 7:24 am
Viewing 6 posts - 1 through 6 (of 6 total)