Select Machine, Software, min(date) as FirstInstall

from dbo.Devices

group by Machine, Software

You have an option with the bulk inserts. You can add the keyword "FIRETRIGGERS" so that the triggers still fire with the insert. You can do the same...

This is a good start... but you'll have to dig around for the status column meanings :

Select CT.ftcatid, O.name as TableName, CT.name as CatalogName, CT.Status from dbo.sysfulltextcatalogs CT inner...

Select * from

(

Select null

union all

Select season from dbo.saisons

) dtNulls

cross join days

Books online.

Well it fails if the receiver has it off, and now I'm assuming when the sender had it off too. Why can't you just start those services?

alter table..

add colname as replace()

No you don't need to, you can flag the new rows and have a job send the information to a text file when needed, which is the recommended method...

The server will do it for you.

Because it'll still do a scan if it's not indexed. Also the trims just don't do squat because the replace already wipped out all the spaces.

SCAN : open the...

Yes it does :

Select whatever from dbo.YourTable where YourIndexCol like 'sdfk%'

This uses a seek

this however results in a scan

Select whatever from dbo.YourTable where YourIndexCol like '%sdfk%'

Why not make the server generate that file 2 minutes before the service starts?

Nice catch, confirmed :

GO

Create table test

( id int not null identity(1,1) primary key clustered,

someBit bit not null

)

GO

CREATE INDEX IX_text_Somebit on dbo.Test (SomeBit)

GO

Insert into dbo.Test (SomeBit) values (1)

Insert into...

Why a text file?

use max or min... but I doubt that it'll solve your problem in this case since I assume you have more than 1 row to present.