This might be better accomplished by a DTS package instead of a stored procedure.

An ActiveX script task in DTS can instantiate a Scripting.FileSystemObject or other COM component to inspect the filesystem...

>>Do you believe a Table Valued function will outperform a temporary table used for the same basic purpose,

Unfortunately the answer is "it depends".

Depends on table size and how it is...

A single DTS package can have multiple data transformations - you just string them together with workflows (or run them in parallel).

Here's an example - I have a package that...

[Edit] ahh, nevermind, just noticed the cross-server requirement. Mental note to self, read entire post before replying.

Ahh, I assumed nesting. You could always choose to nest, by creating 1 overall procedure that creates the local temp table, then calls the others in the same way that...

Do you really need a global temp table then ?

If the purpose is just share data in a temp table between stored procedures, you only need a local temp table,...

Check constraints are applied at the Table level:

Select ctu.TABLE_NAME, cc.CHECK_CLAUSE

From INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE as ctu

Join INFORMATION_SCHEMA.CHECK_CONSTRAINTS as cc

  on (ctu.CONSTRAINT_CATALOG = cc.CONSTRAINT_CATALOG and

      ctu.CONSTRAINT_SCHEMA  = cc.CONSTRAINT_SCHEMA  and

      ctu.CONSTRAINT_NAME    = cc.CONSTRAINT_NAME)

You could left join for sure.

But what if the datasets are large ? Why pull a large result set to count it, when all you need to do is find...

For unused space, SQL Server does not auto-shrink and shuffle data onto other pages when you delete rows, so whatever space was allocated stays alocated when you delete. However, before...

>>Maybe you have an explanation about the behavior of this timestamp in this cases...

I have no idea. If you go back to your original post, we didn't get DDL for the...

It will depend greatly on the meaning of "last 1000" and how indexes are built on the column or columns that together define "last 1000".

Also depends somewhat on SqlServer version....

use tempdb

if exists ( select * from information_schema.tables where table_name = '##YourTableName')

  Drop Table ##YourTableName

>>I tried putting a print statement with the break to state the table name that the error occured on but it reads as a syntax error.

Print doesn't handle in-line string...

If Exists (Select * From TableA

           Where SomeColumn Not In

           (

             Select SameColumn

             From TableB

           )

)

  Return False

Else

  Return True

End

Use BREAK to get out of the current WHILE loop.