Script is created by me. As you see in the Script I have 3 Data files and one Log file .If i remove this particular file (NDF) all works fine.

For variable passed through the property file we need two slashes.

Follwing is my script
CREATE database $(hmsDbName)
ON PRIMARY (NAME= $(hmsDataName),
  FILENAME= [$(hmsDataFQFileName)],
  SIZE = $(hmsDataSize),
  MAXSIZE = $(hmsDataMaxSize),
  FILEGROWTH = $(hmsDataGrowth)),
FILEGROUP [$(eamFileGroupName)]
...

Hi 
I tryed that but still it is not working.
Thanks,
Padmakumar

We are combining two db into one .Now both have default schema as dbo.

In the New combined DB we will have two user(Hms,EAM) and two schema (HMS,EAM) and login...

With user which have default schema we can access object without specifying schema name right ?

Like select * from table .

But i cannot access like that it is giving...

Thanks All.

Schema prefix is must for function ? Like Select myschema.myfunction('Test')

I am not using any application.I am trying to configure Database mirroring.

following is the error massage i am getting at that time .Previous error i mentioned was in Sqlserver...

I checked default database for sa. It is master.Mirror database is in restoring state.

but still i am getting same error.

Thanks,

Padmakumar

DB state is Restoring

Thanks,

Padmakumar