Hi,

Now the error is as follows

Error: 18483 : could not connect to server(server name) because distributor_admin is not defined as remote login at the server.

from

Killer

Dear Deni,

I used to the below to create a linked server or remote server

exec sp_addserver 'ipaddress' or computername

EXEC sp_addremotelogin 'ipaddress or computername', 'sa', 'sa'

GO

EXEC sp_remoteoption 'ipaddress or computername', 'sa', 'sa',...

sql server could not configure database as distributor for database( i  am making distrubutor on my local database only)

error 14114 (null) is not configured as distributor.

i solved the error and...

Hi Aayush,

See this

http://support.microsoft.com/default.aspx?scid=kb;en-us;323630&sd=tech

from

Killer

Thailand

Yes ,

I know this will not be supported by microsoft.But till it is there we should use it .

from

Killer

Hi,

Ichecked everything.I have remote server ( subscriber) and mapped logins.

but still i am getting the same error.

from

Killer

Hi Rudy,

What does this means

This sp will be 'removed' sometime in the future ...'

from

Killer

Thanx

Nashi for ur help.

from

Killer

Hi XP,

This may help u select serverproperty('productlevel')

from

killer

Hi Sufian,

Try out this

USE master

go

EXEC sp_dboption 'model','trunc. log on chkpt.',true

go

USE model

go

CHECKPOINT

go

hope this help u

from

Killer

:w00t

Thanx for ur precious help?

I know what i need and  this is what i needed.

I dont want  u to work for me?

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

top sql cache -->...

Thanx for ur precious help?

I know what i need and  this is what i needed.

I dont want  u to work for me?

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

top sql cache -->...

Hi,

Thanx for ur effot but i sovled it my self .

from

killer

Thanx Phill,

I did not asked to work on that i just asked u how can i reach to my goal and where i am wrong.

from

Killer