If not then you will have to do a restore of the last good full backup and then apply TL log backups if you have them (which if set to...

I always thought BOL in that article was fairly straight forward personally. However, could you post what you were told for anyone else looking for a similar explination it will...

With regards to dates 0 is 1/1/1900.

1) Yes to an extent you can subtract from 0.

2) 1250 represent the number of mon ths that have occurred since 1/1/1900.

So by...

Yes that is right. The reason is only one thread at a time can be processed per processor (except with hyperthreaded cpu's) so for each to run the CPU has...

This is the best way. I see a lot of folks do a look in sysobjects for the temp table name but if on another connection the name is in...

http://www.adeptSQL.com

http://www.apexsql.com

http://www.red-gate.com

all have tools that can compare DBs for differences and produce scripts.

Try

amount = datalength(tblname.field)

here this should help

backup database northwind

to disk='c:\n1.bak', disk='c:\n2.bak'

with init, name='test'

Glad to hear, I was just banging my head on FoxPro there.

I don't use FoxPro myself but can you post the few lines before and after this so I can see if I can figure it out? Otherwise Stored Procedure may...

Try my query in QA and see if it works. If does then it may be another foxpro limitation you hit. I would then consider wrapping logic in SP and...

You don't have any words in you error statement such as

DON'T

HAVEN'T

HASN'T

or other ' containing word do you?

And what laguage are you using to write the errors to the ODBC connection?...

Because of the way exists works with regards to each record entering the buffer it will take a long time on large datasets.

DId it say where the error was as I am working on notepad not QA right now and no test system here.

Sure first the subquery

  SELECT

   x2.master,

   x2.type t1,

   x3.type t2

  FROM

   tblX x2

  INNER JOIN

   tblX x3

  ON

   x2.master = x3.master

  WHERE

   x2.type = 'avail' and

   x3.type = 'oper'

Here I am join all master...