here's an example to get teh text/definition of the triggers:

set nocount on

 SELECT [text] + CHAR(13) FROM syscomments WHERE id IN(SELECT id FROM sysobjects WHERE xtype='TR')

typical results:

CREATE TRIGGER updatedby...

you'll need to update each table spearately, but most likely in a transaction, so it is update both or nothing;

SET XACT_ABORT ON --any error rollsback the whole thing...IF a transaction...

Pretty sure this has to do with having a database without an owner - this can happen if you recently restored/attached database, or did you maybe drop a user?

Have...

yeah having to roll thru the tables later after the IP's been captured woudl be a pain in the audit.

Since you are going to use HOST_NAME instead, you obviously are already...

do you mean using DNS/nslookup to convert an ipaddress like 66.94.234.13 to http://www.yahoo.com?

i saved this snippet for SQl 2000, but it works in 2005;

this creates both the  DROP and ADD statements for a db's foreign keys

looking at it, i don't know why...

OK based on your post,i think this query has 10 left outer joins altogether;

I think I saw Jeff Moden mention that left outer joins require a table scan, right?

that would...

I tested your code with that one sample row you posted, and I get a problem with the field for INVOICE_NUMBER, because the data is 41 chars, but the definition...

this is similar to a different thread i was in, where we calculated the difference between the defined length,and the max used space for a row;

take a look here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=385732#bm386585

even...

if you are in as a builtin\Administrator, you can still use the sp_password, you simply leave oldpassword as null.

an admin does not need to know the old password,  so you'd...

From what I've learned, RAID 5 is slower in comparsion to RAID 1 because the data is distributed redundantly accros the stripes to allow for recovery ,so it can potentially...

this is a really good source...there's a brief paragraph on the one filegroup per disk and such:

http://www.sql-server-performance.com/articles/per/optimize_filegroup_performance_p2.aspx

ouch; i had a similar issue where a controller card went bad and was writing bad data for hours before the db was too corrupted to use, but I had...

I think the article complete skips over how the other 90% benefit after the 10% paid for the research and development of the software.

Take the Internet for example...it wasn't targeted...

here a snippet i saved for looping thru access tables from an application:

Set AccessCN = New ADODB.Connection

    AccessCN.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Clients\someAccessDb.mdb;Persist Security Info=False"

    AccessCN.Open

    Set rs = New ADODB.Recordset

   ...