Never seen sql server dropping databases on his own.

Sure there isn't an (backup)application/job/user doing this?

Perhaps you can set up profiler to listen for sp_detachdb commands

You mean the scripts are stored on the server and are called using xp_cmdshell? Or that they are send across the network as sql-statements?

1)Advantages using stored procedures:

Reduces roundtrips (network latency)

Managebility,resusability...

SELECT convert(datetime,'20050910') as myDate

select convert(varchar(20),convert(datetime,'20050910'),103) as myVarCharDate

Should do it.

select avg(DurationSummed.duration)

from

(select sum(duration) duration

from cutlog group by datepart(dy,date))

) as DurationSummed

?

make an union?

select columnA as MyColumn

union all

select columnB as MyColumn

union all

select columnC as MyColumn

In order to update on a linked server there should be a primary key on the table to function as recordidentifier.

Delimiting all identifiers is an excellent approach.

I think by lazyness and readability we decided to use a naming convention prohibiting the use of problem object names ( like spaces in...

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