Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
JasonAnt
Starting Member
23 Posts |
 Posted - 2008-06-20 : 10:55:13
|
| Can I administrate database from client ?I used to do this by using win remote-desktop to windows server 2003, but since the administrator's password had changed (for security reason), I can do that anymore.The sys.Admin allow me to make changes in server room but I dont want them watching what I am doing, I may want to add some table, some field depend what users demand. what I have in my notebook is SQL2000 personal edition which cannot modify table's structure.Any suggestion will be very appreciated.Thanksps. sorry for my poor english |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-20 : 13:28:20
|
| Yes you can administrate from a client. I almost never connect to the server, but rather use client tools from my desktop.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-20 : 16:31:45
|
| Every one will do the Adminstrator work from Remotly, No one will do from the server itself. With the help of windows login(if having SA permission) you would be.ManojMCP, MCTS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-20 : 23:35:28
|
| >> With the help of windows login(if having SA permission) you would be.You can manage sql server remotely with sql authentication. |
|
|
|
JasonAnt
Starting Member
23 Posts |
Posted - 2008-06-21 : 05:09:24
|
| Thanks, but it seems that I have to install client tool in my notebook, which already have SQL2000 PE installed in it (not compatible with 2005), can I do that? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-06-21 : 06:26:17
|
| The sql server client tools will allow you to manage remotely , you could also consider a command line tool such as osqlJack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-21 : 16:49:46
|
| Yes you can install sql2k5 client tools. |
|
|
|
|
|
|
remote adminstrate sql database