Resolving Common Connectivity Issues

Useful link to resolving common connectivity issues. Applies to SSAS but also proves to be of use with IIS, SSRS & SQL Server.

http://msdn.microsoft.com/en-us/library/cc917670.aspx

SQL Server 2005 System Views

Here's a very useful schema showing SQL Server 2005 System Views:

 

http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&displaylang=en

https://docs.google.com/fileview?id=0B2hXx-EkjlNsMzdhNTc0MWQtMmE1Ny00MWM1LTgxOWItNDA4ZWI2ZTk2Nzlm&hl=en

Multivalued parameter drop down width - SSRS

I was working on a SSRS project where I was using multivalued parameters. This creates a drop down list whereby the user can select the relevant values. Unfortunately in SSRS 2005 (SP3) the width of the dropdown is fixed, which seems to me as a bit of an oversight.

I believe that this may be corrected by altering the HtmlViewer.CSS file or by programmatically fixing the width of the available parameter values.

Neither is ideal.

















I will look into whether this has been rectified in SSRS 2008.

Get current SQL Server Version - SQL

select @@version


For SQL Server 2005:

For SQL Server 2008 R2: