You might be overlooking the fact that 7-zip can create .zip files in addition to .7z files.

The 7zip documentation is very good and it will answer your question. You can do pretty much whatever you can think of doing with a compression program by sending in...

There are compression functions that are part of the .NET framework that you can use inside of a Script task. This is the method I have previous chosen and it...

Maybe add

order by cat_name,sch_name,tab_name

for the select statement from the temp table.

Michael Zilberstein wrote a nice blog post that describes why that method doesn't work.

I tested querying the database_recovery_status table and that table does seem to supply reliable information.

This is what I have now

--Use trailing slash

DECLARE @PathToBackupFolder varchar(100)

SET @PathToBackupFolder = 'D:\DatabaseBackups\'

DECLARE @PathToSpecificBackupFolder varchar(100)

DECLARE @FileName varchar(100)

/*IF object_id('tempdb..#DatabaseList') IS NOT NULL

BEGIN

DROP TABLE #DatabaseList

END*/

CREATE TABLE #DatabaseList (

id int,

RecoveryMode sql_variant,

OnlineStatus sql_variant

)

SET...

It is SQL Server 2005 Standard sp2.

I found the code that detects whether a backup has ever been made, which is the core of what I'm trying to do.

SELECT DB_NAME(rs.database_id)

FROM...

The info about BCP was in this link

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2471462&SiteID=1

It just contained an exerpt from Kirk's SSIS book.

I'll quote the quote

Let me quote from Kirk Haselden's book titled Microsoft SQL Server 2005...

Thanks for the link to the MS SSIS forum. If one of the main people behind SSIS (Kirk H.) says not to use Bulk Insert / BCP anymore, then I'm...

Thanks for the feedback. I forgot about BCP, although I used that back in the SQL 2000 days to populate a datamart, since it was the fastest method.

After importing the...

I'm going with a derived column using this formula:

ISNULL(dt) || LEN(TRIM(dt)) != 8 ? NULL(DT_DBDATE) : (DT_DBDATE)(SUBSTRING(dt,5,2) + "/" + SUBSTRING(dt,7,2) + "/" + SUBSTRING(dt,1,4))

I'm wondering whether this is the...

Going forward, any database auditing solution can help track changes. There are many ways of implementing auditing, although most involve using triggers.

Other than profiler, I think your other option would be to use software that is capable of analyzing transaction logs. That software is rather expensive.

Wikipeida was one of the first places I checked and was surprised at how little information there was on these encryption methods. I didn't find much useful guidance that compared...

Thank you for the suggestions. The idea of using both a unique constraint and a check constraint is a nifty solution to that problem.

I am going to go with the...