yes you can use standard edition for mirroring i have used it for a couple of years without any issues.

Also when you are using mirroring, you do not need...

One way to acheive this would be to create a reference table with the distinct ALPA values and the desired ranking of each value, then to order your table you...

it's not entirely clear what you want;

if it is a query with a where clasue the format is

select * from table

...

is this running on SQL server?

I thought primavera was an Oracle product

all you need to do is make the connection string to the destination dynamic like you did for the source connection string

if the databases are on the same server, you could just reference the table directly in the other database by using the three-part naming convention

database.owner.table

It seems like a case of 'parameter sniffing'

http://blogs.msdn.com/queryoptteam/archive/2006/03/31/565991.aspx

One option is to use the recompile hint (well it is on 2005 i am not too sure about 2008)

Kingston Dhasian (3/22/2010)

WHEREDAY( DATEADD( DAY, 1, dt ) ) != 1

I don't think performance should be a concern as almost all the rows ( hopefully ) are returned. In such...

you can use

SELECT dt FROM Dt

WHERE (MONTH(dt) IN (1,3,5,7,8,10,12) AND DAY(dt) <31 )

OR (MONTH(dt) IN (4,6,9,11) AND DAY(dt) <30 )

OR (MONTH(dt) = 2 AND DAY(dt) < 28)

ORDER BY dt

this...

The 'easiest' way to copy databases from one server to another is to do a backup and restore.

You could do this via a SSIS package or instead use the...

you can do an update based upon an inner join

from your code provided it would look something like this;

UPDATE Leas

SET Leas.amount = Cmrecc.amount

FROM ...

Are there any other errors in the log?

Also check the system logs for errors?

from a quick look you need to normalise the second table.

en.wikipedia.org/wiki/Database_normalization

For example rather than having.

Product Group | Product Codes | Product Codes1 | Product Codes2 |Product Codes3 .........etc...

I can't see any errors in that log, can you highlight the error?

not sure of average took me about 1/2 hour last time to install sql. it usualy takes as long again to install the SPs.

However why are you only going...