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 |
|
cddot
Starting Member
37 Posts |
 Posted - 2010-07-19 : 03:39:37
|
| On a PC I'm looking at, the SQL Server software installation doesn't have Management Studio or sqlcmd. This is probably an embedded installation that came with the application, but not sure.In such, cases how can one access the server to do some maintenance work? Install the additional tools would be one answer, but I'm wondering if there is some other way? |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2010-07-19 : 08:14:20
|
| As a minimum you will need a method of connecting to the database , assuming your logon has sufficient permissions, and then send sql statements . For example , without having sqlcmd or SSMS , you could set up a web page - that allows you to input the commands ,connect to the database and execute. asp .net framework is suitableJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-07-19 : 16:06:15
|
| I think there may be some web administration tools.. third party tools most certainly will offer some web version.. check if the SQL Web Data Administrator works for you - http://sqlwebadmin.codeplex.com/Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
|
|
|
How to access without sqlcmd or Mgmt Studio