best way to interact with MSDE

Question

best way to interact with MSDE

yogiberr

Hall of Fame

Points: 3679
More actions
November 1, 2004 at 3:31 am

#102255

hiya,
I found myself installing sqlServer dev edition onto a machine that contained MSDE, simply so that I could use enterprise manager to :
1) attach a database
2) create a new user.
That can't be right 🙁
Is osql the recommended way to interact with MSDE, so that I can miss out the enterprise manager middleman?
many thanks,
yogi

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Farrell Keough SSCoach Points: 17414 More actions · Answer 1

If you do not want to use the Enterprise Manager, you can try with Access. But I had a client that used MSDE for field operations and I really prefered using Enterprise Manager to manipulate their database - I could even connect over the network if they were somewhere else but able to log into Citrix...

I wasn't born stupid - I had to study.

lholman SSCrazy Points: 2810 More actions · Answer 2

yogiberr,

for remote admin and development i have started to give some of our developers 'Microsoft SQL Web Data Administrator'

http://www.microsoft.com/downloads/details.aspx?FamilyID=c039a798-c57a-419e-acbc-2a332cb7f959&displaylang=en

it has a jazzy security admin tool, allowing you to create and edit logins and users.

for attaching databases i think you will still have to use system sprocs, but you can manage a heck of a lot with 'Microsoft SQL Web Data Administrator' if you have a dig around.

regards,

lloyd

p.s. it requires the .NET framework to be installed

yogiberr Hall of Fame Points: 3679 More actions · Answer 3

hiya,

I'll look into 'Microsoft SQL Web Data Administrator' sounds quite good.(we're dotnet people 🙂

I am curious though, as to the main reason for using osql.Is it so that "seasoned" users can manipulate the db quicker thru a commandline, rather than having to open up EM and point and click?

ta for the advice so far,

yogi

zaidk SSC Rookie Points: 37 More actions · Answer 4

hi there,

visit the following website and you will find vb source code for your own version of enterprise manager.

http://www.planetsourcecode.com/

regards

zaid

glively Mr or Mrs. 500 Points: 534 More actions · Answer 5

You can just install Enterprise Manager without the dev version of SQLServer database. I believe that you can install Enterprise Manager on as many machines as you want.

I have read that with the SQLServer 2005 MSDE (Express) you can no longer use Enterprise Manager. MS makes you use a much less "feature rich" tool.

yogiberr Hall of Fame Points: 3679 More actions · Answer 6

Hi Grasshopper,

It wasn't the fact that I couldn't install EM on as many machines as I wanted.It was the fact that I didn't think that I should have to install EM on the machine, simply because I wanted to do a few simple things to the database.

Thanks for taking the time to reply everyone.

I appreciate it.

yogi