Is unicode characters the same as high ascii characters?

this is the only way i could figure out how to do it so far, was with a function that loops thru...

with a copy/paste of your code, i get this error:

Server: Msg 1540, Level 16, State 1, Line 1

Cannot sort a row of size 8101, which is greater than the allowable...

creating the tables and migrating the data?

if exists(select name from db1.dbo.sysobjects where name='mastertable1') drop table db1.dbo.mastertable1

select * into db1.dbo.mastertable1 from db2.dbo.mastertable1

just moving new data?

insert into db1.dbo.mastertable1

select * from db2.dbo.mastertable1

left...

if it's just one or two tables, then you'd simply use something like

SELECT *

INTO MYTABLENAME

FROM OTHERDATABASE.DBO.MYTABLENAME

[WHERE <condition to exclude unwanted data>].

if...

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