No you can not use csv to create multiple tabs. You'll need to use one of the options that Lowell mentioned. A csv will always open in one tab.

Access to your mail server may be restricted by ip address. It will accept mail from the workstation you are running BIDS on but not the server. Check with the...

nvarchar(MAX) is permissible for a foreign key, just not recommended.

Can you provide CREATE TABLE statements for the two tables in question?

How are you trying to change the column length, SSMS...

I can't help with your error message but I can say that nvarchar(MAX) would be a very unusual choice for a foreign key. So you key field contains more than...

My suggestion had the constants in a table.

CREATE PROCEDURE proc

AS

--Declare your parameters

DECLARE @param1 int

DECLARE @param2 char(3)

--Set you parameters by retrieving values from a table called paramsets

SET @param1 =

(

SELECT param1value

FROM paramsets

WHERE

param...

You could store your 'constants' in a table so if your requirements change you edit the data in a table rather than modifying the procedure. You could also store multiple...

Here is one example.

http://www.sqlservercentral.com/articles/transactions/69132/

I don't usually work with that much data but I think you should batch the insert to minimize the impact on the system and to prevent transaction log growth.

Archiving can be quite a complex subject. I would search this site and read the numerous articles on archiving,

Couple of thoughts....

Validate you backups. Test the networking at the new location. Make sure you have adequate power at the new location.

There are specialized powered lifts for moving servers but...

If you are using the Import and Export Wizard and it is failing I would select the option to save the package and then open the package in BIDS. Run...

Import the excel data into a table then write a query joining your primary site table and the data you imported on the SiteID field.

SELECT

*

FROM Sites S

INNER JOIN ImportedSites IS

ON...

Lots of examples out there on this site and others

http://social.technet.microsoft.com/wiki/contents/articles/15977.sql-server-batch-update.aspx

http://www.sqlservergeeks.com/blogs/AhmadOsama/personal/450/sql-server-optimizing-update-queries-for-large-data-volumes

You may want to update statistics.

See 'next steps' section.

http://msdn.microsoft.com/en-us/library/ms144267.aspx

Understood, thank you. I really appreciate the time you spend helping people here.