> > > I renamed the db with 'test' on the end of the filename - Hope not file but database name.

"NathanG" wrote:

> Did that mate. When we selected the destination we added 'test' on the end.
> When do we change the db file name? What about the log and mdf files? Does it
> matter where the new db is stored i.e C:/customers instead of where sql
> server stores them by default?
>
> Thanks
>
> "Alexander Korol" wrote:
>
> > How did you copy the database? Use backup/restore with new name and
> > everything should be ok.
> > Best regards.
> >
> > "NathanG" wrote:
> >
> > > Hi,
> > >
> > > I am using server 2005. I copied our live DB to create one for testing only.
> > > I renamed the db with 'test' on the end of the filename. Now the test db
> > > isn't working and gets no results from any queries. The queries are
> > > retrieving data, performing a calculation and output the results. The stored
> > > procedures and functions have not inherited the new db name i.e
> > > live_test.storedprocedure and still have live.storedprecedure. The functions
> > > are the same.
> > >
> > > My colleague created a new stored procedure and the naming conventions
> > > changed to the apparent owner of the db. i.e [name].storedprocedure. She did
> > > this by changing the ALTER procedure to CREATE procedure once and changing it
> > > back to ALTER.
> > >
> > > Any ideas? All that is needed is an complete replica of the current db and
> > > it seems the replica is trying to point to the orginal.
> > >
> > > I am not an expert developer as yet so any suggestions appreciated. If you
> > > need more info please say and I will do my best to provide it.
> > >
> > > Thanks,
> > >