November 15, 2017 at 4:17 am
Hello all,
I have in my organization 2 servers with SQL Server 2000 (and an upgrade is not an option).
Does there is a tool like SP_WhoIsActive for SQL Server 2000?
Thanks in advance!
November 15, 2017 at 5:17 am
I realise that you said that upgrading is not an option, but may I ask why? Personally, I would consider SQL Server 2000 to be a significant risk to the business; it wouldn't have had a security patch in 4 and a half years, unless you have SA (and I would be surprised if you still had that agreement going).
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
November 15, 2017 at 5:28 am
Hi Thom,
My business use "vantive" which is very old ERP software (also EOL before few years).
3 years ago they decided to move to Siebel (another erp software) with SQL Server 2014 🙂
meanwhile this project delayed due to software issues and for now i'm stuck with sql server 2000 🙁
Does anyone familiar with a sp_whoisactive (or similar tool) that work with SQL Server 2000?
November 15, 2017 at 4:06 pm
89netanel - Wednesday, November 15, 2017 5:28 AMHi Thom,
My business use "vantive" which is very old ERP software (also EOL before few years).
3 years ago they decided to move to Siebel (another erp software) with SQL Server 2014 🙂
meanwhile this project delayed due to software issues and for now i'm stuck with sql server 2000 🙁Does anyone familiar with a sp_whoisactive (or similar tool) that work with SQL Server 2000?
One of the problems would be much of that information is just not exposed in SQL Server 2000. But people used to write their own versions of sp_who3 or other types of things. I had a few sp_who3s myself. A couple of them you may want to check
sp_who3
SQL 2000 compatible (& above) lightweight alternative to sp_whoisactive
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply