It must be a bug.

I've tested in on SQL2008 SP1. (10.0.2531.0 (Intel X86) )

It gets even worse if you explicitly use the ID column in the filtered index definition.

(tested...

I wouldn't advise this kind of operation to a less optimal data type.

You lose all datatime functions and validations !!

Chose your level of detail !

declare @dt datetime

Select @dt =...

Adi Cohn (5/4/2009)

---

Timestamp has nothing to do with date. Timestamp is just a binary column...

great article.

Thank you for pointing the known issue and the ref to connect.

FreeHansje (4/30/2009)

---

Hi ALZDBA,

Have you ever benchmarked this MS_ForEachDB? I have, it's not good. And basically it's just another loop.

But as I mentioned before: it is not about a 'realistic' situation,...

also keep in mind when migrating an existing data system, you will have to deal with legacy short comings, data or data structures that doesn't make sense, but is those...

sam (4/29/2009)

---

Let me clarify - we have 8 processors and one instance right now. We will add an additional instance...

with ssis/dts you would have to check the packages connection data and queries. With each connection, you would also have to search for linked server queries,...

Same goes for .exe of...

we just use sqlagent to take scheduled backups.

Because dbs are implemented according to a prepared schedule, we just refresh the needed jobs and allerts (% log full for incremental log...

Not if you restrict it to only use 2.

Also keep in mind to restrict the "audit" instances max server memory.

Thank you for the feedback.

Let us know if the hotfixes helped.

aahh yes ... security granularity with SQL 2005 and beyond...;-)

What sqlserver software level are you on ?

select @@version

This issue does ring a bell ... far, far away :blush:

Search the MS KB ... maybe you'll find a known problem over...

There is no option to force it, except for a DDL trigger (database level).

Check for DDL triggers that might re-create the sprocs adding the "with encryption" option

- another solution to offload the msaccess :sick: stuff may be db mirroring with a read only copy on the mirror site.

But since licensing is an issue ... you need...