SQL Server Management Studio 2008 32 bit

I've been having issues running anything in SQL Management Studio on Win 7. Basically, doing anything through the Management Studio interfaces completely freezes it up for a few minutes. Running a query is nearly impossible because it takes nearly 2 minutes just for the IDE to parse it and another minute to run it when the query itself completes instantaneously outside of the IDE. I'm not even going to go into the query designer. Anything with heavy user interaction such as editing a row in the result set where i have to click a cell freezes up the front-end. I tried reinstalling to no avail. Also tried running in compatibility mode without any difference whatsoever. Anybody had a similar experience?

I'm running SQL Management Studio 2008 version 10.0.2531.0 on 32-bit Windows 7. Connecting to a remote SQL Server instance (2008 R2).

Thanks.

Access, configure, manage, administer, and develop all components of SQL Server.

Microsoft SQL Server 2008 Management Studio Express (32-bit) Editor's review

FromMicrosoft:Microsoft SQL Server 2008 Management Studio Express (32-bit) is an integrated environment for accessing, configuring, managing, administering, and developing all components of SQL Server. SQL Server 2008 Management Studio Express combines a broad group of graphical tools with a number of rich script editors to provide access to SQL Server to developers and administrators of all skill levels. Developers get a familiar experience, and database administrators get a single comprehensive utility that combines easy-to-use graphical tools with rich scripting capabilities.
Download (168.27MB)


Similar Suggested Software

SQL Server Management Studio 2008 32 bit

DTM Data Modeler

Work with logical and physical data models in the form of an entity-relationship diagram.

titledescriptionms.servicems.subservicems.customms.datems.reviewerms.topichelpviewer_keywordsms.assetidauthorms.authormonikerRange

SQL Server 2008 R2 SP2 Release Notes | Microsoft Docs

This Release Notes document describes known issues that you should read about before you install or troubleshoot Microsoft SQL Server 2008 R2 Service Pack 2.

sql

release-landing

07/22/2020

conceptual

SQL Server 2008 R2 SP2

Release Notes, SQL Server 2008 R2 SP2

e2bd3de7-674c-4ea7-8d53-bb40bba86fae

MikeRayMSFT

mikeray

= sql-server-2016

SQL Server 2008 R2 SP2 Release Notes

[!INCLUDEsqlserver] This Release Notes document describes known issues that you should read about before you install or troubleshoot Microsoft SQL Server 2008 R2 Service Pack 2. This Release Notes document applies to all editions of SQL Server 2008 R2 SP2 and is available online only. It is updated periodically.

1.0 What's New in Service Pack 2

Added the dynamic management view (DMV) sys.dm_db_stats_properties. You can use this DMV to return statistics properties for a specified table or indexed view in the current database. For example, this DMV returns the number of rows that were sampled and the number of steps in the histogram.

2.0 Before You Install

For information about how to install [!INCLUDEsql2008r2] updates, see SQL Server 2008 R2 Servicing Documentation.

For general information about how to get started and install SQL Server 2008 R2, see the SQL Server 2008 R2 Readme. The Readme document is available on the installation media.

2.1 Choose the Correct File to Download and Install

Use the following table to determine which file to download and install. Verify that you have the correct system requirements before installing the service pack. The system requirements are provided on the download pages that are linked to in the table.

If your current installed version is...And you want to...Download and install...
A 32-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 Upgrade to the 32-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x86-ENU from here
A 32-bit version of SQL Server 2008 R2 RTM Express or SQL Server 2008 R2 SP1 Express Upgrade to the 32-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x86-ENU.exe from here
A 32-bit version of only the client and manageability tools for SQL Server 2008 R2 or SQL Server 2008 R2 SP1 (including SQL Server 2008 R2 Management Studio) Upgrade the client and manageability tools to the 32-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x86-ENU.exe from here
A 32-bit version of SQL Server 2008 R2 Management Studio Express or SQL Server 2008 R2 SP1 Management Studio Express Upgrade to the 32-bit version of SQL Server 2008 R2 SP2 Management Studio Express SQLManagementStudio_x86_ENU.exe from here
A 32-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 and a 32-bit version of the client and manageability tools (including SQL Server 2008 R2 RTM Management Studio) Upgrade all products to the 32-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x86-ENU.exe from here
A 32-bit version of one or more tools from the Microsoft SQL Server 2008 R2 RTM Feature Pack Upgrade the tools to the 32-bit version of Microsoft SQL Server 2008 R2 SP2 Feature Pack One or more files from Microsoft SQL Server 2008 R2 SP2 Feature Pack
No 32-bit installation of SQL Server 2008 R2 Install Server 2008 R2 including SP2 Go to SQL Server 2008 R2 SP2 - Express Edition and follow the instructions.
No 32-bit installation of SQL Server 2008 R2 Management Studio Install SQL Server 2008 R2 Management Studio including SP2 SQLManagementStudio_x86_ENU.exe from here to install the free SQL Server 2008 R2 SP2 Management Studio Express Edition.
A 64-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 Upgrade to the 64-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x64-ENU or SQLServer2008R2SP2-KB2630455-IA64-ENU.exe from here
A 64-bit version of SQL Server 2008 R2 RTM Express or SQL Server 2008 R2 SP1 Express Upgrade to the 64-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x64-ENU.exe or SQLServer2008R2SP2-KB2630455-IA64-ENU.exe from here
A 64-bit version of only the client and manageability tools for SQL Server 2008 R2 or SQL Server 2008 R2 SP1 (including SQL Server 2008 R2 Management Studio) Upgrade the client and manageability tools to the 64-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x64-ENU.exe or SQLServer2008R2SP2-KB2630455-IA64-ENU.exe from here
A 64-bit version of SQL Server 2008 R2 Management Studio Express or SQL Server 2008 R2 SP1 Management Studio Express Upgrade to the 64-bit version of SQL Server 2008 R2 SP2 Management Studio Express SQLManagementStudio_x64_ENU.exe from here
A 64-bit version of any edition of SQL Server 2008 R2 or SQL Server 2008 R2 SP1 and a 64-bit version of the client and manageability tools (including SQL Server 2008 R2 RTM Management Studio) Upgrade all products to the 64-bit version of SQL Server 2008 R2 SP2 SQLServer2008R2SP2-KB2630458-x64-ENU.exe from here
A 64-bit version of one or more tools from the Microsoft SQL Server 2008 R2 RTM Feature Pack Upgrade the tools to the 64-bit version of Microsoft SQL Server 2008 R2 SP2 Feature Pack One or more files from Microsoft SQL Server 2008 R2 SP2 Feature Pack
No 64-bit installation of SQL Server 2008 R2 Install Server 2008 R2 including SP2 Go to SQL Server 2008 R2 SP2 - Express Edition and follow the instructions.
No 64-bit installation of SQL Server 2008 R2 Management Studio Install SQL Server 2008 R2 Management Studio including SP2 SQLManagementStudio_x64_ENU.exe from here to install the free SQL Server 2008 R2 SP2 Management Studio Express Edition.

2.2 Setup Might Fail if SQAGTRES.dll Is Locked by Another Process

Issue: A SQL Server setup operation might fail with this error: Upgrading of cluster resource C:\Program Files\Microsoft SQL Server\MSSQL10_50.\MSSQL\Binn\SQAGTRES.DLL on machine failed with Win32Exception. Please look at inner exception for details. The root cause is that C:\Windows\system32\SQAGTRES.DLL is locked by another process and Setup was not able to update it.

Workaround: Rename C:\Windows\system32\SQAGTRES.DLL to a temporary name such as C:\Windows\system32\SQAGTRES_old.DLL, and then select the Retry option on the setup error message. That will allow Setup to continue. After a reboot, you can delete the temporary file C:\Windows\system32\SQAGTRES_old.DLL.

3.0 Known Issues Fixed in this Service Pack

For a complete list of bugs and known issues fixed in this service pack, see this master KB article.

See Also

How to determine the version and edition of SQL Server

Is SQL Server Management Studio 32

SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems other than Windows, we recommend Azure Data Studio. Azure Data Studio is a cross-platform tool that runs on macOS, Linux, as well as Windows. For details, see Azure Data Studio.

Is there a 32

With most versions of Microsoft® SQL Server® there is a 32-bit version and a 64-bit version.

Is SSMS 32 or 64

And in 2022, SSMS is still 32 bit - Microsoft Q&A.

What version of SSMS works with SQL Server 2008?

SSMS Backwards Compatibility Version 18.4 will work with SQL Server 2008 through SQL Server 2019. Also, it is fine to have slightly older versions such as 17.