There is a free tool called SQLCheck from Idera (http://www.idera.com/Products/SQLcheck/) that shows some key perfomance stats.  Of course, since it is free it does not save the stats.  They...

In this instance you should not need to provide any locking hints as SQL Server will use the lock with the smallest granularity (likely Rowlock) in this instance.

There is a DTS task in SQL2000 to transfer jobs.  The source can be a SQL 7 server and you can select the specific jobs you want to transfer.

There is definitely an impact on performance.  The issue is where the query is actually run.  I believe OPENQUERY runs the query on the remote server so the overhead is...

It's hard ot say what the problem without seeing the report.  I have a Matrix Report that i sugly in Excel because it has drill down, but all the data...

I have not experienced any issues exporting to Excel.  A couple of questions:

1. Is Excel installed on the PC running the report?
2. What version of Excel is being used?  I don't know for sure,...

I would guess MS will not add an export to Word for the following reasons:

1. In my experience most people want to manipulate the data in a report so Excel is better
2. MS...

I have not done a lot with RS, but a couple of issues I have found are that as you say does not print and that the parameters cannot be...

I am currently experimenting with the Development Environment, but have found a book would be helpful in order to shorten the learning curve for things like drill-down and then there...

It was a poorly wordrd question becasue SERVERPROPERY  is only supported in SQL2K (version 8 ).  Thus when I tried it on my...

THanks for your answer, I had tried all of that.  The answer was, that when the install was copied ot a network location it was corrupted.  When I installed from...

Having just started working with RS, I don't know how much help I can be, but have you tried saving after the change and then going to the preview pane?

I have seen this problem as well.  The issue could be that your NT login does not have rights on the SQL server or database or the SQL Server is...

SQL Server will not use an index on a (LIKE '%query')  filter so you might want to reconsider this type of query. 

SQL Server will not use an index on a (LIKE '%query')  filter so you might want to reconsider this type of query.