Please don't cross post. Many of us read all the forums. 2005-related questions should please only be posted in the 2005 forums to avoid confusion.

No replies to this thread please....

Have you considered disabling the sa login?

The latest cumulative update (CU 8) is build 9.00.3257

Ref: http://www.sqlservercentral.com/articles/Administration/2960/

Selects or just data modifications? The latter, consider a trigger. For the former, you'll probably have to use profiler.

Have you considered profiler or a serverside trace? If you don't mind your error log growing significantly, you could also set the option to audit successful logins. (found under server...

I saved you the trouble.

http://sqlinthewild.co.za/index.php/2008/08/12/views-or-functions/

riix (8/12/2008)

---

Now you really feel running a view that returns zillions of huge rows into a stored procedure that then just selects a few from that lot (and then only...

Grant Fritchey (8/12/2008)

---

riix, try this, execute a query involving a JOIN to a view, a single-statement UDF and a multi-statement UDF where each returns a couple of hundred rows....

Indeed. I have,...

The estimated and...

pino_daddy (8/12/2008)

---

Don't think teh UPPER has anything to do with it.

If I comment out the joing:

LEFT OUTER JOIN SW_ORD_LIST_EXT OLE ON (UPPER(BH.ORDER_NO) = UPPER(OLE.ORDER_NO) AND BDTL.LINE_NO = OLE.LINE_NO)

The entire query...

Can you post the execution plans of the query with the...

In SQL 2000, you can't save the graphical plan. An acceptable alternative is to run the query with SET SHOWPLAN_ALL ON, run to grid, select the entire grid and paste...

Depends how often the database in question is used. If it's used once a month, probably not, if it's used...

riix (8/12/2008)

---

regarding comment:

"view vs stored proc....you still need to wrap the view up in a stored proc in order use dynamic selection criteria."

wrong - use a table-valued function. Much tidier...