What version of SQL Server Management Studio do I need to open this DB

D

dc2000

New member
Member
VIP
Local time
11:43 PM
Messages
153
We have this software at work that is using the Microsoft SQL Server to store its database. It's an old product that the developer doesn't seem to support anymore. But I need to change some settings that are not available via the UI. So I wanted to open the raw .sql file to see what's going on.

I see in CP that it uses SQL Server 2005 as such:

2mh0ZoZ.png


Does anyone know what version of SQL Server Management Studio do I need to install on that machine to open that database file?
 

My Computer My Computer

At a glance

Windows
OS
Windows

My Computers My Computers

System One System Two

  • At a glance

    Windows 7 pro/Windows 10 ProIntel i7 860 Quad core 2.8 ghz8 gbATI Radeon HD 5770 1 gb ram
    Computer type
    PC/Desktop
    Computer Manufacturer/Model Number
    HP Pavillion Elite HPE-250f
    OS
    Windows 7 pro/Windows 10 Pro
    CPU
    Intel i7 860 Quad core 2.8 ghz
    Memory
    8 gb
    Graphics Card(s)
    ATI Radeon HD 5770 1 gb ram
    Monitor(s) Displays
    Alienware 25 AW2521HF & Viewsonic
    Screen Resolution
    1920 x1080 & 1680x1050
    Hard Drives
    WD blue 1 tb & 500 gb.
    Browser
    FF of course.
    Other Info
    https://www.bestbuy.com/site/hp-pavilion-elite-desktop-intel-core-i7-processor-8gb-memory-1tb-hard-drive/9921493.p?skuId=9921493

  • At a glance

    Windows 2012 R2 Data center/Linux Minti3 9100 3.6GHz, 8M cache, 4C/4T8GB 2666MT/s DDR4 ECC UDIMM
    Computer type
    PC/Desktop
    System Manufacturer/Model Number
    Dell Poweredge T140
    OS
    Windows 2012 R2 Data center/Linux Mint
    CPU
    i3 9100 3.6GHz, 8M cache, 4C/4T
    Memory
    8GB 2666MT/s DDR4 ECC UDIMM
    Monitor(s) Displays
    Viewsonic
    Screen Resolution
    1680x1050
    Hard Drives
    1 TB & 750 GB
    Other Info
    https://www.dell.com/en-us/work/shop/productdetailstxn/poweredge-t140?~ck=bt
That's what I was looking at also!
 

My Computer My Computer

At a glance

Win 10 x64, Linux Lite, Win 7 x64, BlackArch,...
Computer type
PC/Desktop
Computer Manufacturer/Model Number
HP Desktop & Compaq Laptop
OS
Win 10 x64, Linux Lite, Win 7 x64, BlackArch, & Kali
Hard Drives
Samsung 850 Pro 256Gb,
Hitachi HDD 1Tb,
Crucial MX SSD 250Gb
Segate 3Tb USB 3.0 Ext. Backup HDD
Internet Speed
150Mbps dn, 20Mbps up
Antivirus
Avast Free, Malwarebytes Anti-Exploit & Anti-Ransomware
Browser
Firefox, Chrome, Opera, & VPN
You must log in or register to reply here.

Similar threads

How to install MS SQL Server Management Studio on Win7?
Replies
1
Views
2K
townsbg
townsbg
re install microsoft SQL server management studio express
Replies
1
Views
3K
maxie
maxie
Back
Top