Use sp_executesql

declare @sql nvarchar(1000)

declare @result int

set @sql = N'select @c = count(*) from ' + @TableName

exec sp_executesql @sql, N'@c int output', @c = @result output

print @result

>>My fear is that at every 5 minute interval the entire data portion will be re-sorted along with the index.

"Re-sorting" may be the outward appearance of what happens, but it...

Yes, that is something that is long overdue and a feature I am also looking forward to (and getting familiar with by test porting some existing procs to Yukon).

However, I...

Select Cast(filesize_kb As float) / 1000000.0

To get 3 decimal places, cast result to a numeric:

Select Cast(  (Cast(filesize_kb As float) / 1000000.0) As Numeric(12,3) )

Add SET NOCOUNT ON to the start of the proc.

Probably the PRINT buffer not flushing before the batch aborts.

Using RaisError with a severity of zero acts like a PRINT, but flushes immediately (or so I read on the MS newsgroups).

RAISERROR('Test...

The business rules for how you arrive at those numbers are necessary for anyone to provide a solution that isn't a time-wasting guessing game.

It's due to the error severity

A high enough severity will cause the entire batch to abort so that error trapping code does not execute. Referencing a non-existent column is...

You're not telling it to use a bigint.

This: (((@Octet1 * 256 * 256 * 256

What datatype does that result in if @Octet1 is an int ? Answer: int

You need to...

What is the result when you run this SQL ?

exec sp_dbcmptlevel 'YourDatabaseNameGoesHere'

Update YourTable

Set Accumulated = dtAccumulated.Accumulated

From YourTable As a

Inner Join

(

  Select o1.OrderID, Sum(o2.ProductQuantity) As Accumulated

  From YourTable as o1,

   YourTable As o2

  Where o2.OrderID <= o1.OrderID

  Group By o1.OrderID

) dtAccumulated

On a.OrderID...

Try running this search against the microsoft.public.sqlserver.* newsgroup hierarchy ...

http://www.google.ca/groups?num=100&hl=en&lr=&q=alter+table+log+group%3Amicrosoft.public.sqlserver.*

Well, congrats on getting it working, but the final solution is not optimal and will seriously degrade performance as your table gets larger.

As suggested above, you should keep your tables...

What I often end up doing is:

Update PermanentTable

Set Col1 = s.Col1

    ...

    ColN = s.ColN

From PermanentTable As p

Inner Join StagingTable As s

  ON (p.KeyCol = stage.KeyCol)

Where Checksum(p.Col1, p.Col2 ... p.ColN)...

When you alter a column containing existing data, Sql Server has to run a transactionally safe Update to convert the existing data, therefore has to log every updated row. Also,...