It would help if you posted the error message and the table definitions. See the links in my signature line for some advice on how to get better, faster...

Could be that in 2000 you can't set that property using an expression, but I find that hard to believe. I wish I could be of more assistance,...

The fastest way to accomplish this task is to create a lookup task and instead of passing on the rows that find a match you pass on the rows that...

Notifications can only be sent to one Operator. The best way to handle group emails is through an email group/distribution list.

Profiler is the right tool for the job.

You need to add either the DatabaseID or DatabaseName column to your Profiler output, then you can filter on it. ...

I don't normally use BEGIN-END blocks around my stored procedure code. I do always use BEGIN-END blocks with control of flow statements (IF, WHILE) though.

Sure it's possible, but I'm not sure you are going about it the best way.

Are you operating against 2 databases on different servers?

What is your name changed...

DB_Andrew (8/19/2008)

---

Instead of preaching your “RBAR” cliché and putting people down for doing it the wrong way why don’t you get off your soap box and make yourself helpful for...

I am attaching the source for a custom component I have developed to do this task. I make no warranties about the code. Remember that the component needs...

Do you still have the Debug item on the menu? Have you checked under View -> Toolbars that the Standard toolbar is active?

Search this site for "Tame Those Strings". There is a series of articles on string manipulation and one is about doing what you need to do.

If all you have are 7 workstations I would buy Client Access Licenses?

With this limited # of users is there any reason why you could not use SQL Server Express?...

That seems like a good solution that should not have an impact on performance and may actually improve the report performance. Wish I'd thought of it.

I would venture to say that the only way to do what you want is to create a local login or local logins on the Report Server and then grant...

I have not found that counter in any.