Check Books On Line for the same, Even u will get some more important things about Identity Columns...

Check all the Field names used in select qry, No. of Fields and Field Names should be same when using UNION in sql.

Even any datetime/month columns are not in the table.... How anybody can give such kind of report (monthly count), without having any datetime column....

Also the table design is not very...

Jst fire checkpoint, and check whether there is any open transaction by using dbcc opentran, if there is no open transaction found, means there is no trxn is running, so...

The only thing u r missing is the join condition...

SELECT

S1.STYLE,

S1. COLOR,

S1.replication_date,

S1.SEASON,

S1.ON_ORD_1,

S1.ON_ORD_2,

S1.ON_ORD_3,

S1.ON_ORD_4,

S1.ON_ORD_5,

S1.ON_ORD_6,

S1.ON_ORD_7,

S1.ON_ORD_8,

S1.ON_ORD_9,

S1.ON_HND_1,

S1.ON_HND_2,

S1.ON_HND_3,

S1.ON_HND_4,

S1.N_HND_5,

S1.ON_HND_6,

S1.ON_HND_7,

S1.ON_HND_8,

S1.ON_HND_9,

S2.STYLE,

S2....

U can use checkpoint, it will commit the data. There is no point of rollback. Are u getting any issues....??? Pls post here....

Check whether local user (used in linked server) has access to the table...???

It seems to be correct. The only thing u need to do is to change variable @sd-aux to something like @sd_aux. Thats it.

First check whether the database is truly suspect or not.... Can we repair it...??? What errors u r getting when u run DBCC CheckDB???

Then only we can come to know...

As per the requirement, you can create a job on Server A, that will call d Backup-proc on Server B.

like (exec servernameA.databaseA.dbo.backup_proc)...

U wanna say the output will look like...

Field_1 (FIN report) Field_2 (Email List) Field_3(Cc List)

============ ============== ==============

RPT-0001 ...

U dont need to make any changes in the stored proc. Use set nocount on while executing the proc... like...

set nocount on

exec dbo.ap_adm_JobActivity_EmailAlert

set nocount off

Y do u need to pass so much parameters in stored proc??? U can use like...

CREATE Procedure dbo.usp_addaccounts

@accountwachtwoord varchar(25),

@accountactive bit,

@accountchangeonfirstlogon bit,

@rolnaam varchar(25),

--@rolid int, --Remove from here...

@contactpersoonemail varchar(50),

--@contactpersoonid int --Remove...

But I would recommend u to create another table with foreign key, n that will hold lastupdated column. Reason behind is, to make sure that it wont ask to make...

Wht abt the value of City, State??? Wht city/state u want in ur record...???