yeah as I discovered. Its working fine now.  

Its probably the TRUSTWORTH set to ON, never seen that one before (the account already belongs to SQLAgentUserRole)!!!

Vista, its a nice desktop period.   Trying to setup wireless,etc. on a mates laptop with Vista is a nightmare (hidden BSID), maybe because its something new to learn (tricks, etc.)...

oops, sorry I didnt explain. 

create 2-3 databases, e.g. DatabaseA, DatabaseB & DatabaseC.

partition the required data into 3 tables splitting the data equally into DatabaseA, DatabaseB & DatabaseC.  Create...

I'm interested in some of the questions raised about SQL Server Compact Edition, I've been using SQL Server Express edition to process a subset of data from our main dataware...

I've looked at moving to SQL 2000 64-bit then found that you cant use the DTS tools on the 64bit server!!!!

I've heard various stories on 64-bit being faster for...

File groups are key to IO performance, having all your tables stuck in one 2.5 TeraByte file doesnt help I can tell you and trying to move tables between filegroups in...