Build the SQL String using the SP name and all parameters then put where you normally insert the Query string in the code. Works just fine.

Thanks Brain, had not seen that before.

Yes, I have not done this myself but do recall the big issue is you have to keep 6.5's client tools installed to access it with it's version of EM....

We discussed this not long ago in another thread and ultimately this was the solution we agreed probably gave the best performance and locked the row long enough itself to...

Look at sp_help_job in BOL you can look for a job with a specific @execution_status. This should help.

You could try to write wrapped in Dynamic SQL. Otherwise it goes out of scope and cannot be done at all.

This si one of the builtin Demo Alerts MS ships SQL with. Most people remove it. The name is Demo: Sev. 25 Errors which is short for Serverity 25...

Andy meant

char(ascii(right(colname,1))+1)

he just typoed.

Here is another possibility I find usefull soemtimes. I have seen another way to do this once which was even cooler but off hand I don't remember it.

--Build a table...

I also use UPDATE triggers to prevent this for safety, you can determine which coolumn is being updated and if the one in question force a rollback and the data...

I will try to remember but me and another programmer got into a conversation about this a few months back (we both work with C). When the 16bit processor was...

I have seen no such issue myself. However many don'ts are holdovers from the 16Bit processor days, 32bit processors made considerable leaps in the world of data comparison. In fact...

There are several ways you can do this. Building on 5409045121009's setup here is another with a bit less subquerying.

SELECT

a.GroupID,

a.TaskID

FROM

Test a

INNER JOIN

(SELECT iq.GroupID, Min(iq.Created) AS...

You can similar performance using Microsoft Full Text Indexing, see BOL topic "CONTAINS" for more info. However, I do believe Verity also makes the same exact app for SQL Server...

Get an MSDE copy, and install the SQL tools from SQL 2K eval edition. Anyway, I have a major task ahead of me building a database to handle call routing...