Process Info - Application seems odd

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Process Info - Application seems odd

Author

Topic

Martin Babb
Starting Member

11 Posts

Posted - 2004-08-02 : 23:56:25

Hi

I have just recently upgraded both the server hardware and SQL Server ( from 7.0 to 2000 )

I have been keeping a close eye on the server since the upgrade and have noticed dts packages that are run using DTSRun, appear in Process Info under Current Activity to be using DTS Wizard or DTS Designer as their application.

running this

SELECT program_name
FROM master.dbo.sysprocesses
WHERE spid = '66'

returns this

DTS Wizard

There is no problem as such I was just wondering if anyone knows why this would be the case as there is no instance of the DTS Wizard open by anyone and there are only two people with access to DTS designer on the server , maybe it is just unfortunate terminology?

Thanks

Martin

Martin Babb
Starting Member

11 Posts

Posted - 2004-08-02 : 23:57:41

Sorry I think I put this in the wrong forum.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources