Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.com
Chuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net.. .
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com
|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:

> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck
|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh
sql

Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.comChuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net...
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:

> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh

Anyone have sp_oacreate and SQL2005 issues?

We use a few in house built COM objects that we call from stored procedures
quite often during the day. They are called from linked servers - so all
COM stuff is run on a dedicated box. Both servers are running SQL 2005 SP2.
The server that does all the COM object (sp_oacreate) work will lockup on a
daily basis and we have to restart sql service to fix. Also, we see SPIDs
on the COM box stuck in Rollback status and have to restart SQL to fix. Has
anyone seen any of these issues while migrating to SQL 2005?
Thanks,
Chuck Lathrope
www.sqlwebpedia.comChuck,
This is what you mean: - http://support.microsoft.com/kb/937277/en-us
which talks about sp_OAMethod not sp_OACreate.
Chris
"Chuck Lathrope" <computerguy_chuck@.fixmehotmail.com> wrote in message
news:120gcwua7do0w$.106toy5xoolnq.dlg@.40tude.net...
> We use a few in house built COM objects that we call from stored
> procedures
> quite often during the day. They are called from linked servers - so all
> COM stuff is run on a dedicated box. Both servers are running SQL 2005
> SP2.
> The server that does all the COM object (sp_oacreate) work will lockup on
> a
> daily basis and we have to restart sql service to fix. Also, we see SPIDs
> on the COM box stuck in Rollback status and have to restart SQL to fix.
> Has
> anyone seen any of these issues while migrating to SQL 2005?
> Thanks,
> Chuck Lathrope
> www.sqlwebpedia.com|||On Thu, 19 Jul 2007 13:02:00 -0600, Chris Wood wrote:
> http://support.microsoft.com/kb/937277/en-us
That looks very promising! I have been searching net on sp_oacreate and
never saw this. Thanks. I will ask my PSS engineer if I can get the hotfix.
-Chuck|||Hi Chuck,
Since you are on SP2, i doubt this hotfix will help you, as the SP2
build is 3042, and the above issue is fixed in 2232
HTH,
Dinesh

Anyone got a chart of datatype conversions?

I'm looking for a chart that shows the VB6 > .NET > SQL 2005 datatypes.
E.g.
VB6 .NET SQL2005
integer int16 smallint
long int32 int
byte byte tinyint
But I want a whole chart with all datatypes. Anyone know of a URL with a
chart?Do a search in google. There are several sites with VB6 and VB.NET type
comparisons.
Regarding SQL 2005 types there are no direct mapping for all the available
types. What you may have to look for is ADO.NET type comparisons. Checkout
the MSDN site for a full list of all ADO.NET type mappings.
--
Anith|||I did a google search and didn't much that was helpful with SQL 2005.
That's why I opened this thread. I appreciate msdn suggestion but hopefully
someone will still have a URL they like for datatype conversions.
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:%2385m9c4UGHA.1160@.TK2MSFTNGP09.phx.gbl...
> Do a search in google. There are several sites with VB6 and VB.NET type
> comparisons.
> Regarding SQL 2005 types there are no direct mapping for all the available
> types. What you may have to look for is ADO.NET type comparisons. Checkout
> the MSDN site for a full list of all ADO.NET type mappings.
> --
> Anith
>

Any unique datetime's in SQL2005?

Once upon a time, some version of SQLServer was supposed to do
timestamps as datetimes, so you could have a guaranteed unique token
that decoded to a real date/time. I believe this was supposed to be
the ANSI standard for SQL as well.
Has this yet been delivered in SQL2005?
(I think not, but am not certain, and would like to have it for
something I'm doing right now! I should have SQL2005 loaded here in a
few days, but thanks in advance for any answer to this. btw, I don't
see the SQL2005 documentation yet online at MSDN.microsoft.com)
J.No.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"jxstern" <jxstern@.nowhere.xyz> wrote in message
news:quqpo15ejq4biu6cgsg2nkiedr92dinok1@.
4ax.com...
> Once upon a time, some version of SQLServer was supposed to do
> timestamps as datetimes, so you could have a guaranteed unique token
> that decoded to a real date/time. I believe this was supposed to be
> the ANSI standard for SQL as well.
> Has this yet been delivered in SQL2005?
> (I think not, but am not certain, and would like to have it for
> something I'm doing right now! I should have SQL2005 loaded here in a
> few days, but thanks in advance for any answer to this. btw, I don't
> see the SQL2005 documentation yet online at MSDN.microsoft.com)
> J.
>

Any unique datetime's in SQL2005?

Once upon a time, some version of SQLServer was supposed to do
timestamps as datetimes, so you could have a guaranteed unique token
that decoded to a real date/time. I believe this was supposed to be
the ANSI standard for SQL as well.
Has this yet been delivered in SQL2005?
(I think not, but am not certain, and would like to have it for
something I'm doing right now! I should have SQL2005 loaded here in a
few days, but thanks in advance for any answer to this. btw, I don't
see the SQL2005 documentation yet online at MSDN.microsoft.com)
J.No. :(
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"jxstern" <jxstern@.nowhere.xyz> wrote in message
news:quqpo15ejq4biu6cgsg2nkiedr92dinok1@.4ax.com...
> Once upon a time, some version of SQLServer was supposed to do
> timestamps as datetimes, so you could have a guaranteed unique token
> that decoded to a real date/time. I believe this was supposed to be
> the ANSI standard for SQL as well.
> Has this yet been delivered in SQL2005?
> (I think not, but am not certain, and would like to have it for
> something I'm doing right now! I should have SQL2005 loaded here in a
> few days, but thanks in advance for any answer to this. btw, I don't
> see the SQL2005 documentation yet online at MSDN.microsoft.com)
> J.
>

Any unique datetime's in SQL2005?

Once upon a time, some version of SQLServer was supposed to do
timestamps as datetimes, so you could have a guaranteed unique token
that decoded to a real date/time. I believe this was supposed to be
the ANSI standard for SQL as well.
Has this yet been delivered in SQL2005?
(I think not, but am not certain, and would like to have it for
something I'm doing right now! I should have SQL2005 loaded here in a
few days, but thanks in advance for any answer to this. btw, I don't
see the SQL2005 documentation yet online at MSDN.microsoft.com)
J.
No.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
"jxstern" <jxstern@.nowhere.xyz> wrote in message
news:quqpo15ejq4biu6cgsg2nkiedr92dinok1@.4ax.com...
> Once upon a time, some version of SQLServer was supposed to do
> timestamps as datetimes, so you could have a guaranteed unique token
> that decoded to a real date/time. I believe this was supposed to be
> the ANSI standard for SQL as well.
> Has this yet been delivered in SQL2005?
> (I think not, but am not certain, and would like to have it for
> something I'm doing right now! I should have SQL2005 loaded here in a
> few days, but thanks in advance for any answer to this. btw, I don't
> see the SQL2005 documentation yet online at MSDN.microsoft.com)
> J.
>

Any standalone version of SQL2005 Express?

Hello All,
Just want to know is there any stand alone version of the SQL 2005 Express?
As I would need to run a database on a laptop, but the policy is set to not
allowing any installations... Anyway I can unzip/unpack it and run it off
just like that? Thank you!
THanks & Best Regards,
aNewbie
Many Microsoft applications use a local installation of the Native Client
which you'll find is similar to SQL Express. For example, the Small
Business Contact Manager, the ISA firewall on Small Business Server,
Sharepoint. As far as free goes, it is free to use the SQL Express on your
own machine, but there are limits on connections to the database, limits on
the amount of RAM and number of processors accessible so it is not a fully
functions SERVER but as a server, it runs on your local machine in a way
similar to a server. You can create databases, attach databases, detach
databases, query databases and use much of the functionality that is
available on a full version (Standard or Enterprise) but there will be
limitaions. Don't quote me on this but I believe that the free version of
SQL Express comes with a GUI as well so you won't need to run queries through
DOS. As to why it won't install on your system, there may be other software
there that needs to be uninstalled first, or it is also possible that the
setup of your server is such that it is being denied permission to system
resources.
My suggestion would be to uninstall what you have (Add Remove programs),
redownload (http://msdn2.microsoft.com/en-us/express/aa718378.aspx), and then
reinstall. When you install, accept the defaults on the installation - it
would help if you read the documentation from the link as well.
Regards,
Jamie
"aNewbie" wrote:

> Hello All,
> Just want to know is there any stand alone version of the SQL 2005 Express?
> As I would need to run a database on a laptop, but the policy is set to not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie
|||I guess your laptop belogs to your company or something similar so it's not
allowed installing additional stuff on it?
If so, you can not install any version of SQL Server 2005 on your laptop
because there is no such a version to unzip or something as far as I know.
The installer of SQL Server has to run and install the necessary apps in its
packs included .Net Framework if it's not installed yet.
Ekrem ?nsoy
"aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005
> Express?
> As I would need to run a database on a laptop, but the policy is set to
> not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie
|||Thanks thejamie and Ekrem ?nsoy,
And yes, is the company policy that got into way, sorry I didn't state that
clearly earlier...
I know the Setup Wizard will help me to config the nesseary settings and
..Net framework. So that I will not need to do it manual, and I can benefit
the nice GUI too. But sometime when just want to do things quickly on a
laptop, and don't want to go through all the paper work and requests to the
IT dep, a "stand alone" version would be very welcome (and of course, with
the GUI too).
It would be very nice if there is a "stand alone" version... especially when
people just want to do some quick work without installing it. Anyway,...
Thanks again from both of you. Atleast I know there is no standalone SQL
Express... And I would need to move on and find another brand that it has
one...
Thanks & Best Regards,
aNewbie
"Ekrem ?nsoy" wrote:

> I guess your laptop belogs to your company or something similar so it's not
> allowed installing additional stuff on it?
> If so, you can not install any version of SQL Server 2005 on your laptop
> because there is no such a version to unzip or something as far as I know.
> The installer of SQL Server has to run and install the necessary apps in its
> packs included .Net Framework if it's not installed yet.
> --
> Ekrem ?nsoy
>
> "aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
> news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
>

Any standalone version of SQL2005 Express?

Hello All,
Just want to know is there any stand alone version of the SQL 2005 Express?
As I would need to run a database on a laptop, but the policy is set to not
allowing any installations... Anyway I can unzip/unpack it and run it off
just like that? Thank you!
THanks & Best Regards,
aNewbie Many Microsoft applications use a local installation of the Native Client
which you'll find is similar to SQL Express. For example, the Small
Business Contact Manager, the ISA firewall on Small Business Server,
Sharepoint. As far as free goes, it is free to use the SQL Express on your
own machine, but there are limits on connections to the database, limits on
the amount of RAM and number of processors accessible so it is not a fully
functions SERVER but as a server, it runs on your local machine in a way
similar to a server. You can create databases, attach databases, detach
databases, query databases and use much of the functionality that is
available on a full version (Standard or Enterprise) but there will be
limitaions. Don't quote me on this but I believe that the free version of
SQL Express comes with a GUI as well so you won't need to run queries throug
h
DOS. As to why it won't install on your system, there may be other softwar
e
there that needs to be uninstalled first, or it is also possible that the
setup of your server is such that it is being denied permission to system
resources.
My suggestion would be to uninstall what you have (Add Remove programs),
redownload (http://msdn2.microsoft.com/en-us/express/aa718378.aspx), and the
n
reinstall. When you install, accept the defaults on the installation - it
would help if you read the documentation from the link as well.
--
Regards,
Jamie
"aNewbie" wrote:

> Hello All,
> Just want to know is there any stand alone version of the SQL 2005 Express
?
> As I would need to run a database on a laptop, but the policy is set to no
t
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie |||I guess your laptop belogs to your company or something similar so it's not
allowed installing additional stuff on it?
If so, you can not install any version of SQL Server 2005 on your laptop
because there is no such a version to unzip or something as far as I know.
The installer of SQL Server has to run and install the necessary apps in its
packs included .Net Framework if it's not installed yet.
Ekrem ?nsoy
"aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005
> Express?
> As I would need to run a database on a laptop, but the policy is set to
> not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie |||Thanks thejamie and Ekrem ?nsoy,
And yes, is the company policy that got into way, sorry I didn't state that
clearly earlier...
I know the Setup Wizard will help me to config the nesseary settings and
.Net framework. So that I will not need to do it manual, and I can benefit
the nice GUI too. But sometime when just want to do things quickly on a
laptop, and don't want to go through all the paper work and requests to the
IT dep, a "stand alone" version would be very welcome (and of course, with
the GUI too).
It would be very nice if there is a "stand alone" version... especially when
people just want to do some quick work without installing it. Anyway,...
Thanks again from both of you. Atleast I know there is no standalone SQL
Express... And I would need to move on and find another brand that it has
one...
Thanks & Best Regards,
aNewbie
"Ekrem ?nsoy" wrote:

> I guess your laptop belogs to your company or something similar so it's no
t
> allowed installing additional stuff on it?
> If so, you can not install any version of SQL Server 2005 on your laptop
> because there is no such a version to unzip or something as far as I know.
> The installer of SQL Server has to run and install the necessary apps in i
ts
> packs included .Net Framework if it's not installed yet.
> --
> Ekrem ?nsoy
>
> "aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
> news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
>

Any standalone version of SQL2005 Express?

Hello All,
Just want to know is there any stand alone version of the SQL 2005 Express?
As I would need to run a database on a laptop, but the policy is set to not
allowing any installations... Anyway I can unzip/unpack it and run it off
just like that? Thank you!
THanks & Best Regards,
aNewbie :)Many Microsoft applications use a local installation of the Native Client
which you'll find is similar to SQL Express. For example, the Small
Business Contact Manager, the ISA firewall on Small Business Server,
Sharepoint. As far as free goes, it is free to use the SQL Express on your
own machine, but there are limits on connections to the database, limits on
the amount of RAM and number of processors accessible so it is not a fully
functions SERVER but as a server, it runs on your local machine in a way
similar to a server. You can create databases, attach databases, detach
databases, query databases and use much of the functionality that is
available on a full version (Standard or Enterprise) but there will be
limitaions. Don't quote me on this but I believe that the free version of
SQL Express comes with a GUI as well so you won't need to run queries through
DOS. As to why it won't install on your system, there may be other software
there that needs to be uninstalled first, or it is also possible that the
setup of your server is such that it is being denied permission to system
resources.
My suggestion would be to uninstall what you have (Add Remove programs),
redownload (http://msdn2.microsoft.com/en-us/express/aa718378.aspx), and then
reinstall. When you install, accept the defaults on the installation - it
would help if you read the documentation from the link as well.
--
Regards,
Jamie
"aNewbie" wrote:
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005 Express?
> As I would need to run a database on a laptop, but the policy is set to not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie :)|||I guess your laptop belogs to your company or something similar so it's not
allowed installing additional stuff on it?
If so, you can not install any version of SQL Server 2005 on your laptop
because there is no such a version to unzip or something as far as I know.
The installer of SQL Server has to run and install the necessary apps in its
packs included .Net Framework if it's not installed yet.
--
Ekrem Ã?nsoy
"aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> Hello All,
> Just want to know is there any stand alone version of the SQL 2005
> Express?
> As I would need to run a database on a laptop, but the policy is set to
> not
> allowing any installations... Anyway I can unzip/unpack it and run it off
> just like that? Thank you!
>
> THanks & Best Regards,
> aNewbie :)|||Thanks thejamie and Ekrem Ã?nsoy,
And yes, is the company policy that got into way, sorry I didn't state that
clearly earlier...
I know the Setup Wizard will help me to config the nesseary settings and
.Net framework. So that I will not need to do it manual, and I can benefit
the nice GUI too. But sometime when just want to do things quickly on a
laptop, and don't want to go through all the paper work and requests to the
IT dep, a "stand alone" version would be very welcome (and of course, with
the GUI too).
It would be very nice if there is a "stand alone" version... especially when
people just want to do some quick work without installing it. Anyway,...
Thanks again from both of you. Atleast I know there is no standalone SQL
Express... And I would need to move on and find another brand that it has
one...
Thanks & Best Regards,
aNewbie
"Ekrem Ã?nsoy" wrote:
> I guess your laptop belogs to your company or something similar so it's not
> allowed installing additional stuff on it?
> If so, you can not install any version of SQL Server 2005 on your laptop
> because there is no such a version to unzip or something as far as I know.
> The installer of SQL Server has to run and install the necessary apps in its
> packs included .Net Framework if it's not installed yet.
> --
> Ekrem Ã?nsoy
>
> "aNewbie" <aNewbie@.discussions.microsoft.com> wrote in message
> news:B58013A7-E3FA-49CE-BC8F-86010355EED4@.microsoft.com...
> > Hello All,
> >
> > Just want to know is there any stand alone version of the SQL 2005
> > Express?
> > As I would need to run a database on a laptop, but the policy is set to
> > not
> > allowing any installations... Anyway I can unzip/unpack it and run it off
> > just like that? Thank you!
> >
> >
> > THanks & Best Regards,
> > aNewbie :)
>

Any better monitoring for locks and blocking in SQL2005?

Are the facilities for monitoring locks and blocking in SQL2005 better than
2000?
I found that in SQL2000 Enterprise Manager by the time you waited for
"current activity" to refresh, the information could have been and gone.
I'd be interested to hear if you've been using it sucessfully to do this
sort of thing.
If you want something similar to Current Activity, Activity
Monitor in Management Studio is an improvement over the
Current Activity node in Enterprise Manager. Opens in a
separate window, you have a few different view to chose
from, you can set a refresh interval.
2005 also has server level reports such as Blocking
Transactions and Top Transactions by Locks.
But just like Current Activity, you are seeing a snapshot
and you need to refresh. You have more options in 2000 to
understand the blocking, locking if you use queries to
monitor activity and it's somewhat the same in 2005.
However, there are improvements to the monitoring and
details you can get related to locking, blocking. In 2005,
you have a lot more details exposed on the waits. You can
also set up a blocked process threshold and use this with
the Blocked Process Report event class in Profiler, SQL
trace. You can also get detailed historical information
related to locking and blocking from the DMV
Sys.dm_db_index_operational_stats.
The following article has a lot of information on you can
use to monitor blocking, locking issues in 2005:
Troubleshooting Performance Problems in SQL Server 2005
http://www.microsoft.com/technet/pro.../tsprfprb.mspx
-Sue
On Thu, 19 Jan 2006 04:50:02 -0800, "James"
<James@.discussions.microsoft.com> wrote:

>Are the facilities for monitoring locks and blocking in SQL2005 better than
>2000?
>I found that in SQL2000 Enterprise Manager by the time you waited for
>"current activity" to refresh, the information could have been and gone.
>I'd be interested to hear if you've been using it sucessfully to do this
>sort of thing.
|||Night and day, across the board. SQL Server 2000 exposed very limited
information to be able to monitor. SQL Server 2005 has layer after layer
after layer of diagnostics. From DBCC commans through DMVs/DMFs, there
aren't many areas of the engine you can't get at.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"James" <James@.discussions.microsoft.com> wrote in message
news:98B66E56-8895-4040-BA63-056144C882C6@.microsoft.com...
> Are the facilities for monitoring locks and blocking in SQL2005 better
> than
> 2000?
> I found that in SQL2000 Enterprise Manager by the time you waited for
> "current activity" to refresh, the information could have been and gone.
> I'd be interested to hear if you've been using it sucessfully to do this
> sort of thing.