It looks like something has broken the LSN for that database .  That could be a switch from Full recovery to Simple and back, a restore, or another backup run...

CREATE TABLE [Job info$]

(

[Time Reported] DATETIME

)

INSERT [Job info$] ([Time reported])

VALUES

( '1899-12-30 09:12:32.000' ) ,

( '1899-12-30 09:13:32.000' ) ,

( '1899-12-30 12:21:32.000' ) ,

( '1899-12-30 19:24:32.000' ) ;

SELECT FORMAT([Time Reported], N'HH\:mm')

FROM [Job...

SELECT FORMAT(DateTimeCol, N'HH\:mm')

FROM #TimeReported;

Is the user using SSMS Express? If so the Agent won't be visible and you'll need to install the full version of SSMS instead.

Changing the database collation won't change the collation of columns in existing user defined tables.

Here's a link that explains: http://msdn.microsoft.com/en-GB/library/ms175835.aspx

This?

SELECT e1.Place

, e1.Objective

, e1.[Year]

, e1.[Month]

, e1.Exam1

, e2.Exam2

, e3.Exam3

FROM #tmpExam1 e1

JOIN #tmpExam2 e2

ON e1.Objective = e2.Objective

...

Then presumably the other database is case insensitive.

You must be using a case sensitive collation on either the server or the database:

http://msdn.microsoft.com/en-gb/library/hh230914.aspx

Are you restoring from the GUI?http://sqlblog.com/blogs/merrill_aldrich/archive/2013/03/15/ssms-2012-restore-gui-gotcha.aspx

Also check the local administrators group on the server running SQL Server. Any user who is added to the local admin group, will be (by default) an admin on your...

-- xp_cmdshell is an advanced option,

-- so first you need to check if it's turned on:

EXEC sp_configure;

GO

-- If you don't see xp_cmdshell in the list:

EXEC sp_configure 'show advanced...

The last couple of posts in this thread http://social.technet.microsoft.com/Forums/da-DK/sqldatawarehousing/thread/3fb03851-2de8-4bfe-9df8-2e7dfbbc60cc suggest how to retain historical changes after a schema change.

In SQL Server 2008 members of the local Windows administrator group don't automatically have admin access to SQL Server. You'll need to start SQL in single user mode and...

Not quite what you're after, but right click over the toolbar in SSMS and select Customize. On the Commands tab select File. There is an option Open File...

Wow, that's cheap by UK standards. Average house price...