if you mean how to read the syntax in the documentation, then I'd look up resources on BNF (Backus-Naur Form) or EBNF.

regards

Billy

@traceid is returned to you.  You cannot assign a value to @traceid.  @traceid is returned to you because you need @traceid to start the trace you just created (eg. EXEC sp_trace_setstatus @TraceID,...

hmm.. I also typed up a long response to this but it is not showing up after I click the post button (kinda frustrating).

anyways, stored procedures are good because they...

Impressive!  The people on this site never ceases to amaze me!

Billy

Thanks for your response.  Well, that is an option.  However, the amount of data not captured is related to the time it takes for someone to always remember to get back...

how about a nested query?

below demonstrates this type of query.

using northwind as an example:

SELECT X.ORDERID, FREIGHT, (SELECT SUM(FREIGHT) FROM ORDERS Y WHERE Y.ORDERID <= X.ORDERID) AS RUNNING_TOTAL

FROM ORDERS X

ORDER BY...

to see what permissions an object has, use  

sp_helprotect

from BOL: Returns a report with information about user permissions for an object, or statement permissions, in the current database.

HTH

Billy

what error number are you getting? is the database transaction log full or is there something that is preventing it from increasing in size?

HTH

Billy

not sure if I understand the issue correctly but would using SET ROWCOUNT be suffice in this situation.  what is the reason behind the need to break down the delete...

The reason for not installing terminal services and sql server on same box is one regarding performance.  I think I saw the same article on that website.  They recommend dedicated...

Somebody correct me if I am wrong but I think that when you use 99/2, you get 49 because both numbers are specified as integer.  Even though the answer requires...

SELECT 99/2 for me returns a result set of '49', not '49.0'.

Raymond, you are on right track but you must remember that NULL concatentated with something is NULL.

When you first assign value to @x, @x is NULL.

Therefore you need to set...

You are on the right track.  You can load the results returned from the stored procedure into a temporary table and then retrieve it from there.

below is an example:

set nocount...

Thanks Phill for posting the rewritten LEFT JOIN query.

Actually, it now got me thinking which version of the query is indeed "more acceptable" even though you are not supposed to specify...