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...
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....