Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Alter Table Refresh!!!

  
   Database Help (Home) -> Programming RSS
Next:  Request for opinions on the INCLUDE() use in an i..  
Author Message
Vai2000

External


Since: Jan 13, 2004
Posts: 11



(Msg. 1) Posted: Mon Oct 30, 2006 9:45 am
Post subject: Alter Table Refresh!!!
Archived from groups: microsoft>public>sqlserver>programming (more info?)
Hi All, I have a SQL2k server and a bunch of apps (.net and native c++)
using tables in it. I recently altered a table and added a column to it.
Bizarre thing is on my Query analyzer if I do sp_help <tablename> I can see
the new column, but my .net and native apps don't see this new column

Any clue?

TIA

 >> Stay informed about: Alter Table Refresh!!! 
Back to top
Login to vote
Scott Morris

External


Since: Aug 28, 2003
Posts: 86



(Msg. 2) Posted: Mon Oct 30, 2006 9:52 am
Post subject: Re: Alter Table Refresh!!! [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You have a response to the same question you posted last week. Why don't
you follow up with that thread, rather than starting a new one.

 >> Stay informed about: Alter Table Refresh!!! 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Alter Table - Adding column to large table - Hi, I have to add column to quite large table (10 mil rows... 2.5 gig). When I try adding it thru the management studio.... i get this error. - Unable to modify table. Timeout expired. The timeout period elapsed prior to completion of the operation or....

Alter Table - I have a table in SQL 2000 database: CREATE TABLE [dbo].[Term] ( [TermID] [int] IDENTITY (1, 1) NOT NULL , [Term] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [RowDeleted] [bit] NULL ) ON [PRIMARY] GO ALTER TABLE [dbo].[Term] ADD ..

alter table column - Hi good morning. My table column data has only Y and N value. I wanted to change the datatype from nvarchar(255) to char(1) and got the following error alter table ubicell.dbo.ubicell_id_lookup_20080103 alter column registered char(1) Msg 8152, Leve...

error on ALTER table - Hi, I'm doing the following : ALTER TABLE [Publication] ADD CreatedBy INT (4) ADD DateCreated SMALLDATETIME DEFAULT GetDate() GO But I get the following error : Incorrect syntax near the keyword 'ADD' Can't figure out what's wrong ? Can you help ...

ALTER TABLE using a Variable - Hi, I have a table ('Table A') with a trigger. I want to add a column to another table ('Table B') when a record is INSERTED into 'Table A'. I want the name of the new column in 'Table B' to be a value from the record inserted INTO 'Table A. I am..
   Database Help (Home) -> Programming All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]