Seems to be the SQL Edition issue, can you try the same binaries which you did earlier. That time it will succeed.

Round Returns a numeric value, rounded to the specified length or precision.

....whom you are searching for?

Think Import to a table then from there you can join those and get the required result...........

Follow the following steps,

1. Stop all user activity in the database

2. Switch to the SIMPLE recovery model (breaking the log backup chain and removing the requirement...

Anything that is NOT about SQL! ...Shold not be here!!!!!

Any job which dropped and recreated tables?

select * from sys.sysprocesses where dbid=""

kill spid

kill all spids with drop database option at last.

for ex ,

KILL 66

KILL 68

KILL 77

KILL 89

Drop database <DBNAME>

GO

select whole thing at a time and execute

🙂

Did you tried by adding host entry?

Summary Log looks fine,

oops..........Found the log on First page

can you please upload log file from

C:\Program Files (x86)\Microsoft SQL Server\110\Setup Bootstrap\Log\20120326_054901\SystemConfigurationCheck_Report.htm

Seems need to uninstall and install once again... Did you tried..?

As per the below link it was an issue with name getting updated...as part of workaround he tried out with...

seems issue with 32bit architecture...

log says ,

OS architecture: x64

Process architecture: ...

Just check which view and what is your expected values from your query ...and in that view or objects which you are joining has required data 🙂

If we have standalone instances on same the box...then ..it might be confusing right?