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...

Indeed.

The prerequisite is you need the clustered index organized for your processing needs ( AccountID, [Date] in the example ).

Any other organisation will cause the mechanisme to fail.

I tested multiple...

As you suggested the "Order by" testing with Jeffs solution, I also tested your marvellous solution for partitioned objects.

First findings .... It no longer works .... SQL2008 ( sp1 )...

hmm ....

I ran this comparisson on

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (Intel X86)

Mar 29 2009 10:27:29

Copyright (c) 1988-2008 Microsoft Corporation

Developer Edition on Windows NT 5.2 ...

When we had our first HP servers, we needed to get used to the fact you need to update your HW drivers before you implement whatever kind of software.

No...

this will cause implicit conversions !

Implicit conversions may cause indexes not to be used optimal or not at all.

Even with cast/convert (which are explicit conversions) one of both columns...

So, you're not entitled to restrict the instances number of connections to the number you want.

You could use logon triggers to do just that for you.

You could set it...

You cannot do that using the regular backup / restore mechanisme.

You can script the full database (tick sql2005 compatibility mode !) and then create it at a sql2005 instance, and...

- How much physical memory (RAM) is installed in the server ?

- Is this a dedicated sqlserver server ?

-

Duration: 14434 seconds. Working set (KB): 10540, committed (KB): 38756, memory...

is dbcc opentran showing info (execute in the correct database !)