Don't use IN, use the JOIN

IN is not SARGable, it is a sequence of ORs,

http://www.ianywhere.com/developer/product_manuals/sqlanywhere/0902/en/html/dbugen9/00000463.htm

DATEADD(day, DATEDIFF(day, 0, GETDATE()), 0) keeps the date only converison numeric

Try it over a dummy table of 10000 rows etc... quicker

Remove the @event_description_keyword = N'lock' parameter.

1. It's not needed, only one 1205 error

2. It's a pattern match, that is LIKE not "=" so it would have to be '%lock%', and...

Probably bugs in the sp_OA not releasing resources.

The same can happen in other xps such as xp_sendmail.

For example, prior to hotfix (922, 923 or 913 for SP3a?), xp_sendmail coudl hang...

Decimal consists of 2 parts: precision and scale.

You have specified a precision of 17 and scale of 0 (by default) or no decimal places (1234566890123467=

Now, if you used decimal (19, 9)...

Why don't you look at your other thread where you have some answers?

And just stick to one post maybe?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=4&messageid=214965

I wouldn't because it is only this utility, not the full tool set.

Actually, most clients have this (or similar) as part of MDAC. Go to "Data Sources (ODBC)", goto create a...

We all say "local group" to mean the server though, not domain group... easily done

I'm sure this goes back to multiple domains in a tree in AD.

You set up a local domain group and put other domain groups in this, and grant the local...

NT4 and SQL 7? Wow. I assumed SQL 2000 and Win2000 at least.

Simply new OS and new SQL versions could fix this, but it's not simple to do...

Enterprise has better IO algorithms with read-ahead. On some benchmarking on a troubelsome app I had a while ago, I found that Enterprise was more resilient to loads and was...

fail over your cluster and reboot the first node?

You can't assign sqlagent to separate processors from sqlservr without using 3rd party, very techncial utilites (such as from sysinternals)

All you can do is play with "affinity mask" to limit...

Following on from happycat59, for example, SP3a introduced new options such as (R-click on a server in EM, properties) "Enable the error reporting feature" that will only be seen in EM...

If you only need to free up space and are happy to go back to the last FULL backup, then set the database to "Simple" recovery model rather than scheduling...