I have a customers database (.sdf file). I want to open and view this database on my desktop through SQL Server 2000 Enterprise manager, however, I am having a hard time finding a driver to read the file. Does anyone know how to do this? I only need to do this for diagnostic work, not for replication. Thank you much,
Unfortunately Microsoft has not provided any way to read SDF files on the desktop. The only "official" way to do it is to put the SDF on a device and use a device app to push it to a server database.