I'm not 100% sure, but it seems that it grows when it needs the space. In other words, you can't set it to be at xx% left. If you always...

Also, are you running your server in 6.5 mode or 2000 mode?

WMI is probably the best way. If you cannot get access, can you setup PerfMon to get this information and log it?

I've never had a QA DBA, but I suspect it would be someone to apply the T-SQL (DDL and DML ) changes to QA and then production. Examine the code,...

I'd guess some type of backup grabbing the file. Any delay would cause SQL to fail as it's very intolerant of delays.

Don't know any free ones. If you have Office Pro, Visio will work.

Paint I guess

select a.orderid

from ordermaster a

inner join orderdetails b

on a.pk_orderid = b.fk_orderid

where b.orderamount (select sum( c.orderamount)

...

You can store perfmon output to a file and look at that.

What are you trying to accomplish?

You could automate some type of restore for the logs based on timing, but I'd tend to do it manually. Be sure you are naming logs with some type of...

Use the old syntax

Select TableA.Col1, TableB.ColA

FROM TableA, Table B

WHERE TableA.ID = 1

AND TableB.ID = 2

What about custom VB/VB.NET/C# apps? Does the binary need to be compiled specially for 64-bit? On a 64-bit workstation or is there another version of these products?

Is there anything else in the Windows error log?

Have you tried a different path/filename to be sure there's not something wrong with that file?

Haven't decoded it as it's a bit long

If you know that is the weak section, I'd break apart the query from the union...

Maybe move the ActiveX task to after the export and "reformat" the sheets?

They work well as a PK, but that doesn't mean that you shouldn't be looking for a natural key in the data. Dont' make them a clustered index and be...