Ramblings of a DBA

Tara Kizer
posts - 166, comments - 837, trackbacks - 75

My Links

Advertisement

News

Subscribe
Search this Blog

Archives

Post Categories

Work

January 2005 Blog Posts

Reporting Services Tip #3

Reporting Services Tip #3 - rs.exe, backslash problem In a previous blog, I wrote how you can deploy your reports via Report Manager.  It was mentioned in the comments section that "you can use the web service to upload the RDL directory from code".  Recently, I started to look into this so that deploying reports would be easier, that is without the deploy option in Visual Studio.  Reporting Services comes with a command line utility, rs.exe, that allows you to administer Report Server via scripts that run Web Service operations.  These scripts must be written in VB.NET and a suggested extension...

posted @ Wednesday, January 05, 2005 11:03 AM | Feedback (22) | Filed Under [ SQL Server - Reporting Services ]

DBCC DBREINDEX Stored Procedure - new version #2

EDIT: fixed problems found by gam. I have made yet another change to the DBCC DBREINDEX stored procedure. I modified it so that when a clustered index gets rebuilt, we don't rebuild the other indexes since that happens automatically for us. I made this change a little while ago, but I hadn't posted it yet. It's a good thing since I had to change it again. It turns out that only when a non-unique clustered index gets rebuilt, that the non-clustered ones get rebuilt as well. So when a unique clustered index gets rebuilt, we still need to rebuild the non-clustered ones....

posted @ Tuesday, January 04, 2005 11:46 AM | Feedback (32) | Filed Under [ SQL Server - Database Administration ]

Powered by:
Powered By Subtext Powered By ASP.NET