Russell, this was a normal database. I was logged in as a user who only had priveleges in the public role, not dbo. The results shown were from tempdb logged...

Russell, I tried your test with a user in the public role only and here is the result from

select * from INFORMATION_SCHEMA.TABLES:

tempdb dbo #a__________________________________________________________________________________________________________________000000000034 BASE TABLE

I think Antares is close with the idea that it's tied to connection. However, it is still more complex than that since one spid/connection can create more than one temp table...

For me at least, this is one more reason to add to why I'm not ready to make the jump to RS. I've too many DTS packages that already generate...

mpinnow is correct. Eliminating the use of cursors will impact performance significantly. As such, I've used a variation of a script I found on this site to implement a "cusror-less"...

John, if you have the Windows Resource Kit then try using rcmd along with xp_cmdshell. Please note that the machine in which the vbs script resides MUST have Remote Command...

Let me re-iterate. Have you restarted the messenger service?

Journeyman, try restarting the messenger service. We have ancountered similar problems: Net send works fine for awhile then users ( and not necessarily all of them ) stop getting notifications....

Karen, is your SQL Server configured to use SQL Authentication or Mixed Mode? If it is Mixed Mode, then what account are you executing xp_cmdshell from? If it is not...

Karen, we take Phil's solution one step further: we've created a vbs script, below, that we then exeute using xp_cmdshell.

Dim fso

 Set fso = CreateObject("Scripting.FileSystemObject")

Dim oConn

    set oConn = CreateObject("ADODB.Connection")

Dim...

I actually found a not so bad work-around for this. I'm executing the query through iSql running on xp_cmdshell. Plus I don't need to worry about creating the linked server....

Now THAT's cumbersome.

Now sp_help '<table name>' is cumbersome.

My favorite method is:

select name from syscolumns where object_name(id) = '<table name>'

dab

With something like ER-Win or Visio you could create a simple model of the queries.

DAB