mixed recovery modes

Are there any limitations in SQL Server 2000, or 2005 in working with one
database in full recovery mode and another in simple recovery mode?
Under other platforms, you can't join between a logged and non-logged
database.
I think the answer is "no problem", but I would like to be sure.
In particular, I'm thinking about changing the recovery model of the
database drop off point to the search engine to simple, as its just a copy
and is reset daily from production.No problem. :-)
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jay" <nospam@.nospam.org> wrote in message news:ec6fVRL8HHA.2004@.TK2MSFTNGP06.phx.gbl...
> Are there any limitations in SQL Server 2000, or 2005 in working with one database in full
> recovery mode and another in simple recovery mode?
> Under other platforms, you can't join between a logged and non-logged database.
> I think the answer is "no problem", but I would like to be sure.
> In particular, I'm thinking about changing the recovery model of the database drop off point to
> the search engine to simple, as its just a copy and is reset daily from production.
>|||ty sir.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:eAGqgSL8HHA.1204@.TK2MSFTNGP03.phx.gbl...
> No problem. :-)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Jay" <nospam@.nospam.org> wrote in message
> news:ec6fVRL8HHA.2004@.TK2MSFTNGP06.phx.gbl...
>> Are there any limitations in SQL Server 2000, or 2005 in working with one
>> database in full recovery mode and another in simple recovery mode?
>> Under other platforms, you can't join between a logged and non-logged
>> database.
>> I think the answer is "no problem", but I would like to be sure.
>> In particular, I'm thinking about changing the recovery model of the
>> database drop off point to the search engine to simple, as its just a
>> copy and is reset daily from production.
>