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

   ...

the way to do it is with the ALTER TABLE ALTER COLUMN command:

example:

create table test (testid int,testcol float);

exec sp_help test;

alter table test alter column testcol decimal;

exec sp_help test;

drop table test;

now...

a simple asp web page like this would work; change the connection info toyour page, put it somewhere on the web server and browse to that page:

<!DOCTYPE...

I'm betting it has to do with dynamic sql; also "Primary" should be in single, not double quotes, right?

if you add one of the many split function examples here on...

I'm confused about what you mean when you said "I go to my site, it asks me for a local user account"

Are you sure it's SQL server that is asking...

thanks for the correction Steve; i never get to play with replication, but I try to read about it here.

since this is db2 instead of sql, does that mean the  idsdemo.FFIITMAP is not databasename.tablename? so the tablename has a period in it? ie [idsdemo.FFIITMAP]

if that's true, then we'd just...

not enough info to really help yet helen.

the real table definition is much more helpful, as well has the name /definition of the table you are "merging" it with, ie

I'm going to agree with you...it's common to see bit fields keeping track of attributes, when more properly it should be one-to-many tables.

you could envision  that if you had to...

the full text catalog is not stored in the database, but actually separately on the server i believe.

as a result, you need to deploy the database, and after restoring it...

wierd...it's ok syntax wise, so I suspect is has to do with teh multi-part-name.

I'd suggest aliasing the table to fix it:

Update idsdemo.FFIITMAP

  set idsdemo.FFIITMAP.FFIHGTH = A.CFFIHGTH

From idsdemo.cubiscan  A

WHERE ltrim(rtrim(A.CFFIITMN)) =...

john i must be reading your post all wrong... for me, if i was going to present int's as hex, I'd do the following:

select convert(varbinary,7) ,'note said --> E0 (hexadecimal...

no need to cross post the same question in different forums. the Active Topics shows all new stuff.

continue and answered here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=390752

i'm sure I remember someone posting that you want to upgrade the receiver(s) of the replication prior to upgrading the publisher.  other than that I do not remember any issues.

the table idsdemo.FFIITMAP is already part of the query, so you don't want to say FROM <itself>

you want to say FROM <other table> and then add the join conditions.

I...