Sorry, I should have been more clear. The query is inserting into the TempEmail table so I can join back to the table with the conflict to see which...

Are you having difficulty with this, or just checking to see if it is possible?

The nature of CSV files is that each column is output for each row at exactly...

FYI, this seemed a simple enough solution. However, with the lack of information out there I have abandoned this method and am doing the export via SSRS. Only...

I made a few changes to make this easier to follow. It looks like it is working fine to me.

declare @fileinfo table ([FileName] varchar(10),[RowCount] int)

declare @file table ([FileName] varchar(10),[RowCount]...

Is the INSERT statement attempted, but fails with an error? If so, would you please include the error?

You may want to try eliminating the second condition and making it a catch-all ELSE.

IF EXISTS (SELECT * FROM dbo.fileinfo U INNER JOIN dbo.[File] A ON U.filename =A.filename )

BEGIN

...

SQL Server 2008 R2 allows unlimited virtualization.

You should be fine.

http://www.microsoft.com/sqlserver/2008/en/us/enterprise.aspx

Funny, I did remove it at one time but had other issues so put it back.

Removed it (along with a few others further down) and did some additional cleanup and...

It sounds like you need to run diagnostics on your new memory.

In SQL 2008 these are now referred to as "Schemas". Schemas aid in categorizing database objects and are used instead of owners to address the objects.

Owners still exist.

The proc...

Could be. But the link doesn't say that specifically so it is hard to tell. MS does silly things like that sometimes without saying anything.

http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

The database size is now listed as 10GB making the Express edition practical for more users.

Some of the older Express editions limited connections to 25 (At least that is what...

A quick method is the right-click the stored procedure and click View Dependencies. It will show you the information you are looking for.

Really, the easiest way is to right-click the database, select Taks, then click Generate SQL Scripts.

Make sure and go to the Set Scripting Options page and use Advanced to customize...

You can change the server and database using the Reporting Services Configuration Manager.

I don't believe you will have any issues with that, but cannot say for sure.

Why not configure the...