Solved

Trying to install isolated instance of Microsoft SQL

Posted on 2004-09-16
3
238 Views
Last Modified: 2006-11-17
Hi,

I'm a brand new user of Microsoft SQL.  

I installed MS SQL on my computer which is attached peer to peer to my boss' computer and we have some valuable data on his computer.  

Basically, I want to get an isolated version of SQL running on my computer so I can muck around with tables and not worry about deleting things.

Following is what I see on my version of SQL

>Console Root
   >Microsoft SQL Servers
      >SQL Server Group
         >Ori (Windows NT)
            >Databases
            >Data Transformation services
            >etc.

Can I just use add remove programs to remove SQL from my computer without messing up his version or data on his computer?

I tried to install a new server group and a new registration.  They seemed to appear, but they didn't have anything in them (ie. the basics like pubs, etc.)

What would you recommend I do?

Thanks,

Evan
0
Comment
Question by:EvanBrenner
  • 2
3 Comments
 

Accepted Solution

by:
onwin earned 125 total points
ID: 12079280
Probably, you are connecting to your boss's SQL server setup on his computer using the SQL Client Tools on your computer. You can use the Add/Remove programs to remove the SQL Server software on your computer without deleting any data present on the SQL Server database setup on your boss's computer.

To have a separate isolated version for yourself, you can install the SQL Server Personal Edition on your computer as a separate SQL Server and work on it and copy the database from your boss's computer onto your server and then use it.

Hope this information helps.
0
 

Author Comment

by:EvanBrenner
ID: 12079315
Yes, that seems like the best route.

Thanks!
0
 

Author Comment

by:EvanBrenner
ID: 12079327
Forgot the accept, so here it is.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now