MSSQL 7 Administration - Compact Database
Posted on 2010-11-11
Have a customer who has an application that makes use of a MSSQL7 instance. I see no tools whatsoever installed on this machine to admin the database. Customer is concerned because he was told his database was approaching the limit. I checked, and sure enough, the c:\mssql7\data\table.mdf file is approaching 2 gigs.
Question: how can I fix this? I know the name of the server instance, but do not know a username/password combo to connect to it. Thanks!