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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-02 : 09:28:52
|
| Stewart writes "Dear SqlTeam.com,i was wondering whether there are any programs that mimic the enterprise manager? I ask this question becuase my team members are unable to install or run the enterprise manager or sql server for that matter, and thus cannot connect to our SQL server to do any managment from remote. So i was wondering whether there are programs that allow me to connect to my sql server from remote and do all the functions that the enterprise manager does, well most if not all.Sincerely,Stewart Dunbar" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-02 : 09:30:43
|
| See if this helps:http://www.sqlteam.com/redir.asp?ItemID=7437It's pretty strange that they can't install Enterprise Manager. What version of Windows are they running, and what version of SQL Server are you using? The only thing I can think of is if they're using Win98 or WinME, that would cause them untold problems. |
 |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-02 : 09:51:22
|
| As far as I can tell, there no 'management' tasks that can be done with enterprise manager, that cannot be done using text based clients such as QA, ISQL or even OSQL.Jay White{0} |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-02 : 10:00:07
|
A. TrueB. However... B.1. If they CAN'T install Enterprise Manager, it's fair to assume that QA/isql/osql can't be installed properly either. All of these utilities are installed at the same time.B.2. If you have to set up replication and user permissions on a 1000+ table database using the system procedures only, you WILL be fitted for a very snug jacket with sleeves that tie in the back by the time you're done. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-02 : 10:06:19
|
quote:
you WILL be fitted for a very snug jacket with sleeves that tie in the back by the time you're done.
Isn't that what all DBA's wear to work?Jay White{0} |
|
|
|
|
|
|
SQL Server Client Programs