Thank you somuch...

I was not aware about it.. Thanks a lot.

Smith.

Thanks.. that was the problem.

The database dropped was the default DB of the logged in user.

And I dint know any other login password to set it.

Anyways, it was done...

Yup..Am...

Thank you. Let's wait and see if anyone else replies to this thread.

My general rule of thumb is that you should back up the log AT LEAST every half hour. If the database is busy, then do it more frequently. The busier...

Thanks Gila

Not regulerly. Since it had grown too big shrunk it once.

By the way, Mirror database is in "Restoring...." mode.

I mean, it's NOT displayed as "Synchronized/Restoring"..

Its just DBName(Restoring.......). is anything...

Fine. I will try that and revert.

Thank you somuch again.

Smith.

Do we need to check it on both the servers ?

It has to be be in-process or out-process ?

How to change it as well.?

Thanks a ton.

Smith

It's SQL Server only.

How to check is the provider is...

Yes......... This is working.

So what could be the issue and how to resolve it

Procedure is executed from an application which cannot modify.

Thanks a lot. Kindly guide how to resolve...

Msg 102, Level 15, State 1, Line 2

Incorrect syntax near 'linkedservername'.

Able to select data from tables.

Thanks,

Smith.

EXEC master.dbo.sp_addlinkedserver @server = N'linkservername', @srvproduct=N'SQL Server'

GO

EXEC master.dbo.sp_serveroption @server=N'linkservername', @optname=N'collation compatible', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'linkservername', @optname=N'data access', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption @server=N'linkservername', @optname=N'dist', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'linkservername', @optname=N'pub', @optvalue=N'false'

GO

EXEC master.dbo.sp_serveroption @server=N'linkservername', @optname=N'rpc', @optvalue=N'true'

GO

EXEC master.dbo.sp_serveroption...

Hi,

Thanks. In fact I have checked those settings as well.

It was allready done on both the servers. I am getting lost now.

Thanks.

Smith.

Thanks for all the responses.

I have checked all the configurations including "RPC & RPC Out". Both are allready set to TRUE only.

Settings all are done properly. Any other possibilities ?

Thanks,

Smith.

Nice to hear that the issue is resolved. 🙂

By the way, could you identify what exacly was the...