On SQLServer 2005:

I am in the Test database which has Test table.

insert into Table

SELECT@@servername as Servername,name as DBName,[crdate] AS [LastStartupDate]

FROM[master].[dbo].[sysdatabases]

WHERE[name] = 'tempdb'

and [Test].[dbo.Table].LastStartUpTime < [master].[dbo].[sysdatabases].crdate

Error:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "Test.dbo.Table.LastStartUpTime" could not be bound.

Where am I going wrong?