Tiago Duarte

Issue: Getting this issue when picking databases over Management Studio from SQL Server: "The database XXX is not accessible. XXX.Express.ObjectExplorer" Solution: Open Microsoft SQL Server Management Studio with right-click, as admin

select * from (select top 1 Content, ID, Picture, Title, SubTitle from HeaderBannerJQ_Slides where Content=1 order by newid()) as res union all select * from (select top 1 Content, ID, Picture, Title, SubTitle from HeaderBannerJQ_Slides where Content=2 order by newid()) as res union all select * from (select top 1 Content, ID, Picture, Title, SubTitle from HeaderBannerJQ_Slides where Content=3 order by newid()) as res Resource: http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/05/18/using-top-and-order-by-with-union-union-all.aspx