Maybe 3 times is a charm , let me try again 🙂

I have a server accounts table called ALLDB_syslogins_Sql2008 whereas I gather information hourly from other servers though a agent job. This particular server accounts table does not have a account description field.

CREATE TABLE [dbo].[ALLDB_syslogins_Sql2008](

[srvname] [varchar](128) NOT NULL,

[name] [varchar](128) NOT NULL,

[DATE_CREATION] [datetime] NOT NULL

) ON [PRIMARY]

srvname name DATE_CREATION

server\PRODabc_prod 2012-12-17 13:57:38.057

server\PRODtest1 2013-01-04 10:31:31.420

server\PRODtest2 2013-01-15 11:00:08.270

.....

My question is that I have created another table identical to this one and imported it externally from an excel csv file with almost the same corresponding information along with an extra field.

CREATE TABLE [dbo].[ALLDB_syslogins_Sql2008_with desc](

[srvname] [varchar](128) NOT NULL,

[name] [varchar](128) NOT NULL,

[account description] ](128) NOT NULL,

[DATE_CREATION] [datetime] NOT NULL

) ON [PRIMARY]

srvname name account description DATE_CREATION

server\PRODabc_prod play 2012-12-17 13:57:38.057

server\PRODtest1 work 2013-01-04 10:31:31.420

server\PRODtest2 home 2013-01-15 11:00:08.270

----------------------------------------------------------------------------------------

I know what i'm asking is a bit strange but since I cannot get an account description from my original table ALLDB_syslogins_Sql2008 . Therefore, whenever a new record is created in ALLDB_syslogins_Sql2008 , i need to copy it over to ALLDB_syslogins_Sql2008_with_desc and I will manually add the data in the account_description field.

So basically all I need to do is bring over all new records into this new table

ALLDB_syslogins_Sql2008_with_desc

I need a glass of water 😉