Can I delete the secondary data file in emergency mode?

there will be any data loss??

the secondary data file was wrongly created with extension .mdf instead of .ndf

but i dont have backup...

can i put it in emergency mode and then take backup and restore??

My Primary data file is existing but secondary data file is missing

SELECT name,accdate FROM master.dbo.syslogins

shows the creation date but i want the last login date when the user logged in for the last time

Hi Greg,

Thanks for ur help

but "SELECT deleted.column1 from DELETED" would get you the old value while "SELECT inserted.column1 from INSERTED" would get you the new value...this only works for 1...

In my audit table there are columns as old value and new value

How to fetch the old value??and if the original table has 2 or 3 column names,how to fetch...

Could you plz let me know how to check in trigger for old value and new value so that the result can be added to audit table??

Here is the script

CREATE TABLE Test_Audit

(Table_name varchar(100),

Audit_Timestamp datetime

)

CREATE TRIGGER AfterInsert ON [dbo].[test]

FOR INSERT

AS

declare @Table_name varchar(100)

set @Table_name='test'

insert into Test_Audit

(Table_name,Audit_Timestamp)...

I have created a audit table which shows Tablename,timestamp when triggers happend and which tablename the trigger happend..

I want columnname,oldvalue,newvalue to be added in audit table...

It works well with 1...