sp_tableoption N'MyTable', 'text in row', 'ON'

Agree post the error?

hbkdba, Kalen Delaney's book "Inside Microsoft SQL Server 2000", chapter 8 may help a bit.

Lastly, although not ask for, you can rearrange your query to

insert...

Maybe of relevance.

See http://www.sqldts.com/?246

I guess it will be a cursor, if one look at the stored procedure sp_MSforeachtable internals. Thanks for the reference!

Interesting idea.

Article at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=38812 where Itzik Ben-Gan discuss idea of using array sets for performance gains.

Basically, use a varbinary(?) as an array to store 4 digit numbers. Still needs a...

In principal yes, if the quotes are handled correctly

Select count(*) 

from sysobjects 

where name like 's%'

go

Exec ('Select count(*) 

from sysobjects 

where name like...

-- List of all user tables, one at a time

Set NoCount On

Declare @id Int

Select @id=Min(Id) 

From SysObjects 

Where OBJECTPROPERTY(ID,'IsUserTable')=1

While @id Is Not Null

Begin

-- Do some more...

No flames please but you are on the same box same database

Did happens once, many moons ago many servers and many dbs after lots of coffee, etc.

Question, you have mentioned you are using asp pages, can you post the code how you get SQL to execute the sp. What I am getting at is any middle...

Did you run

 DBCC UPDATEUSAGE (DB_NAME(),'TableName') WITH COUNT_ROWS

EM is getting it from SysIndexes.

-- sp_MStablespace

SELECT @rows = convert(int, rowcnt)

FROM dbo.sysindexes

WHERE indid <...

If possible, can you do a select from the same table with the same WHERE clause.

Maybe the parameter values passed in different to what you expect, example funny characters.

If a...

Agree will also update statistics.

Plan B run a DBCC UPDATEUSAGE.

Can you post the QA code

How about osql?

Type OSQL /?

Bonus of virtual money

Frank, it seems this name change thing is taking you to new heights

Have to reconsider myself.

They realize they are not paying...