Solved

Help with MS SQL

Posted on 2011-09-20
2
241 Views
Last Modified: 2012-05-12
I'm in no way versed in MS SQL. I have a server running SBS 2003, and on this server is a piece of software that was written by another company that uses MS SQL 2000.  I'm thinking, probably a limited version, or express?  I have looked thru the Programs and cannot find any sort of SQL Server management software.  
   I have instructions from my backup software people to make some changes to my SQL database, to allow the software to run, but they start with accessing the SQL manager....
    My question, how do I gain access to this SQL database?  Is there something I can download to allow me to manage this database? And if so, what are the risks of installing said manager when the database is already installed and running?  
 
0
Comment
Question by:riteheer
  • 2
2 Comments
 
LVL 15

Accepted Solution

by:
riteheer earned 0 total points
ID: 36570476
 Well I think I managed to answer my own question. A little digging has turned up MS SQL Server Mgt. STudio Express.  For future use I've included this link to the download.

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=8961
0
 
LVL 15

Author Closing Comment

by:riteheer
ID: 36570479
I believe this might help future searchers.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question