SSMs is convenient to connect to a remote SQL Server server.
Yesterday, I used SQL Server 2012 SSMS to connect to SQL Server, which was an error, such as:
Search on the Internet, reference to the reference that, too verbose, is indeed the inherent problem of software, Microsoft will definitely send patches to solve!
So looked at my version of SQL Server 2008, in the SSMs interface, help--about. Not as obvious as the following version of Windows:
But 10.0.xxxx.x, I only know 10.0 of SQL Server 2008, if the previous 10.5 is SQL Server R2, if 11.0 should be SQL Server 2012. But specifically SP a few don't know, Then I found out on the Internet that I was SQL Server 2008, no service Pack. That must be my version is too low, the online introduction is a specific patch it. I just simply put sp1,sp2 all dozen, the result is finished SP1 problem still, finished SP2 still the same problem, dizzy! A search, there are SP3, and then hit SP3, finished playing on the OK. The SSMs version becomes the following 10.0.5512.0.
Start to want to skip directly SP1 directly to play SP2, want to test SP2 patch package contains SP1. After the result SP1 download completes first, then follow the steps to come.
sp1:http://www.microsoft.com/zh-cn/download/details.aspx?id=26727
sp2:http://www.microsoft.com/en-us/download/details.aspx?id=30437
sp3:http://www.microsoft.com/en-us/download/details.aspx?id=44271
Original: http://www.mamicode.com/info-detail-25069.html
Index exceeded array bounds (MICROSOFT.SQLSERVER.SMO)