Just found my mistake :

Select FileName from master.dbo.SysDatabases

SysFile is a virtual table that contains the fileinfo for the current database only.

Win XP?

Even in this case, the not in can make more sens to use than the not exists... Context is everything when you talk about performance.

let me rephrase my question. An exemple that you would actually use in production with performance in mind.

Good luck .

Do you have multiple installations on the same pc?

Have you tried both the lazy and precise solutions?

any of the 2 conditions will do... I'd go with the path for precision or the shortname for lazyness .

I don't either... but at least you have templates now .

Select * from master.dbo.SysFiles where

name = 'FileNameGoesHere'

--and FileName = 'FullPathRelativeToServer'

"but it's not for the faint of heart."... certainly not, but the keyword here is BACKUP BEFORE.

It works on my pc, but I ahve them in a new folder... maybe you could move the template and hit refresh??

Should work...

How about differential every 4 hours and log back ups every 15 minutes?? Can't lose more than 15 minutes of data that way.

a) 26M is a lot of rows.. are you sure you need that much???

b) size of the row for the selected columns (int = 4, tinyint = 1...)

F) one of...

Can you rerun the query like this and post the actualy text plan?

set showplan_text ON

GO

--select query

GO

set showplan_text off

Hehe, missed an easy one here... Thanx for the correction .