Maybe. I've seen malware that uses SQL injection. It's not the first place I'd look, but it is...

Which line's the error on?

Please post SQL 2000-related questions in the SQL 2000 forums. If you post in the 2005 forums, you're very likely to get 2005-specific solutions.

Can you explain more what you're trying...

You'll be surprised. It's a web app and you're using inline SQL. You are...

Please post the code involved, the table...

SQL only knows what machine initiated the database connection. In the case of a web application (asp, asp.net, php), that's the web server. If you want to trace who's connecting...

Jack Corbett (1/18/2009)

---

Who knows how good it will be? I have a basic outline of the "series" it is based on a Profiler presentation I did at the Orlando...

What do those few stored procs that fail do that the ones that work don't? Access the system tables?

Call Microsoft's customer support. Especially since this is a business-critical system

nashreen.mosaheb (1/19/2009)

---

But in SQL Profiler 2000, you could filter your query by the client's hostname.. I can't find how to do that with the SQL Server 2005 version(am using this...

Couple times, but...

Client process won't give you the machine. It gives you the processid on that machine. For the machine, use the hostname column.

kiransuram19 (1/18/2009)

---

The ldf file size is 9.5GB and mdf file allocated size is 4.5 GB( We can assume that data is 15.6 MB in mdf) But when I backup the...

Ah. I was considering writing on server-side...

Use something like this as the basis for the view.

SELECT *

FROM

(SELECT MAX(OrderNO) as MaxOrder, itemID, UOM FROM SomeTable GROUP BY ItemID, UOM) Qualifying

INNER JOIN SomeTable...