There's a little bug in the CTP SP1 release of SQL2005.
Opened MS SQL Server Management Studio. Connected to a SQL2005 64bit server with 6GB memory. Choose Summary, Report, Memory Consumption and in the graph for Buffer Pages Distribution (#Pages) there's no graph, but the following error "Unable to retrieve data for this section of the report. Following error occurred. Msg 8114, Level 16, State 1 Error converting data type bigint to int.". The SQL2005 32bit didn't show this error after upgrading with CTP SP1, but it has less memory (2 GB).
Regards
Peter
Error in Report "Memory Consumption" after upgrading with SQL2005 CTP SP1
Hot Topic
- Selecting multiple values for a parameter
- Subtotals broken in Report Builder?
- Custom connection manager development sample?
- Ignore Grouping
- Strange problem about report export formats
- Notification Services & Triggers
- RUNNIG A JOB???
- Fuzzy Grouping: Any success with > 3 million records?
- Instert found records into DB
- MCTS Exam 70-431 Database Administration Study Documementation and Samples ?
SQL Server
- Issue with SqlUserDefinedAggregate
- Can`t access Report Manager
- SQL Server Management Studio Express CTP will not start
- Pivot misunderstood ??
- Threading in Custom Components and Script Components
- DataBase Connection
- changing existind dimension datasource
- decimals
- connecting to SQL Server 2000 Instances
- Wishlist: MOST WANTED Tasks, Sources, Transformations, and Destinations?
Error in Report "Memory Consumption" after upgrading with SQL2005 CTP SP1
Michael D. Fox
Peter
madhavan
Peter,
I'm moving this thread to the Tools General forum as they'll be best able to help you.
-Jeffrey