I think Sergiy's solution with bitbucket's modification should meet your needs. Of course I would think you still would want to at least have a start date because it...

A better way to handle this is to assign the user to the correct Role(s) in the msdb database. Here is the link to the BOL description of the...

In the Background color property of the cell you need to put in an expression like this:

=switch(Fields!FieldName.Value <= 25, "Green", Fields!FieldName.Value > 25 and Fields!FieldName.Value <= 50, "Yellow",

Fields!FieldName.Value >...

RaisError does not end processing of a batch. All you need to do is put a Return after the RaisError and the batch will stop there.

Check out this article, http://www.sqlservercentral.com/articles/T-SQL/63681/, it is about exactly what you are talking about.

Wish I could...

So how are you accessing the external source?

There really isn't an easy way to do it, nor is there an easy way to explain how I'd do it....

Thanks Jeff. My blog is http://www.wiseman-wiseguy.blogspot.com. It's also at the bottom of all my posts on the little button that says "blog". 😛

That's where I put the stuff...

It still doesn't make sense to me. How do you know that Agency 'ABC' was changed to 'XYZ', do you have a log table?

Could you post the schemas?

Shouldn't something...

Is the number of purchases based on rows in the table or a sum of the TotalPurchased column?

Do you want to use some kind of rolling total?

I think does what...

I don't know about you, but I am still confused.

Are you creating COMPUTED COLUMNS on a table or are you trying to create output columns in a query?...

I'll add my 2 cents here as well, since I found this thread through another, very similar thread.

I don't use the BEGIN-END block for stored procedures. I DO use...

If the monitoring software is running under a domain account you should be able to use a Trusted connection.

A second note is that you should not be shrinking your log...

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,...