It would be more efficient to set the value of DateLastEdit in the procedure that inserts or updates the data than to use a trigger

Are you really asking us for the meaning of data in your database?

We can make guesses, but how would we really know?

You are taking the wrong approach to shrinking the database.

The way to do it is to shrink it by database file in small imcrements in a loop, say 50 MB...

Did you just add a table with a computed column, add a computed column to an existing table, or create an indexed view?

Yes, you can just setup a SQL Server Agent job to run the restore each night.

You can use this function to generate both.

Date Table Function F_TABLE_DATE

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61519

This code generates a table with all days from 2000-01-01 through 2010-12-31.  You can pick any date range you want...

If you just want to be able to drop the database, use this:

use master
alter database RB_Data_Services_MSCRM set offline with rollback immediate

That will kick everyone out of the database, and set...

Since you have the dates stored in a character column, it might be faster to do string comparisons, instead of casting two columns to datetime to do the compares, especially...

You have a bug in that code.

convert(varchar, @EndDate, 101) will be converted to a string in the format '02/06/2007' and will be compared as a string to  '2/6/2007'.  That would...

I worked for a company that spent $4,000,000 on a patent enfringement case against a competitor and lost.  They felt certain they had proved the case, but the grandmothers on the...

exec sp_changeobjectowner '[oldowner].[viewname]','[newowner]'

You have a bug in the code you posted.  If the time is after 23:59:59.000 on the last day, it will not return the data.  You may think there is...

You have the rights you can enforce in court.

If someone copies your design and uses it as their own, you would have to be able to prove it was your...

The RESTORE command with the MOVE option is documented in SQL Server 2005 Books Online.

http://msdn2.microsoft.com/en-us/library/ms186858.aspx

Always enter character date strings in the form '20070113' (or '20070113 23:59:59.997' if you need date and time), and you will not have any problems due to language settings.