so why can't you then append the file bcp outputs to the existing file...?

Well, we do similar to abi... trouble is when its 10 100GB files it still hurts! We are testing Qpress to compress them - pretty impressive speed on that!

The...

just buy a tool... :hehe:

Hi

Resolved:

Anyone that was interested...

The smaller table had 1 extra record. The distribution of this was effectively the first 9 records where the status codes we were looking for in...

Hi GM

Forwarded Records are 0.

Thanks - looks promising.

Cheers

Rich

Hi thanks for the reply... but could you expand on that?

Not sure what a lakh is, but certainly back on 2000 if you joined to a linked server it had a habit of bringing the whole table back and doing...

Kyle Neier (6/2/2008)

---

Have you verified that the compatibility mode of all the databases in question is the same?

Not particularly with functions, but I've had weird stuff like this pop up...

Sure, thanks for the interest:

create function Report_HourlyTrace( @from datetime, @to datetime)

returns table

as

return

(

select *

from dbaf.dbo.Main_PerformanceTraceResultTableHourly p

where qtime between @from and @to

and sp_name in

(

select

top 10 percent

sp_name

from dbaf.dbo.Main_PerformanceTraceResultTableHourly p2

where p2.qtime...

Ah well, I thought that as Steve Jones has only been 'working with SQL Server through all versions up to 2000. ' I assumed that meant the site was...

with/without db and schema prefixes both on create and call makes no change - still has the incorrect syntax error.

Cade Roux (5/19/2008)

---

I love this:

I've learned that when business people tell me that getting to market is more important than running their business well, I'm only there to postpone the...

Do you not just mark them for recompile?

Only if they were activeactiveactive, and as they can't share data disks you still need to figure out how to maintain data integrity across them.