Hi Prakash,

It's a network issue and i moved the server to same LAN and tried creating it.

It works like charm!:)

Thanks

Hi,

i will clearly explain u the issue

1. I am able to ping both the server

2. I have cretaed a linked server between server A and server B

3. In the security...

Hi,

I have tried adding the securables but the result is same error.

I m breaking my heads with this problem for the past 10 days. It is very easy in sql2000...

Hi,

All my objects are under the dbo 'schema'. I used the following query

select id,name from [linkedservername].[test].[dbo].[sample]

if i execute i am getting the same error.

I found the schema by the following...

Hi,

I tried Sqlserver also but the error is same.

I also done thru SQL account.But i am not able to locate abt the RPC attribute. how to enable the rpc attribute?

Hi,

I am also getting the same error

"Error: 17883, Severity: 1, State: 0

The Scheduler 0 appears to be hung. SPID 0, ECID 0, UMS Context 0x03C586A0."

we are using sql2000...

I read your documentation clearly. I dont find any configuration to limit the size of the audit trace from 200 mb to 20mb or anything . And also there is...

Thanks Scott

i have solved the problem by creating a separate windows based user for sqlagent and created a separate user-id for all users with separate rights.

My sqlagent account is...

Thanks for the explanation..

Hai

Thanks Gail for the reply. In my setup there are objects with primary key and some objects without primary key. But the data...

Hai,

I am using sqlserver2000 standard edition. The database size is 20gb. I am implementing transaction replication. While configuring i am not...

Hi

There is no ghost cleanup or any process is running. Only sqlservices is using the maximum resource.

what else to be checked.

Hi

we are running sqlserver2000 standard edition with service pack 4.

we are encountering the cpu 100% more than 5 times a day.

we ahve checked thru perfmon.

pls look at the following counters

buffer...

Paul i am doing a dbreindex.

i am using the fillfactor 70