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

here is a script to run on your instances to find out what port it is using.

CREATE TABLE #GetPort

(

token varchar(100),

value varchar(20))

go

DECLARE @inst varchar(200)

DECLARE @inst1 varchar(100)

--Determine registry path and key

IF(charindex('\',@@servername) >...

Thanks Remi; that got me over the hump; here's an example of a pretty complex table that my function returns the ddl as an example:

it still needs some work, because...

just wanted to flesh the background of the question out for some less knowledgable readers:

you can "pin"  a table, or mark it so that it's contents are held in memory,...

by default i think the datatype selected for a datetime conversion is smalldatetime, and it really needs to be datetime.

change datatype on column 4 to datetime, and also any other...

i think that you can simply tell them that it is the industry standard and also against best practices to modify system tables.

That should be enough, in my opinion...some...

another thing could be the definition of the import table, or a convert function:

a varchar field, if no size is given defaults to 30 characters.

select convert(varchar,'This value is actually 44...