I tried to look at any network drives via xp_

I would generally write this as

CASE WHEN @Cln_Num='ALL' THEN 1

           WHEN (Cln_Num = @Cln_Num) THEN 1

           WHEN @Cln_Num = 999  THEN 999 ELSE 0 END = 1

in case the cln_num...

Have you tried this with a client number = 1 and using the 'ALL' parameter?

I am also confused.. what is the difference between 'ALL' and 999 supposed to be?  Can...

Unforntunately the system table map in the 2K res kit does not apply to version 7. 

I got it wrong too

However, I don't agree that a question that few people manage to get correct is automatically a 'bad' question...

Scope_Identity is a better idea even in a simple example like this. @@identity could be made to work, but a problem could arise if you added a trigger to the first...

Your use of scope_identity() is correct.

Your IF statements are syntactically wrong.  You need to compare @@error to something.  I assume you want to check if the error is non zero...

try

INSERT INTO USED_DISK

 (col1,col2...)

EXEC dbo.sp_Foo

Try sp_delete_database_backuphistory 'database name' which will delete the backup history for that database.  It may be faster than working with dates, but it will get rid of all history, so...

Re: Checking the transaction log for when tranactions got committed.... Hm perhaps with a third party tool like ApexSQL log...

MS Excel has a set of  get external data screens.  So does Visual Studio.NET.  What 3rd part tools have you looked at so we don't suggest one you've rejected?

sp_delete_backuphistory will take a while to trim the fat if there is a lot to do.  If you run this every day (I just add it to the end of...

Shot in the dark...  Was this SQL Server recently starting up? SQL Server performs an automatic recovery at startup to write committed transactions into the database. This automatic recovery records...

You don't want to restore system tables from a standard install to an enterprise install.   For example MSDB standard edition doesn't contain log shipping tables found in Enterprise edition.  Once you upgrade take...

Perhaps changing the temp tables to tables variables would help as well since declaring table variables is not considered DML and my guess is therefore no implied GO statement.

By the...