Please don't cross post.

Discussed here: http://www.sqlservercentral.com/Forums/Topic541955-146-1.aspx

You'd have to use firewalls/routers to handle this at a network level. I'm not sure that SQL Server can do anything here. hostname/IP can be easily spoofed.

Can you explain what you are trying to do or what your scenario is?

This seems like an interview or test question. Please show some effort to work on the problem...

Good explanation. OLEDB is newer and superceeds ODBC. You should aim to use OLEDB connections where possible. I believe there's an OLEDB provider that encapsulates all ODBC functionality.

SP2 had changes to maintenance plans, and I believe removed the need for SSIS to be installed on the server. However both the client and the server need to be...

I believe the Microsoft touted that in some early marketing for SQL 7. I've have to go research the exact wordings, but I had a lot of friends asking me...

I don't believe you can store this in variables with osql.

Powershell can do something like this if you install it on your servers.

Make this a CTE and then use a "where amt > 0" in the outer query that selects from the CTE?

First you need to provide more data that would show how you get the test2 data as well as the results you are looking for.

Second, this seems like homework or...

Jeff is right. You cannot insert into scalars. you can reassign variables (as in my first post), but INSERT is only for Table(like) structures.

That's what I'd do. Or you can try "Execute AS", not sure if that will work in this context, but it's interesting.

Are you sure you want to move all data? Replication, while a small load on the LIVESERVER, is the least amount of data moving.

there are creative ways to do things....

You must have differnt data or something else different. I have never even seen or heard of a bug returning different data because of different processor counts.

You should report this...

I am part owner in End to End Training, in Orlando, but good training. We do have a custom mentoring course if you want it.

Are you looking to admin or...

Dice and Monster are very popular with recruiters, who list most of the jobs. Some private individuals on Monster. not sure if JustSQLserverJobs.com is still out there or used.