Hi Hanshi

Yes, you are correct. I was knowing it that SSMS uses xp_fixeddrives. I have also included it in my msdn forum link.But I was not sure about it.

But if...

Hi Hanshi and jason

Both of you understood my question wrongly!!!

The error i am getting is not on clicking the OK button. By deafult the path is filled with path...

Hi Hanshi

I think you have not understood my question.Please see the the link(msdn forum link) also which i refereed in my qusetion.

Anyone faced same problem? Or anyone know how it can be solved?

Detaching the database worked fine and now replication related problem solved.

Thank you

Hi Gail shaw

Yes I saw that article. Right now i don't have replication set to the database. I think i had it a year before then i dropped all replication...

I tried sp_removedbreplication but it didn't help me to remove it.

Also under subscription in SMS i cannot see any replication. So from where it came? How it can be...

It's not a tempdb , it is my own user database.

When i run the query

select log_reuse_wait_desc from sys.databases where name = 'DBName'

I got output like

log_reuse_wait_desc

REPLICATION

But i don't have...

Sorry for the double post of same message.

The only reason to rename the file is for automated backup. I do have my own backup application where I can automate backup on daily,weekly or monthly basis. I am...

The only reason to rename the file is for automated backup. I do have my own backup application where I can automate backup on daily,weekly or monthly basis. I am...

I am changing file name of mdf and ldf file not database name. Does changing the MSDBData.mdf to MSDB.mdf cause problem?

I already have tcp/ip and namedpipes enabled. So it is no the error i think.

Can anyone please check this error and help me.

But that message is irritating as it comes every time.