Audit Log in Yukon

Hi There,
Can someone tell me if there is any difference in the audit log available in
SQL Server 2000 and Yukon?
TIA
irfan
Do you mean the Audit Level server setting that writes entries to the SQL
Error Log? The biggest change is the logging of the IP address. There are
also a number of other options for collecting this information e.g. the
default trace or event notifications (via TSQL or WMI). In earlier builds
the Audit Level was set to All by default but sanity seems to have prevailed
and the default setting is now Failure.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Irfan" <Irfan@.discussions.microsoft.com> wrote in message
news:D112D80B-A00F-4D37-85AB-F0B3A96F4542@.microsoft.com...
> Hi There,
> Can someone tell me if there is any difference in the audit log available
> in
> SQL Server 2000 and Yukon?
> TIA
> irfan

Attaching .mdf to SQL Server 2005

If I only have a .mdf file available, how can I attach it to SQL Server 2005? It keeps asking for a .ldf file which I don't have.

This one's related to posthttp://forums.asp.net/1210138/ShowPost.aspx

The LDF is the log file (containing transaction logs) for the .mdf. I believe you need both to do the attach, and they should always be together in the directory structure. You should be able to get the .ldf from the same place you got the .mdf. If your database is called mydata.mdf then the transaction log will be called mydata_log.ldf

|||I believe someone was looking for something similiar a month or a two ago, and they did find a solution, you may try searching the forums. Unfortunately, I don't remember what they did ;-(|||

Freakyuno wrote:

The LDF is the log file (containing transaction logs) for the .mdf. I believe you need both to do the attach, and they should always be together in the directory structure. You should be able to get the .ldf from the same place you got the .mdf. If your database is called mydata.mdf then the transaction log will be called mydata_log.ldf

Normally the .ldf must accompany the .mdf file, I know but in this case, the Atlas Wiki starter kit doesn't ship with the .ldf files.|||

dotNETSlave wrote:

If I only have a .mdf file available, how can I attach it to SQL Server 2005? It keeps asking for a .ldf file which I don't have.

Hi,

you can use the Microsoft SQL Management studio, choose the Master database in the combobox, open up a new query window and use the

sp_attach_single_file_db

command to get it to work.

Grz, Kris.

|||Thanks, that seemed to do the trick.