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.

You would use an Execute SQL Task, but it sounds like you could do this in a simple SQL Server Agent Job, unless you need the parameters to be set...

You can use nested IIF's or a Switch in the expression for background color on the control. Switch would work like this:

=Switch((colA*colB)/colA =25, "Yellow")

Of course I believe that...