Posts tagged Management Studio
Detach, Move, and re-Attach database
01 year ago
The Transact-SQL Script below, is useful if you want to standardise the location of your databases. I have been managing a server whereby databases created by other people were created all over the place!! Therefore, this script was written to make life so much easier.
Be sure to read through [...]
Cannot Connect To SQL Server Analysis Services 2008
03 years ago
Whenever I tried to connect to Analysis Services using the SQL Server Management Studio 2008, I was getting the following error:
Cannot connect to [Computer Name]\[Instance Name].
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)
No connection [...]
