you keep dancing around the issue i think; does the foreign key in table two already exist? i think not. does the data exist in another table and you are...

it would help if you could show the schema of the tables in question; then you'd get a solid answer from one of the readers here.

In theory, you simply add...

your right; i could see how making any assumption like this could come back and haunt you forever;

I've been similarly nailed in assuming that a blank city could be...

i think you'd need to create a job on sql server that would scan the linked server table every x minutes, and perform the new record addition when any changes...

aww come on guys; don't let the 5% of exceptions prevent you from doing the other 95% of the work.

it'd be some work gathering the data, but  a simple google...

a web page is stateless; that is the code is executed on the web server, and the results are returned to the browser. the code is executed in a milliseconds,...

could part of the problem be that the delphi application you are using is binding table objects to grids within the delphi application?

we had that exact issue here for a...

you could also try the server name for all machines;

constr = "Provider=SQLOLEDB.1;Password=1234;User ID=dave;Initial Catalog=mydata;Data Source=SERVERNAME;"

that should work in all situations, because your WINS server on the network will translate the...

I had all three versions running on my dev machine; SQL 7 as the default instance, and then named instances of 2000 and 2005;

i was running a december version of...

an identity column is used to get a unique value for the row; in your case, you are looking for something that does not uniquely identify the row/field.

i think it...

INSERT INTO CumulativeTable (field1, field2, extrafield)

SELECT field1, field2, extrafield from sometable

or SELECT field1, field2, null

or

INSERT INTO CumulativeTable (field1, field2, extrafield)

SELECT field1, field2

the count of fields to insert must be...

i think you can get everything you might want straight from master:

select  db_name(dbid),name, filename from master.dbo.sysaltfiles order by db_name(dbid)

I believe that SQL Server Standard edition, or Enterprise for that matter, will only install on the server versions of Windows 2000 / 2003.  when you install any version of...

I agree with Jo; the kind of application data should be encrypted.

there's a nice collection of sample encryption techniques here on SSC:

http://www.sqlservercentral.com/scripts/contributions/610.asp

changing the USER_LICENSES column from '5' to ' °oçD‘à'...

I'm not really sure you would need to do this in production, but here is a cursor example that does what you ask.

prior to doing this, you'd need to create...