That's what you get when your interviewer only has his/her mandatory-questions-list but without a clue what it's all about

"Is it possible that the insert trigger is firing prior to the commit tran? "

Yes !

the trigger is launched at command-time ( insert...

- backup your transactionlog !

Do you have a fullbackup taken before this incident, to which the logbackup can be applied ?

If yes, restore the fullbackup with another dbname using the...

make sure each db has at least one .mdf _and_ one .ldf file !

Also keep your backups !

As lholman mentioned, if sqlserver did...

in the backup-folder you'll mostly find .bak-files. These contain regular sqlserver backup-files. (these are to be user with the "restore database"-commandser)

The ones with .mdf, .ndf or .ldf are sqlserver data-...

If you have recent backups, restore will be possible with "restore db" (as long as you stay with the same version or with a higher version of sqlserver).

run DBCC CHECKDB ! see BOL 

Oops. Overlooked the select

back to profiler then

that's to be sure the leading zeroes are in place with hours < 10.

maybe just creating a trigger on each view may help out.

create a new table to monitor all objects.

create table dbo.T_MyMonitorredObjects

(ObjectName varchar(256) not null primary key

, UsageCounter int not...

did you drop and restore the db 'test' ?

If yes, check the user's default db.

if you should split for reusability,

and you cannot see any reusable parts,

what's left to be split ??

NEXT_RUN_DATE is int and not datetime and should be converted to datetime.

use something like this :

convert(datetime,substring(cast(run_date as char(8)) ,1,4) + '-' + substring(cast(run_date as char(8)) ,5,2) + '-' +...

- take a look at sp_attatch_db in BOL.

- you cannot attatch sql2k mdf/ldf to sql7 servers.

- You'll also have to sync db-users after you've attatched.

   use [User-db]

go

print 'print @@servername +...

installation gets stuck when "gathering install info"