On SQL2005 you can get this from [font="Courier New"]select * from sys.dm_exec_connections[/font] in the client_net_address column assuming that their net_transport is TCP.

On Sql2000 it is a challenge. It appears...

Steve Jones - Editor (3/22/2008)

---

Any application that allows the user to type in data is vulnerable. Only if the application allowed users to click buttons or make pre-set selections would...

Wheter it is DDL or DML is irrelevant. It is a transacted operation and thus has to be recoverable. Physically it is modifying every row in the table,...

Marios Philippopoulos (3/22/2008)

---

Connections are made using the login's current security context.

So in the following query, the login running the query is the same account in whose context the connection is...

I don't know, Todd. My recollection is that your step #3 (drop the old column) still has the same problem.

There is not much that you can do to...

OK, I believe that I understand now.

Frank.M.Perkins (3/22/2008)

---

The system is a medical application. For a given visit, there may be multiple services and each service has to be billed separately....

Generally, you cannot make changes to the database within a scalar user-defined function:

http://msdn2.microsoft.com/en-us/library/ms191320(SQL.90).aspx

Are they in different domains? and if so what is the trust relationship?

Explain, please.

Kevin Durham (3/21/2008)

---

a. Does storing the view and using it in this way have any perfomance benefits over executing a string that includes the query that is in the view...

Happy to help.

Procs are the industry best practice.

You cannot guarantee order without an ORDER BY (or some other cursor method).

Yes, absolutely. and with 3-tier and n-tier apps also.