Any help would be welcomed!!

6 Apr 2006 11:05 AM

Enric

I'm using DMO library.
I'm struggling and pulling out my hair trying to find the f*ck.. property
for the Recovery Model (simple, full,
Server.Databases.Item1.....

Does anyone here have

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)

6 Apr 2006 11:17 AM

Tibor Karaszi

Seems to be a Property of the DBOption2 object.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quoteHide quote

"Enric" <vta***@terra.es.(donotspam)> wrote in message
news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@microsoft.com...
> I'm using DMO library.
> I'm struggling and pulling out my hair trying to find the f*ck.. property
> for the Recovery Model (simple, full,
> Server.Databases.Item1.....
>
> Does anyone here have
> --
> Please post DDL, DCL and DML statements as well as any error message in
> order to understand better your request. It''''s hard to provide information
> without seeing the code. location: Alicante (ES)

6 Apr 2006 11:28 AM

Enric

jezz, seeing on dmo I have only:

server.databases.item.dboption....

!!

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)

Show quoteHide quote

"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Enric" <vta***@terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@microsoft.com...
> > I'm using DMO library.
> > I'm struggling and pulling out my hair trying to find the f*ck.. property
> > for the Recovery Model (simple, full,
> > Server.Databases.Item1.....
> >
> > Does anyone here have
> > --
> > Please post DDL, DCL and DML statements as well as any error message in
> > order to understand better your request. It''''s hard to provide information
> > without seeing the code. location: Alicante (ES)
>
>

6 Apr 2006 11:42 AM

Enric

I'm sorry...I've got it

Dim oss1 As SQLDMO.DBOption2
?oss1.RecoveryModel

--
Please post DDL, DCL and DML statements as well as any error message in
order to understand better your request. It''''s hard to provide information
without seeing the code. location: Alicante (ES)

Show quoteHide quote

"Tibor Karaszi" wrote:

> Seems to be a Property of the DBOption2 object.
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
> Blog: http://solidqualitylearning.com/blogs/tibor/
>
>
> "Enric" <vta***@terra.es.(donotspam)> wrote in message
> news:0E4F63B6-E3F5-4CD0-BC2A-9D71F68B3717@microsoft.com...
> > I'm using DMO library.
> > I'm struggling and pulling out my hair trying to find the f*ck.. property
> > for the Recovery Model (simple, full,
> > Server.Databases.Item1.....
> >
> > Does anyone here have
> > --
> > Please post DDL, DCL and DML statements as well as any error message in
> > order to understand better your request. It''''s hard to provide information
> > without seeing the code. location: Alicante (ES)
>
>