v7.2: Repository label

[kha]

I want to view the label that user added in for a repository. When I used vault client, show label, it takes forever and most of the time it's hung. Guess this repository is so big since I don't have the same problem with other repositories on the same database.

I want to show the label using the database/table. Is that possible? If so, can you provide me the query?

Thanks!

[Beth]

A few SQL changes and updates should help you show your labels.

Start with this change here: http://support.sourcegear.com/viewtopic ... 13&t=22358.

Then run the suggested SQL maintenance: http://support.sourcegear.com/viewtopic.php?t=2924.

After that, let me know your results.

[kha]

Hi Beth,

Will these queries cause any affect to the developers who work on the repositories?
The reason i am asking is if they might/will, I will need to get approval for the changes and schedule the maint. window

[Beth]

The developers won't notice a difference after they are set, but maintenance should be done after hours since it could slow down performance. Older versions of SQL have more of a problem with it than newer versions.