I've tended to use different accounts for each server. Since you rarely set them up, it works well. Store the passwords in Password Safe or something similar and then yo...

If you have multiple statements in the task, they're each separate. When you run the proc, the temp table exists, but it should go out of scope when the proc...

You could use a subquery.

Delete from a

where a.pk not in (select b.pk from b where a.xx = b.xx)

Something like that. You'd have to work out the joins you...

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', ...

)