Server Help

[i88gerbils]

I ran this query in both SQL Enterprise Manager and MSDE Query:

Code: Show/Hide DELETE FROM XXXXXXXRequiredProperties WHERE MessageClass LIKE '%Activity%' FolderID = '{8507cbf7-e9bd-11d1-aec5-00a024fdf47f}'

Basically parsing 360k+ records. However, ODBC timed out on SQL Enterprise Manager yet the query ran just fine in MSDE Query.

I guess this is a lesson. If you want to DELETE lots of records (not the whole table), then you'll probably want to avoid using SQL Enterprise Manager or an ODBC's SQL Server module.
_________________
Oldbie Server Help