Blind I may be, where are the trigger(s), sample data, expected results after processing?

Does this batch file you are trying to run on a remote server, run ON the remote server or just FROM the remote server?

sureshdeenu (12/18/2009)

---

Declare @UpdateText as VarChar(2000)

Set @UpdateText =

'Update GeStatus ' +

'Set ChangedRecordX = ''x'', ' +

'[' + RTrim(@ChangedFieldName) +'] = ''x'' ' +

'Where Client = ''' + RTrim(@Client) + '''...

CirquedeSQLeil (12/18/2009)

---

Pricing is where I am coming from. In pricing the two, I have noticed the price gap close to about $100. For that $100 I can get...

I guess no one answered him quick enough. 😛

Help us help you, please read and follow the iinstructions in the first article I reference below in my signature block regarding asking for assistance. Also, based on the...

Jeff Moden (12/18/2009)

---

Lynn Pettis (12/15/2009)

---

Magy (12/15/2009)

---

But it didn't order the data according to my ORDER BY clause...that's why I'm confused.

When I run the cursor, and then check the...

I have an idea, show us the code that is failing instead of just the error message. That really isn't helping much.

sureshdeenu (12/18/2009)

---

RAISEERROR statement is not in the stored procedure. I have got the error like this:

Executed as user: xxxcorp\sqladmn. ...X] = 'x' Where Client = '4600' And SequenceNumber =...

Someone should just call Redgate. Yes, I know, for many of us that is a long distince international call, but there are a few denizens of The Thread that...

Per BOL (Books Online, the SQL Server Help System) regarding error message 50000:

When RAISERROR is used with a msg_str instead of a msg_id, the SQL Server error number and native...

Almost sounds like...

Too bad your using SQL Server 2000, I think I have a neat way of doing this in SQL Server 2005/2008.

mrpolecat (12/18/2009)

---

It doesn't matter which code gets assigned to which member. There is no relation until the code is assigned. It only matters that once it is assigned...

For my edification, this means that each download code can be assigned to one and only member, correct?