Search results for query: *

I cannot find a certain property in the DTS object model: "always read properties from UDL file" which can be found on the property tab of a UDL connection in a DTS package. My guess is it would be in one of the following objects: DTS.Connection2 DTS.OleDBProperty2 But I cannot pinpoint...

Hello, I have a database with a transaction log file of 500MB. I want to increase it to 10000MB, but this must also become the new "minimum logsize". According to BOL the ALTER DATABASE statement with the SIZE=10000MB property should do the trick... BUT after an autoshrink or forced shrink (...

Hi, A dts package can log errors per step to the sysdtssteplog table. An error description can be found in the errordescription field. HOWEVER, this message is maximum 256 characters long, while the datatype is nvarchar(2000). Some descriptions are truncated, while I need the entire message...

Why is it not possible to KILL a SELECT process? The BOL states this is one of several process that can't be killed. If users are retrieving vast amounts of data, taking up to many resources, those processes can't be killed? What's the risk? That users receive partial result sets? Has...

Hello, Is there a default setting to set single job execution at a time in SQL Server? Example job1 executes at 01:00, finishes at 02:00 job2 is executed at 01:10, but doesn't start (is queued) until 02:00, when job1 has finished