Can you give a small sample query? I would like to see both the text that would/should be passed to the DB2 machine, and the actual statement executed at...

No, I am afraid not. The Stack space is not one of the configurable options.

In any case, if this is a huge IN statement (for example), then using an...

This looks like an error documented by MS in mixed NT/2000 domains. See:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q241/6/43.asp&NoWebContent=1

Also look at this:

http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/Articles/q233/1/61.asp&NoWebContent=1

When using nested cursors, you end up being dependent on when you read your cursor in the loop. For example:

declare c_1 CURSOR FOR

SELECT Field1 From...

Your WHERE clause comes after all of the JOIN clauses:

UPDATE master

SET Port_Desc = SPEED.Port_Desc

FROM Port_Type SPEED

LEFT OUTER JOIN ACCESS ACCESS on

ACCESS.Post_CD ...

quote:

---

quote:

---

Actually got it right without knowing, just by reading the error message. CoCreate...

I am afraid that your insert statement is, in the technical tems used where I work, 'hosed'

'Insert Into TraceObjects Select '...

I like concise questions, but that was ridiculous. No wonder it was a three-point question

Actually got it right without knowing, just by reading the error...

There are a few ways to accomplish this. First, if what you want is a custom error, then you can use sp_addmessage, and RAISERROR to do this. For...

This sounds related to something that happened when we upgraded, where comarisons of numeric and varchar data do not always succeed -- probably because, instead of converting the numeric value...

If I am reading this query correctly, you need to remove the reference to the v_site table in the subqueries, instead using the value from the v_site table in the...

Yes, you can back up non-locally, as long as the SQL Server login can see the data space. Your command would be something like:

BACKUP DATABASE MyDB TO DISK =...

Does TableA in the real data have an ID value? If so, try this:

DELETE tableA

WHERE tableA.ID IN

(Select Distinct TableA.ID

FROM TableA

INNER JOIN tableB

ON tableA.par1 = tableB.par1

AND...

Well, you could modify your code to create a query to return the data like that:

CREATE PROCEDURE usp_count_grades_KS1

@ui_category varchar(30)

AS

DECLARE year_cursor CURSOR

FOR SELECT distinct(DataInYear)

from akay.KS1

group by DataInYear

order by DataInYear

DECLARE @year varchar(4)

Declare...

There is no direct equivalent in SQL Server. However, in SQL Server 2000, you can create a UDF to emulate this function.

However, there is an easier way to do...