The columns "days" and "ADG" both are calculated columns.

The "days" is DATEDIFF(day, [prew.month], [month])

The "ADG" is ([weight]-[prew.weight])/DATEDIFF(day, [prew.month], [month])

The columns "days" and "ADG" both are calculated columns.

The "days" is DATEDIFF(day, [prew.month],[month])

The "ADG" is ([weight]-[prew.weight])/DATEDIFF(day, [prew.month],[month])

If you set database in a single_user mode WITH ROLLBACK IMMEDIATE, please make sure your own single_user connection doesn't keep the database in use, which will interrupt any restores. This...

Just go to the Cluster Administrator and do "Move Group".

Exactly.

If you require SQL Server 2005 for existing solutions, you can still acquire additional licenses by taking advantage of the SQL Server 2008 "downgrade rights." The downgrade rights enable...

It doesn't matter how it looks like in a table, but it is important how it looks like when you retrieve a data. So, you can convert it into different...

What is a problem?

You can do it with GUI or with a script.

With GUI:

In Object Explorer, connect to an instance of the SQL Server 2005 Database Engine and then expand...

Ok, here is full info for SS2005 (how to get the latest pack, what is inside, how to apply it, etc.):

http://support.microsoft.com/kb/913089/

and here is for SS2000:

http://support.microsoft.com/kb/290211/

Is it for SS2000, SS2005 or SS2008?

It is weird.

I created a table with your table definition and was able to run your insert statement from the SSMS AND a job without any error messages. So, it...

"Hall of Fame"'s answer is 100% correct.

You can take advantage of log shipping using Standard Edition, only the differnece is you don't have wizard to play with.

The following links for your information:

http://www.sql-server-performance.com/sql_server_log_shipping.asp

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship2.mspx

Is it SSIS job?

We passed through the same requirement several years ago.

We created step-by-step instructions for every "How to..." procedure, so each process is very well documented now.

The brief description of this instruction...

You don't need a separate job for logins mapping.

I believe you have a scheduled job for you nightly restore.

So, just add one more last step to this job to map...