February 13, 2009 at 2:11 am
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy