Ram

It is remarkable when organization change from risk avoidance to risk preparedness. Many companies build systems (computer or otherwise) and hope the big issue never happens. Eventually, it does. ...

I will give it my best rookie attempt.

Try this out:

create table inventory (

InvID int,

ActivityCode int,

MovementDate datetime,

OldLocationID int,

NewLocationID int

)

select I.InvID, I.ActivityCode, I.OldLocationID ,

sum(datediff(day,I.inDateTime, I.OutDateTime))

from (

select I.InvID, I.ActivityCode,...

Are you passing the recordset into a script task for the record by record operation? if so, you can perform the procedure execute in the script task and it will...

Do you need to keep the app online? We occasionally move data in secondary files with the app online. painful,slow, but feasible.

spoon

data = 2

log = 4

total of 6GB

how short on space is your system? Yes,...

What is size of the biggest table in the database? My safe estimate for index rebuilds is 2.5 times the size of the original for the log file.

Shrinking...

Trace will provide all of the login auditing you are looking for including change password. It is easy to configure by using the profiler to build the script.

Auditing the changes...

I would recommend the background trace which is very easy to filer for just sa

Yes, this is the...

elmar.fecker (2/28/2014)

---

with T-SQL Statement. I plan to create a CMD Job, which calls the Programm SQLCMD and then start a T-SQL Skript which starts the SSIS Package. The CMD Skript...

Do you need just the sa login or any successful login that had sysadmin at that time?

Is there a reason for using a script task versus a data flow?