Month: January 2009

Jerry Yasir

Talking about invalid character when I browse Reports


SQL SErver 2005 Reporting Services Error
 
 
A name was started with an invalid character. Error processing
resource ‘http://localhost/Reports/’. Line 1, Position 2

<%@ Page language="c#" Codebehind="Home.aspx.cs"
AutoEventWireup="false"
Inherits="Microsoft.ReportingServices.UI.HomePag.

 
Thanks to —
 
check and make sure that the Reports and
ReportServer websites in IIS are setup for the correct version of the dotnet
framework. For RS 2000 it should be 1.1 for RS 2005 it needs to be 2.0.
 
Then An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.
 
Delete the Report Server Directory from IIS and Create it again using the reporting services configuration tool.  THis will solve the problem.
 
 
Jerry Yasir

Talking about SQL SERVER – 2005 – List all the database « Journey to SQL Authority with Pinal Dave


  —-SQL SERVER 2005 System Procedures
EXEC sp_databases
EXEC sp_helpdb
    —-SQL 2000 Method still works in SQL Server 2005
SELECT name 
    FROM sys.databases
SELECT name 
    FROM sys.sysdatabases
    —-SQL SERVER Un-Documented Procedure
EXEC sp_msForEachDB ‘PRINT ”?”’