Pre-installation:

1. New IP for your new instance;

2. New Storage for the new instance;

3. New Resource group on your cluster if it is for an active/active cluster;

Installation:

1. Install SQL Server on...

As far as I know, you need to create views in order to grant permission on a column-level.

http://support.microsoft.com/?id=811889

Based on your description, you should use MERGE replication. You can limit the user accessing your web server to have insert permission only. You just set the permission to these...

As far as I know, using the built-in replication utility is OK.

How about the script below?

SELECT * FROM syscolumns WHERE id=OBJECT_ID('Orders') WHERE name LIKE '%ID%'

You need to replace the table name, Orders, by yours.

I cannot see any code in red. Could you use italics or bold?

When you mentioned that your view is called more than once, could you include this part of script?

Could you post your script?

To draw attention by more people, you may post this question to SQL 2005 column since SSIS belongs there?

When your job is hanging, you may run the following scripts to check whether or not there is any task running against your server.

sp_who2 active

SELECT * FROM master..sysprocesses

Pay special attention...

Here is my cent.

How many times did you run your job in QA? Only the first time when you run your job in QA may give you correct information. After...

Now is the KEY WORD IN VB. If you simply use DOS command, you may try DATE. If you use either OSQL or ISQL, you may try to use GETDATE()...

If you would like to constain how much an instance uses, you can set in the properties of instances. If you would like to look into what processes are consuming...

My guess is, your objects have different names after altering them from 'table' to 'schema.table' . You may have to grant permissions again.

You may try the following command to see what components are on your server.

%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\ARPWrapper.exe /remove

GRANT db_ddladmin, db_datareader, and db_datawriter. If you would like the user has permission to execute stored procedure, you may grant EXECUTE permission to it. If you would like the user...