Friday, March 30, 2012

manage the MSDE with command tool

i an newbie to MSDE, but i have experience Mysql before, can someone tell me how can i find help to manage MSDE with commands ??http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=631069

This pinned post at the top of this forum talks about one possible tool.|||sorry man, i think you misunderstood my question, actually i want to use command to manage MSDE.|||Do you mean you want to manage MSDE from the command prompt? If so then you are talking about osql. SeeHow To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql Utility

Terri|||thank for that,
by the way i found that my MSDE is unbeliveable slow, like you have to take a minute to show all the database in the MSDE(from command line), why it is so slow??|||Which command are you using to list the databases?

Terri|||exec sp_database
also when i use sql web data administrator is even more slower than command, it's like take 2 minutes to login, and 3 minutes to go to the query section.
i have no ideas what cause this

No comments:

Post a Comment