You can use SSIS Transfer Login Tasks component

oke i see

Any idea???

Yes I have

Table Script....

CREATE TABLE [dbo].[LG_002_ACCCODES](

[LOGICALREF] [int] NOT NULL,

[MODNR] [smallint] NULL,

[GRPFILTER] [image] NULL,

[VATRATE] [float] NULL,

[ACCOUNTREF] [int] NULL,

[CENTERREF] [int] NULL,

[LINEEXP] [varchar](31) NULL,

[CALCFORMULA] [varchar](251) NULL,

[INDEXCODE] [varchar](25) NULL,

[CAPIBLOCK_CREATEDBY] [smallint] NULL,

[CAPIBLOCK_CREADEDDATE] [datetime] NULL,

[CAPIBLOCK_CREATEDHOUR] [smallint] NULL,

[CAPIBLOCK_CREATEDMIN] [smallint]...

Somebody help me 🙂

I'm really looking forward to read the answer to this question too

yes its normal because if you write begin tran or not sql server engine start a transaction when you send update or insert query it if it is finish

sql engine...

Yes it is true restart engine is good solution for this...Because sql server is trying to rollback transaction

I think you can start with excel 2007 or 2010 datamining add in. Because it is very good tool to start data mining. And then you can visit

You can use reporting service Subscriptions

Maybe some policy in Reporting service and agent running account.You can change the

service accounts to administrator and test it.

Look at the sql Server Agent if it is running find your Subscription and try to run it ReportingService Database is it running succesfully.

I also set it 1024 and i didnt change too

I set Network Packet size to 12288 but i didn t change anything

I thinks some setting in client side network adapter or another setting