Unfortunately, even with Active/Active (meaning if the primary fails the secondary will kick in with no intervention (hopefully)) there will be downtime while the system fails over...

Other points of failure...

EdK,

I think that IF you want to compare records to the current system date/time you probably will NEVER get a record. 

WHY?  Glad you asked...  The system date/time will...

I have never used opendatasource for Excel (always used Linked Server).  Have you made sure that the number of octets is correct?  i.e.

ExcelFile..Sheet$ ???  may have nothing to do with...

As far as I know the only gotchas potentially will be orphaned users (see BOL for sp_change_users_login AUTO_FIX).  Code will remain the same.

1.  SQL 2K

2.  I would develop the application in such a way that it reads a file that would contain the SQLServer ServerName.  I assume you are using TrustedConnection.  This...

I have not had the opp. to set-up the same type of environment that you have however, I can say that there is only one way to find out unfortunately...

Try researching:

AVG(CAST(pts AS NUMERIC(10, 3)))

You may have to also RECAST the AVG but this should help you along

I would attempt to research how to do that with the reporting tool that you are going to spoonfeed this data to.  Most if not ALL reporting tools from Excel,...

MS SQL does not store the data physically for views currently.  HOWEVER, ANY TIME the data source is updated the view is as well.

Unfortunately, Time is not a separate entity yet in SQL.  IF you use: '1900-01-01' + SPACE(1) + CONVERT(VARCHAR(10), GETDATE(), 108) you may be able to then use DATEDIFF with MINUTES/SECONDS...

How 'bout

WHERE CAST(col AS DATETIME) BETWEEN CAST('1.7.2004' AS DATETIME) AND CAST('31.7.2004' AS DATETIME)

Granted the execution plan may look awful but this should work..

-- Friday

DECLARE @Date DATETIME

SET     @Date = GETDATE()

SELECT CONVERT(VARCHAR(10), DATEADD(DAY, 6 - DATEPART(WEEKDAY, @Date), @Date), 101)

Thread on http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=137742

Thread on http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=137742

Thread on http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=137742