Check this site for a list of data modeling books.  In particular, look at books by Date, Darwen, and Codd.

Greg

timestamp - used to version stamp table rows.  It is automatically incremented every time the row is modified

nvarchar - used for variable character data that will translate to the same characters...

sswords,

I'm curious as to why you run hourly log backups 24 hours a day if your database is being used "9 to 5".

Greg

Do you have a full database backup from before the last transaction log backup?  You can't restore a log backup until you've restored a full backup.

If you do have a...

Ricardo,

Check cross database ownership chaining as Aaron suggests and also make sure that dbo is mapped to the same login in both databases.  I make a point of making SA...

I'll second that.  See my reply to Michael's question in this forum.  You might also verify that any parameters you are passing to the child package are correct.

Greg

Select only the package name, not a version, when you define your Execute Package task.  If you specify only the name, DTS will always use the latest version.

Greg

Yes, you can when using outer global variables because they're available in both packages.

If you just want to know if the child package succeeded or not, you can use workflow...

This has been discussed several times in these forums and the consensus seems to be that sp_server_info selects from a system table that doesn't always get updated by hotfixes and...

More information, please.  What goes wrong?  Is there and error message?

Greg

In the parent package, create the global variables that you want to pass, then create an Execute Package Task.  On the 'Outer Package Global Variables' tab, select the global variables...

The reason the testdatabase users are missing after the restore is they aren't in the production database that is being backed up and restored.  When you restore a database, even...

End of support depends on release date of next version.  Here's the link:

http://support.microsoft.com/gp/lifesrvr

Greg

There's no way I know of to change the default in the wizard.  If you move data between the same databases often, you could save as a package with delete...

Start with ALTER TABLE in BooksOnLine.

Greg