Use triggers and store the log in a second table.

CREATE TRIGGER xyz

ON updatetable

FOR UPDATE

AS

INSERT INTO logtable

SELECT * FROM inserted

inserted is a special virtual table that contains...

Use a firewall and drop all packets from any source address except those accepted.

--

Chris Hedgate @ Apptus Technologies (http://www.apptus.se)

http://www.sql.nu

In my opinion, this is not really a question of performance. Yes, performance does differ, but the real difference is that a constraint is a logical construction, whilst an index...

You would either need to set the entire declare cursor and the entire code that then uses the cursor inside the query-variable and execute it, or you would have to...

Add the following to your connection string:

Network Library=DBNETLIB;Network Address=192.168.0.100,1433;

Change the example IP-address and port to whatever your SQL Server is using. If your using SQL Server 7 change DBNETLIB to...

Andy, why should it record an error? If all goes well, as it should, the code would just go past the if-statement. If the xml-string is not valid then parsing...

quote:

---

I use the perfmon counter sqlserver:memory manager/total memory(kb) to get a accurate feel of how much SQL is using the available memory...

quote:

---

Did anyone ever figure out why Task Manager incorrectly reflects the memory utilization for SQL when AWE is enabled?

---

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/