J,

Try running the following through QA under the same account:

exec master..xp_cmdshell 'SET'

and this should return the list of environment variables available to xp_cmdshell when it executes under that account.

Vik

No, I completely blanked on bcp. And, on initial consideration, it would work better for me.

Thanks for the help, I'll give it a go.

Vik

Can you post the code for the sproc? I've only ever seen cursors nested 2 deep as well, but I don't see any reason why you couldn't go deeper...

The...

Quentin

Try using the isnull operator, like so:

colvalue = isnull(col1, 0) + isnull(col2, 0) + isnull(col3, 0) + isnull(col4, 0)

this will return the col? values as 0 if they start out...

First off, thanks to everyone above for their advice & input.

quentinjs,

If, in effect, a computed column is treated like a regular column for purposes of indexing, why would it matter...

Try this:

select syscolumns.name from syscolumns inner join sysobjects on syscolumns.id = sysobjects.id where sysobjects.name = 'tablename_here' and syscolumns.status & 0x80 <> 0

We just solved a similar problem here -- a sproc was taking > 1 minute to delete less than a couple dozen rows from a table with about 24k rows...

I think Steve's hit it right on the money, good explanation.

Got the following script from the MS support site & have used it to good effect. Follow the instructions...

Hello tkc,

This may not be entirely relevant to your

exact situation, and I'm not too up on IIS, but here goes...

I had this same error come up a couple of...

>>>

All good points. I'm a big T-SQL fan and therefore wrote something similar to ship logs to multiple other servers all in T-SQL. In addition you have the option of...

Thanks for the reply. I'll scan through the database script & associated source code but I'm pretty sure no one has monkeyed with this setting. There are 3...