Please send more detail.

I can say please check or compare with temp space and memory there will be a diffrence .

Hi if there case one. when coma is exactly after two character .

declare @t table(c varchar(100))

insert @t values ('AA,BB,CC'),('DD,EE,FF'),('GG,HH,II')

select

col1 = SUBSTRING(c,1,2),

col2 = SUBSTRING(c,4,2),

col3 = SUBSTRING(c,7,2)

from

@t

-------2

if there is no rule...

I do agree on the point in case of if linked server is also SQL server .

But in that case u should have same set of user name and password...

One security concern .

When we connect any database using linked server .

All operation no data base will be operated by one user account( the account used for creating linked...

Hi.

you can see error history of your subscription in "dbo.sysjobhistory ". As each subscription is a sql job.

http://msdn.microsoft.com/en-us/library/ms174997

kool

INSERT INTO DEATHTABLE (ISNID)

SELECT d.ISNID FROM VOTERID v

LEFT JOIN DEATHTABLE d

ON d.ISNID=v.ISNID

WHERE v.ALIVE='NO'

and s.ISNID is null

Please check that u r having enough memory(Physical) at server.

see below links

http://blog.sqlauthority.com/2009/03/20/sql-server-awe-address-windowing-extensions-explained-in-simple-words/

http://www.modhul.com/2007/11/08/using-address-windowing-extensions-awe-with-sql-server/

Send mail does not have that function . so hack is only option..

Then you can try

1 run package on all domain.

2 not sure will work but can try using comman name and password

Hi ,

Follow following steps it will help u .

Use "Foreach Loop Container" to get your username/password and paths to variables

...

Hi Write like ---

INSERT INTO DEATHTABLE (ISNID)

SELECT ISNID FROM

VOTERID WHERE ALIVE='NO'

AND ISNID NOT IN (SELECT ISNID FROM DEATHTABLE)