Confirming the right hyperlink

Hi,
We create rdl files which contains <Hyperlink> elements. The
value for hyperlink is an expression build using report parameters,
field parameters etc and also contains calls to custom assemblies
eg : <Hyperlink>=Parameters!Param1.Value + CustomAssemblyCall + Fields!
someField.Value<Hyperlink>
When this report is rendered by HTML Rendering extension(by specifying
HTML4.0 in the format string passed to render() method) this
<Hyperlink> element is converted to href attribute of the <a> tag.
We have a scenario where we want to test whether this href url
generated is correct or no without deploying the rdl file on the
report server.
Is there any way to pass the xml file and find out what would be href
value when the <Hyperlink>
element is parsed by the report server ?
Any report server dll's which can directly be used ?
Thanks in advance,Can anyone guide me on this

Confirming Processor Usage

After installing the SQL Server 2000 Standard Edition, how
can one tell that all processors and memory are being used
by SQL Server?
I realize that applications should receive a faster
response time, but there must be a way to check on the
server box itself (or within SQL Server) that it is
utilizing all available processors (or whatever the
maximum number of processors that SQL Server 2000 Standard
Edition is capable of using).
Can someone please let me know as I'm hard pressed right
now to find anything out there that indicates a way of
checking this item.
Thanks.
HouseYou can use the performance monitor tool that comes with Windows. I think
it's actually called System monitor now. There are lots of counters related
to the processors, disks, sql server etc. These may get you going:
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly
SQL Server MVP
"Jason House" <jason.house@.ns.sympatico.ca> wrote in message
news:052301c34be0$0143bd80$a101280a@.phx.gbl...
> After installing the SQL Server 2000 Standard Edition, how
> can one tell that all processors and memory are being used
> by SQL Server?
> I realize that applications should receive a faster
> response time, but there must be a way to check on the
> server box itself (or within SQL Server) that it is
> utilizing all available processors (or whatever the
> maximum number of processors that SQL Server 2000 Standard
> Edition is capable of using).
> Can someone please let me know as I'm hard pressed right
> now to find anything out there that indicates a way of
> checking this item.
> Thanks.
> House

Confirming encryption when Replication is over SSL

We are using SSL to secure merge replication from client to server. Though
we can check through network monitor whether data is encrypted for normal
query to database, for replication how can we confirm that data is
encrypted - as data is already being send in binary format.
Could you please let me know how to check if data is encrypted when we do
replication over SSL.
Thanks,
Ganesh.Same process Ganesh. Run one of the Agents in Replication such as the
Distribution Agent and verify that the data being sent is encrypted using a
network sniffer or Microsoft Network Monitor. Running SQL Profiler will
show the data un-encrypted.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks Kevin.
Ganesh.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:c4bYLAiLEHA.2364@.cpmsftngxa10.phx.gbl...
> Same process Ganesh. Run one of the Agents in Replication such as the
> Distribution Agent and verify that the data being sent is encrypted using
a
> network sniffer or Microsoft Network Monitor. Running SQL Profiler will
> show the data un-encrypted.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>