MS SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Databases > MS SQL Development
Reload this Page

Making database changes without logging in to the server.

Discuss Making database changes without logging in to the server. in the MS SQL Development forum on Dev Shed.
Making database changes without logging in to the server. MS SQL Development forum discussing administration, MS SQL queries, and other MS SQL-related topics. SQL Server is Microsoft's enterprise database engine.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old May 1st, 2008, 10:12 AM
richlion richlion is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2008
Location: Manchester UK
Posts: 3 richlion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 43 sec
Reputation Power: 0
Question Making database changes without logging in to the server.
Hi All,

I am a bit new to using MS-SQL, up till now my main adminstration was in Oracle.

I have a question, my developers make changes to my MS-SQL databases, however, they always login as a local admin or use their domain WIndows accounts - with the given privileges. Then they amend the database.
My idea is to avoid logging into an MS-SQL server without using a Remote Desktop. So they will need some kind of a client.

What is your experience and what would be the best way to do this? Meaning, what software can I use that does not require a license fee?

With Oracle I can install the Oracle client which has an SQLPLUS to login remotely. Does MS-SQL have something similar?

Thanks in advance.

I did use Google to search, I also have an MS-SQL Developer Edition, but this seems to come with another server itself.

Regards,
Richard.
Reply With Quote
  #2  
Old May 1st, 2008, 10:19 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,711 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 4 h 53 m 59 sec
Reputation Power: 259
You can perform a client only installation, it's one of the options the installer presents you.
Reply With Quote
  #3  
Old May 1st, 2008, 10:28 AM
richlion richlion is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2008
Location: Manchester UK
Posts: 3 richlion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 43 sec
Reputation Power: 0
Hi pabloj,

the funny thing I am still using the 2000 MS-SQL version, so when I run the installer I have the following options:

- SQL Server 2000 components
- SQL Server 2000 Prerequisites

In Components I have:
- Install Database Server
- Install Analysis Services
- Install English query


Which one should I choose?

Regards,
Richard
Reply With Quote
  #4  
Old May 1st, 2008, 11:46 AM
pabloj's Avatar
pabloj pabloj is offline
Modding: Oracle MsSQL Firebird
Dev Shed God 6th Plane (7500 - 7999 posts)
  
Join Date: Jun 2001
Location: Outside US
Posts: 7,711 pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level)pabloj User rank is Captain (20000 - 30000 Reputation Level) 
Time spent in forums: 2 Months 2 Weeks 6 Days 4 h 53 m 59 sec
Reputation Power: 259
Reply With Quote
  #5  
Old May 6th, 2008, 02:13 AM
richlion richlion is offline
Registered User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: May 2008
Location: Manchester UK
Posts: 3 richlion User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 40 m 43 sec
Reputation Power: 0
Oh, thanks, that's really interesting.
I'll see how it works.

Regards,
Richard
Reply With Quote
Reply

Viewing: Dev Shed Forums > Databases > MS SQL Development > Making database changes without logging in to the server.

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 3 hosted by Hostway.