18 Januari 2011 16:51
We are upgrading from SQL2000 to SQL2008R2. Several years ago we had someone install and develop reports for the RSExecutionLog Database - SQL2000. That developer no longer works here and I've spent several days understanding the current process and looking to upgrade to the 2008R2. I've downloaded several items from CodePlex trying to find the createtable.sql script and the RSExecutionLog_Update.dstx packages. When I install the downloads, these files are not part of the download.
Does anyone know where I can get the latest code to be able to develop these reports on 2008R2? It looks like I should be able to upgrade, but the files just don't exist.
Thanks in advance
03 Mei 2011 19:35
You should check this : http://sqlserversamples.codeplex.com/releases/view/30803
Make sure to download the SQL2008.All_Product_Samples_Without_DBs.zip file and you'll find what you're looking for on Server Management Sample Reports\Execution Log Sample Reports.
Just make sure to change the createtables.sql script by extending the statuscodes.status field to nvarchar(40) instead of nvarchar(32). This was compatible with 2005 version of reportserver database exutionlog table. On the otherwise you could see your ETL package failing
15 Mei 2012 6:04
there are two samples for SQL Server 2008 and SQL Server R2, you should download Samples for SQL Server 2008, Since it can be installed in both SQL Server Databases and it contains Complete sort of application and scripts you need.
you should download aformentioned samples from here http://sqlserversamples.codeplex.com/releases/view/30803
- Disarankan sebagai Jawaban oleh Mr. WhartyMicrosoft Community Contributor, Moderator 16 Mei 2012 23:34
- Ditandai sebagai Jawaban oleh Mr. WhartyMicrosoft Community Contributor, Moderator 25 Mei 2012 4:22