Tag Info

New answers tagged

1

On the question of the size of things, first of all you said that you shrank a database, so that would reduce the DB size of the space that was discarded during the shrink. John M also provided some clarification. Regarding the numbers in the bottom picture, they are: select (2585832 / 1024.0) /* KB from the Reserved in the bottom picture to MB */ ...


0

The default install of SQL Express installs a named instance, SQLExpress. To have more than one instance, you'd have to have done more than one install. You probably just need to refresh the one that is missing the databases in your image. If you think you have more than one instance of SQL Express installed, you can verify this by opening the SQL Server ...


2

Hypothesis one: You have installed a named instance called SQLExpress. This instance was configured to listen on the default SQL Server port 1433. Therefore wether you connect to 'localhost' or to 'localhost\SQLExpress', you are connecting to the same instance. Hypothesis two: You have installed two different SQL Server instances, one named SQLExpress and ...


0

Possible duplicate: https://stackoverflow.com/questions/5170/sql-server-management-studio-alternatives-to-browse-edit-tables-and-run-queries/5270#5270 I agree with the accepted answer there: LinqPad which is small and portable (you can use SQL instead LINQ, no worries).


0

For a default instance (MSSQLSERVER), you only specify the computer name when connecting; the instance name (which is actually a ficticious placeholder) is implied. Also, if you're connecting from another machine now, you may need to configure the Windows Firewall to allow connections through. The error message you get will be the same as the one you're ...


0

Open SQL Server Configuration Manager. That will likely show you the answer to your problem. In SSCM you should be able to see what database instances are installed, what their instance names are, what ports they run on, and whether the services are up. There could be a number of different reasons you're getting this such as the server is not started or ...



Top 50 recent answers are included