Bring Online (Missing Transaction Log)

I cant bring my database online since the LDF is missing. However, the MDF
is fine. If I try to bring it online I get an error 5181 due to the missing
file.
Is there anyway to get the database going again without the transaction log?
Cheers,
elzikoHi,
Start the database in Emergency mode. So that Database will be started with
out transaction log. After that you can use DTS to transfer the data
and objects to a new database.
How to start the database in Emergency Mode:
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768
where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
Note:
Setting the database status to emergency mode tells SQL Server to skip
automatic recovery and
lets you access the data.
Thanks
Hari
MCDBA
"elziko" <elziko@.NOTSPAMMINGyahoo.co.uk> wrote in message
news:u6nrn1kEEHA.1368@.TK2MSFTNGP11.phx.gbl...
> I cant bring my database online since the LDF is missing. However, the MDF
> is fine. If I try to bring it online I get an error 5181 due to the
missing
> file.
> Is there anyway to get the database going again without the transaction
log?
> --
> Cheers,
> elziko
>

Border missing when exported to PDF

When exporting to PDF some of the columns have the border line missing
although the border line is visible when exported as HTML or web
archiveI have the same issue. Cell borders on tables (0.5 pt gray) randomly
disappear in the PDF rendering, but look perfect in HTML4.0. Some are there,
some are not. I tried increasing the resolution of the PDF to no avail.
Is this a bug with the PDF rendering? Is there a workaround? This is a big
issue for us.
-David
"Sush" wrote:
> When exporting to PDF some of the columns have the border line missing
> although the border line is visible when exported as HTML or web
> archive
>|||I did a search on the forums on the Adobe site and found a related issue.
Apparently several people have reported Acrobat 6.x has issues with borders
on text boxes and other thin horizontal lines. It was unclear if the issue
was the in the PDF format itself (distiller problem) or if the rendering was
messed up in the Reader.
Has anyone tried looking at this with Reader 5.x?
Microsoft, can you confirm that this is an issue with Acrobat Reader 6.x
rather than the PDF rendering extension for Reporting services?
Much thanks, David
"David Swanson" wrote:
> I have the same issue. Cell borders on tables (0.5 pt gray) randomly
> disappear in the PDF rendering, but look perfect in HTML4.0. Some are there,
> some are not. I tried increasing the resolution of the PDF to no avail.
> Is this a bug with the PDF rendering? Is there a workaround? This is a big
> issue for us.
> -David
> "Sush" wrote:
> > When exporting to PDF some of the columns have the border line missing
> > although the border line is visible when exported as HTML or web
> > archive
> >