You could do it in a Script Task.

You may want to examine the URL's listed below:

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591

http://sqlblog.com/blogs/davide_mauri/archive/2010/06/21/installing-sql-server-2008-r2-best-practices-analyzer-on-a-stand-alone-machine.aspx

http://blogs.msdn.com/b/psssql/archive/2010/06/20/introducing-the-sql-server-2008-r2-best-practices-analyzer-bpa.aspx

If you want to perform a LEFT OUTER JOIN on 3 Tables position the tables to the left and you will get return all three tables in the result set.

Have...

I'm sorry. I did a lot of post. But if you have a question or need someone to look it up please let me know.

Sorry about that, my keyboard has...

It doesn't really matter, how did you come to that conclusion?

If it does not matter why are there several types of JOINS?

It does matter what type of join it is...

Select * from TableA A Join TableB B on A.x = B.x

Join TableC C on B.y = C.y

Join TableD D on D.z = C.z

Don't you mean a LEFT JOIN?

SELECT *

FROM...

Sorry about the link. I was in the clipboard from a previous post.

liuwilli,

You stated "Database are exactly same in the 2 environments".

Is that singular or plural?

Do you have any other Databases on the PROD Server that you are having problems...

LEFT JOIN is correct assuming that you wanted all the tables FROM the Left side.

If you used an INNER or RIGHT JOIN then you may not get the intended result...

I believe that you want to partition on a computed column which is based on your clustered Index.

So if you create you computed column, update it and create a partition...

Is ID an Identity Column?

I prefer to list the Column Names in the INSERT Statement

INSERT INTO table_name (column1, column2, column3,...)

VALUES (value1, value2, value3,...)

OR in this case

INSERT INTO table_name...

Check out the following links:

http://www.infobarrel.com/QAUAT_creating_a_test_plan

http://www.uservices.umn.edu/pmo/docs/Test/TEMPLATE_Test_Plan.doc

http://www.information-management-architect.com/user-acceptance-testing.html

You are going to have an enormous amount of Network Traffic.

Microsoft Access is not a Client/Server Tool; It is more like File/Server.

If you do not go with ASP.NET then...

You may want to encourage implementation of Source Control in your shop if it does not already exist in a structure that makes it easier for someone to locate source...

You should give it another shot and examine the Event Logs to determine what was restarted and when.

Are you familiar with the Event Logs. If not I would encourage...