The Convertion of char data type to a datetime type resulted in an out-of-range datetime value.

-> results in a date before 1753

Look up CONVERT for an extra format parameter.

This article should help you on the way:

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

Sql server performance: 80% application+design,20% hardware

Hardware performance benefits: memory (the more the merrier-> less slow IO activity needed),IO subsystem, cpu (as this...

it is possible for windows 2003 enterprise

Windows Server 2003 Enterprise Edition supports 32 GB of physical RAM. Windows Server 2003 Datacenter Edition supports 64 GB of physical RAM by using...

not sure, but I believe Gold = non beta

 What is temporal upward compatibility

Making that a future version can read the information off an older version?

X = null is always Unknown

Compare to NULL with X IS NULL

I'm not sure what {business_idx=$''STERILIZES''} does.

The query looks fine if there are indexes on businessid, ZIPID.

What does exec tdbExecuteReturnPageL @sql, 3, 20 ?

if the sql servers are based on windows 2003 servers, the errors come forth since windows 2003/xp security was added to microsoft transaction coordinator.

See:

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

Microsoft Access is quite easy to make query/reports with if you have/can setup linked tables (using readonly accounts).

You could match the size as closely to your datausage, so all the data still fits. (1500 MB)

you should have an END for every BEGIN

Use the ALTER DATABASE command (see the BOL)

& MODIFY FILE

Then you can set the "original size" of a file & rerun DBCC SHRINKDATABASE

Is there any policy set to prohibit account to be active in the weekends(no logon,firewall settings..)

found an article about the error:

http://www.examnotes.net/archive79-2002-8-55082.html

We're planning to go with option 1.

Application roles have to be set every connection.