Yep, it would seem that is the only possibility here.

The pages are not deleted from the file, they are simply deallocated from the table. Actually, I would assume that absolutely nothing (not a single byte) is changed on a...

Yes, SQLiMail use SMTP and can only be used to send emails. There is no alternative to xp_readmail as far as I know, but it would not be too difficult...

Even if you could somehow find how the header looks and hex edit it in the file I do not believe you could get the file working. This seems...

Take a look at this KB article that provides information on how to create and use the stored procedure sp_blocker_pss80. This will give you valuable information to find which...

I don't have a design problem, an identity problem, I have a detailitis problem, wanting to deliver to production the most perfect db I can, that's all.

Why is having gaps...

Why not simply create two different procedures and execute the correct one based on which database you want to use?

Unless they ask they questions in order to upset you or belittle you I think they are ok with asking them. From personal experience of doing technical reviews of people...

And I see now that I misread your question. This should probably be what you are looking for:

WHERE RecordDate BETWEEN DATEADD(d,DATEDIFF(d,0,GETDATE()),-10) AND DATEADD(s, -1, DATEADD(d,DATEDIFF(d,0,GETDATE()),-9))

The basic answer is:

WHERE RecordDate < DATEADD(d, 10, GETDATE())

Depending on specifically how you want to compare the dates you might want to alter that. For lots of great information regarding...

There are better ways to do this. I suggest a look at the article I linked to above.

If you are going to use an automatically created surrogate key (and many would argue you should not), you should definitely not expose it as having some meaning. If it...

Is SQL Server running under the same account as it did before you installed the new version?

Arrays and Lists in SQL Server

Yes, all the values from the case statement needs to be of the same type of course. Use the max datetime value:

SELECT Col1

FROM Table1

ORDER BY CASE WHEN Col1 IS NULL...