We currrently have MSDE running a few databases, but I want to write a few
apps to help with reporting. Ive taken the db and log files from the server,
but cannot seem to get them running on my machine.

I currently have both Sql server2000 developer edition and MSDE on my
machine. I can access MSDE from the Enterprise Manager, but not sure where
to go from here. I plan on importing the data into Sql Server (we are moving
this solution to a new server with Sql Server,currently database size is
close to 2gigs...and we are having too many issues.) for developement
purposes and also to test out how it will work when we are ready with the new

hi Dan,
[quoted text, click to view]

in order to move a database to a different server you can detach it from the
current server, copy it where it will belong, re-attach it to the new
server..
Enterprise Manager can do it for you, both for detacching and re-attaching
operations... but for your convenience you can have a look at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_da-di_83fm.asp
...
once reattached, you can incur in "orphaned users" problems, where database
users lose their link to the relative SQL Server standard logins as the
trait-d'union, the sid value of database.dbo.sysusers system table and
master.dbo.sysxusers master table do not match on it or the database user(s)
is not present... but you can "fix" that using the sp_change_users_login
sytem stored procedure
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.asp),
but you can even have a look at
http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp for
further info about this topic...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply