If this is EXACT expression you are using:

ISNULL(DOB) ? "NULL(DT_DBTIMESTAMP,50)" : SUBSTRING((DT_WSTR)DOB,5,4)+"-"+SUBSTRING((DT_WSTR,8)DOB,1,2)+"-"+SUBSTRING((DT_WSTR,8)DOB,3,2)+" 00:00:00.000"

Then I think you need to replace:

"NULL(DT_DBTIMESTAMP,50)"

With:

NULL(DT_DBTIMESTAMP)

If you are querying the table then the optimizer needs statistics to choose the best access plan. Typically you have autocreate statistics on so the stats should be created...

You should definitely run checkdb on the system databases (master, msdb) because if either of those is corrupted you have big problems and you need to know.

I don't do anything...

Okay, here's a 2000 solution that I think meets your needs:

DECLARE @table TABLE (row_id INT IDENTITY(1,1), modelid INT, code VARCHAR(10), NAME VARCHAR(50), retailprice DECIMAL(18,2), createdate DATETIME, modifydate DATETIME)

INSERT INTO @table...

Are you really on 2000? Here is an answer for 2005/2008:

/*

Ok so 1st the basic table and history table structure

*/

IF OBJECT_ID('dbo.Model', 'U') IS NOT NULL

...

There really is not a way to tell which tables have been used. You could set up a server-side trace, but how long would be long enough to run...

Have you successfully restored this backup on a 64-bit server? It could be your backup is no good.

Or as Paul says are you on the same version.

-edit to reference...

Didn't meet THAT Dan Guzman either.

You can also run DBCC LOGINFO('db name') to see the VLF's in your log which will show which are inactive. The status will be 0 for available/inactive. If...

Shrinking only releases space at the end of the file, from BOL:

TRUNCATEONLY

Releases all free space at the end of the file to the operating system but does not perform any...

Before you get totally flamed. What do you mean that the files will not grow much in the future? In my experience if a database or log has...

I have recently read one of Murach's books on javascript and DOM scripting and really liked the format (left page text, right page code and bullet points).

I also have a...

Can you provide some more details? Do you mean how to use history tables? Do you mean how to find a history of who accessed a table and...

The Summit is worth it, if you participate! Sure there is value in the sessions, but there is even more value in the people that you meet, if you...

Can't tell. I don't see any code. Can you post some code?