I tried a few things. However, I couldn't find any direct solution yet.

Almost everything that can be done for basic date time manipulation (SQL 2008) is mentioned in the following...

I think there could be an alternative.

Let's create a table each in two databases

USE dbOne

GO

CREATE TABLE tblOne(...)

GO

USE dbTwo

GO

CREATE TABLE tblTwo(..)

GO

Lets create a SP (in any database) which accepts a single...

Glad that it worked.

You stated that you have turned off the firewall. It would be better if you add exceptions for SQL Server in your machine, with Firewall enabled.

To achieve...

Direct subtraction might work in a lot of cases.

The following information is not a direct answer, but these are a few things to be kept in mind before using...

If the configuration in SQL Server Configuration Manager is fine, can you try checking the firewall settings.