Hmm, seems like I've misunderstood the caching:

Caching Reports (SSRS).

A cached report is invalidated in response to the following events: the report definition is modified, report parameters are modified, data source...

As far as I can see, this is OK with the licensing agreement, and Developer edition has the same engine as Enterprise Edition (ie all features available).

I have not seen a generic script, but you could use DBCC CHECKIDENT and Creating and Modifying Identifier Columns to achieve this.

A nice place to start would be sys.dm_db_persisted_sku_features[/url].

To be honest, I don't know if this is the issue, and I have not even tried to recreate the issue.

To me, it seems that the Service Account does not...

I do get the same error message, yes:

Msg 3723, Level 16, State 6, Line 2

An explicit DROP INDEX is not allowed on index 't1.ix_t1'. It is being used for FOREIGN...

First of all, I am very happy with being a database developer, not a software engineer. The difference to me, is that I have a strict focus on the databases,...

Thanks for your response. I wish it was that simple. Attached is my settings for caching.

This does indeed happen on both SQL Server 2008 R2 (RTM) and SQL Server 2008 SP2:

use tempdb;

go

create table t1 (

id int identity primary key,

val varchar(10)

);

create table...

Ok, I understand that I made myself misunderstood. Of course you can use a staging table, subqueries, common table expressions and so forth to insert the rows not conflicting with...

I am not trying to be rude, but if that is the behaviour you want, you should have a look at MySQL. SQL Server is by nature ACID compliant, meaning...

How to: Create a New SQL Server Failover Cluster (Setup)

Thanks a lot, that was exactly what I needed.

It is really all about coust versus benefit. If you need two instances, an so-called active/passive cluster would require 3 nodes. As such, you need enterprise edition of SQL Server,...

Myth: The sum of Max Server Memory for all instances in a cluster should be less than the physical memory of the node with the least memory