Tnx for answering all.

On posting the SP: it's basically a 'simple' select with 4 parameters. However, the select is on a view, built up from 3 other views, which each...

I am still curious why a file package made with the Import/Export wizard cannot be debugged in VS2003...

Nope, they're the same. As are the 2 tables, including collation order.

As an add-on: source is SQL2K, destination SQL2005. I really hope that's not a problem!

Tnx for answreing, but:

Where is the object dbo.sysobjects? A unqualified select, or even a qualified select on this objects gives me a resultset, but I can't see it anywhere in...

Solved it, but I find its weird.

I just made 2b ExecuteSQL tasks and seperated the DROP and CREATE table statements. Nothing with double apostrophe. It runs as intended and a...

Final script:

SELECT DB_NAME() AS DB

, 'File' =

CASE

WHEN groupid = 0 THEN 'Log'

ELSE 'Data'

END

, SUM(CAST(size/128.0 as DECIMAL(10,2))) AS Size_in_MB

, SUM(CAST(FILEPROPERTY(name, 'SpaceUsed')/128.0 AS DECIMAL(10,2))) AS...

Tnx a lot Adrian, this is what I was looking for.:w00t:

Except, that I need to distinguish between data and log files. But I think I can get that done. Working...

Rows tracking makes me check ALL tables, this piece of code does the job.

I am finding out how it works, except for the counting of TXT, ntxt and such.

Tnx for...

Tnx for the heads-up, Grant. I still am not sure if this counter is significant in PerfMon; I think not.

Tnx for answering all.

I am amazed the size I set will be 'remembered'. I would think it must be stored somewhere...

Tnx for answering.

Evil, I know what a clustered index is, my question was about Unique index(clustered) vs Primary key.

Paul,

The 1 NULL value I had not thought about. Pragmatically however, I...

Tnx for answering all.

I still am curious about the name being accepted on creation but rejected on changing.

Lot of typo's in the script, annoying.

Tnx for your insights, Steve.

Right....never would've thought of that!

Tnx.