Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)

  • RE: Copy table structure from a another one.

    Your problem is going to be with the lifespan of a temp table - it only exists during the current session.  So when you create a temporary table in an...

  • RE: Job Step Type List - missing entries

    I opened a trace, then opened the job step.  It looks like it pulls the information from the msdb..sp_enum_sqlagent_subsystems stored procedure, which looks in the registry under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent\Subsystems.  Check there...

Viewing 2 posts - 1 through 2 (of 2 total)