Yes, use the column name instead of the *

Which indexes?

Please don't cross post.

This is answered here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=334004

#temp tables are not necessarily memory resident either. They both can go to disk.

These are inserts the same as any other table. No order is every guarenteed. You do not know when things are inserted, unless you are timestamping, and then you only...

I agree with Nigel. Old backups, or the T-log.

Also, do you drop the tables before doing the transfer? If so, you might be stuck.

Are these end users?

I'd avoid giving this to end users. Reporting Services, with the Report Builder, is supposed to address a lot of these concerns.

If you guve the user a form and have them enter the location (or browse) from VB, you can open and access the package and it's objects from VB. Save...

Not sure about the technical specs, but it shouldn't use a lot more power or heat to you. It might be more heat, but I'd be surprised if you noticed.

Server...

Please show us your work and what you are having issues with. This does indeed sound like homework.

To other posters, please don't post answers to people's homework. This is a...

I'd do it your way strictly for security. This way they're just adding "data".

Usually you'd do the metadata in CustomFieldTypes. Maybe an ID, a data type, a tablename or owner...

Not this?

insert into ....

values (@partno, '00', ...

)

_ is a wildcard as well.

select * from ..sysusers. See if it's there

Nigel,

Is this SQL Server Standard or Enterprise? If it's standard, you won't get the memory higher than it is. If it's not, then you need more memory. The cache hit...