In your destination tab, it treats the worksheets like tables (as if it were a SQL Server Database destination). It's kind of clunky, but play with it and you can...

I think that the table would be there as of 11:59am, but when the recovery process gets to 12:00pm, it would truncate the table again and continue on. Therefore, if...

Sorry, I didn't realize that you were referring to a TRUNCATE TABLE command vs. a truncate log command.

I don't know that a truncate table command would invalidate a point...

I think that Frank is correct (as normal). Look up point-in-time in Books Online. There is a how-to that refers to restoring transaction logs to accomplish a point-in-time recovery. If...

If it wasn't run by a scheduled job, it isn't going to have an entry in SysJobsHistory,

"I have checked all jobs that call DTS packages and nothing is scheduled at that time,...

To expand on AJ's comment, I usually call my user stored procedures (the one's that exist in non-system databases) usp_something, usp standing for User Stored Procedure.  

Microsoft clustering is basically a 'shared nothing' implementation. That means that you don't have load balancing between nodes/virtual servers. One cluster node will own the disks and users have to...

If it is being run interactively (and not by a scheduled SQL Server Agent job) the only way to determine when it is being run is to enable package logging...

Thta's it! We're going to start the Luddites' DBA group!

On a side note, if you're having problems getting into Current Activity in EM, you can always run sp_who/sp_who2 from QA. They're usually much more responsive.

Sushila, I was talking about GPF2^192's post.

GPF2^192, I don't really know what you are getting at, but if you're in healthcare (for one example), HIPPA requires data security...

What I was getting at is why 'an SQL...' instead of 'a SQL...'?

If you can't find boot.ini on the server (My experience is with 32bit, not 64bit, but hopefully it is the same) try the following command in the root of the...

I read an article (sorry, can't remember where it was) but a researcher in Japan proved it was lauginly simple to bypass these systems. Something about putting latex (or something...