I need to work with MSDE on a new laptop ive been given. Apparently msde is already installed. I have a service runningnamed "MSSQL$MICROSOFTSMLBIZ" - how do i configure it, or shouldI just download a later copy of msde and setup a new copy ? Iknow I know...use sql express. However, I need to work with msdein this case to make it easier (on me) for moving the data into a sql2000 database.
thanks
So you have SQL2000 instance? Then you can register the MSDE instance in Enterprise Manager, thus it should be much easier to manage the MSDE databases: Open Enterprise Manager->right click a SQL Server Group->choose New SQL Server Registration.
Otherwise you have to use osql utility to manage MSDE, which would be painful if you're not familiar with T-SQL.
No comments:
Post a Comment