SQL Server Management Studio Express crashing when using ROW_NUMBER()

  • Hi all,

    I hope this is the right place to post this question.

    I have SQL Server Management Studio Express and SQL Server Express with Advanced Services on Vista Home Premium.

    When I create a new View and manually type into the sql command area...

    SELECT UserID, ROW_NUMBER() OVER(ORDER BY UserID ASC) As myRank

    FROM dbo.tblUser

    ...SQL Server Management Studio Express crashes. It has no error number, it just says that something caused it to crash. It only seems to happen when including ROW_NUMBER() OVER(ORDER BY UserID ASC) As myRank part of the statement.

    Vista has all the latest downloads. My details of SSMSE are...

    Microsoft SQL Server Management Studio Express 9.00.4035.00

    Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)

    Microsoft MSXML 3.0 4.0 5.0 6.0

    Microsoft Internet Explorer 7.0.6001.18000

    Microsoft .NET Framework 2.0.50727.3074

    Operating System 6.0.6001

    If I need to get the latest downloads/service packs for SSMSE and SQL Server Express with Adv Services, what is the URL I should go to?

    If anyone has come across this issue before I will be grateful for any help.

    Thanks for your time.

Viewing post 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply