well looks like this might benefit from a where clause.

The structure of the table is described in the system tables (sysobjects, syscolumns, sysindexes etc.) you can roll your own tsql to extract the information into "create table..." statements, or...

By doing what you did, basically.

you should use: sp_addserver 'SQLEXPRESS', 'local'

(drop the first one you added .. without the 'local')

then bounce the service and see what happens.

Reserved Space is part of the table allocation. This is unused space cause by fragmentation (i.e page splits) and extra growth allocation.

writing NULLs won't do it... you'd have to fill up each column with different data and even that won't insure that bits and pieces of the original data won't remain...

Create your tables using real table names, not tempdb names. I would create them in the current DB or another staging DB specic to this purpose.

If you must use tempdb,...

I would suggest altering the text column on your new 2008 server to be nvarchar(max). Text will no longer be supported beyond version 10 anyway so you may as well...

That error is fairly explanatory... the user does not have permission to use the bulk insert statement. Are you sure the use is the one attempting to execute the statement?...

You could set up replication from the 2008 server to the 2005 server. Once everything is in sync, cut over the 2005 server. That should be able to be done...

Its just the genesis of an idea... to generate a table having columns startRowNum and endRowNum based on modulo-350.

It may be better to create a temp table and use identity()...

actually, you are probably right... my brain was working in a different direction. However I think you could use the modulo 350 idea to generate a virtual table of...

given that RowNumber is an interger, why couldn't you simply do it this way:

select RowNumber/350 as ID, avg(close) as average, max(close) as maximum

from your_table

where RowNumber between 350 and 100000

group...

The question(s) you are asking cannot be answered properly without looking at the system design or an overall document describing the functional requirements of the system.

One can't even be sure...

The 'default' database for a linked server connection would depend upon the connection credentials for the linked server.