I'm confused why you can't just use the object that does the encryption in both ASP and .NET; I know in .NET you can invoke vb6 objects, and vb6 can...

it's tough, because the relationships in a schema diagram are based on foreign keys...since you can't have a foreign key that references outside of the database you are looking at,...

how about something as simple as a customer to product relationship?

many customers might be related to one or more products, and the products might be related to more than one...

I typically use this, which puts them in the desired order, unless you have some circular dependancies where table A references table B, and eventually a chain of them point...

without specifics, we can't diagnose the problem.

since this is a general question for now, here's a general answer and things to look for:

is your application doing SELECT * FROM SOMETABLE,...

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...