iif in access is equivalent to Case in SQL

but maybe you are looking for something like:

select *

from [yourtable]

where (Column1 = @data or @data IS NULL)

Sure! it is what I would do

Yep it is pretty much too late for logexplorer but not too late for entegra which would archive it sepparately

about the

"If the...

That is true if you need the client to execute code but if all you need is to activate an alert the Client does not need to be aware of it. At...

I don't think you could tell who unless you have the tlogs for the dates that the creation happened and you have a tool like logexplorer or entegra

well, if that is the case, I can't seem to duplicate your  scenario either

I am not quite sure how the data looks like but here is a wild guess

select 

       BLOCK_ID

     , DENSITY

     , AVG_THICK

     ,...

I believe the problem is not autoclose but is the user permissions.

Information_schema as well as sp_databases display the information for which

has_dbaccess(name) = 1

therefore you will have to go for:

select...

Fargmentation level (due to page splitts) could also be the problem but I have never seen an extreme difference in size due to that.

Do you have indexes rebuild on...

I think the problem is here:

Database name - All databases

That alert is global shoud you have something similar on another database and it happens within 5 seconds you will get...

Queue updates with SQL Server as the manager of the queue mechanism implies that you will have an extra table : MSreplication_queue.

If your queue reader has not piked those...

UPDATE TableX

SET ColumnB = SUBSTRING('EU', Cast(Left(ColumnA,3) as Int) % 2)+1,1)

if replication is in the way there can be many things going on Like:

the delete sps are disable or commented out

if data can be modified on the destination there is...

you are not linking the exists with the outer table!

INSERT Contacts(compID, first, last, phone, email)

SELECT compID, fname, lname, phone, email

FROM import_contact IC

WHERE not exists (select C.contactID

from Contact c, import_contact...

>>Due to specific reports that need to be run - this was the simplist way to set the tables up.  I agree that a single date column would have...