Typically all SQL operations will run in a transactional context. Look at autocommit mode in the BOL index. Check out the subtopic Autocommit Transactions.

HTH,

Check out BOL. Search for Clustered Indexes in the index, and look at the architecture entry. You probably want the Clustered Indexes subtopic.

HTH,

Brian,

Thanks for the help. I ended up using your first solution. It's a little slow (little over a minute to run), but since it only needs to run...

Use a union.

Try this:

select c.CandidateID from tblCandidate c

INNER JOIN tblJobCriteria jc ON

jc.MatchAll = 1 AND (

...

Short answer: You're overrunning @vResponseText.

Long answer: If you add in

EXEC sp_OAGetErrorInfo @vPointer

after the responseText line, you'll see that srv_convert (which is probably called in sp_OAMethod) is...

That still doesn't help with determining what the last 5 records for an ID are. The history table may have numerous records per ID (it's around a million rows...

The only thing I can think of is to not use the SQL Mail xp_ calls. That's where you're getting hung up. You could redo the email functionality...

Not quite. Assume the following for sample data: (RealTime has greater precision than this data. It's a datetime field. I'm just lazy.)

ID | Canned | RealTime

----------------------

1 ...

Thanks, Jonathan.  That worked like a charm.

I think the problem is that SQL things @tableName is a Table variable and isn't converting it out to an actual table name in this statement. 

   DECLARE formCurs CURSOR...

You're using the actual table and not the Inserted virtual table.  This is what's happening:

Insert one row in System_Data, trigger fires and inserts the number of rows in System_Data into...

Andy got it. Opening up 1434 on the firewall did the trick.

Thanks!

-Brandon

You can try http://www.swynk.com. I usually use them for Exchange-related stuff, but they have a decent just-Windows section too.

-Brandon

SET is preferred over SELECT for simple variable assignments. (BOL - look under variable, assigning)

SELECT is typically used to assign the results of a T-SQL query into the specified...

Sounds like you used a local account to authenticate in SQL Server instead of using a domain account.

Try authenticating to it using this syntax:

\\machinename\username instead of just username.

where machinename is...