I don't know but I would love to hear as answer to this.

The prinicpal difference between running in development and running in production for a DTS package is where it runs.

In development, it typically runs on your desktop, however, in production when...

Well, I am going to assume that it is a local package (as opposed to say, a file). What is the error that it is returning?

Thanks, Adam.

What is the storage format of your DTS?

Thanks for the example Ralph. I was just mad at myself for not noticing the typo before I posted my reply...

Well assuming that it's the former, "[font="Courier New"]DBCC Sqlperf(Logspace)[/font]" is the command that you want.

duh. Its a typo, should be [font="Courier New"]@ddl[/font] on the select line.

For some reason, this does not work for me. Keeps telling me that I have to "[font="Courier New"]declare the scalar variable @ddl[/font]"

How did it work out?

Try tracing it with Profiler.

Use a stored procedure, like this:

DECLARE @Total float

SELECT @Total = Cast(COUNT(CITY) as float) FROM MR_MEMBER_1

SELECT COUNT(CITY) AS MEMBERCITY, CITY

, 100 * Cast(COUNT(CITY) as float)/@Total AS PERCENTAGE

FROM MR_MEMBER_1

GROUP...

Do you mean 90% of current space is in use in the LogFile, or do you mean that 90% of the Maximum size is in use?

What happens if you run the stored procedure in Query analyzer, instead...

Either this is an LDAP issue or you've got SET ROWCOUNT on.

Try doing SET ROWCOUNT 0 before your query.