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.
 
 

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 ”?”’