Thank you for your reply. Although I still get some issues.

These are the commands I issue:

create role ReallyReadOnly

ALTER AUTHORIZATION ON SCHEMA::[db_datareader] TO [ReallyReadOnly]

ALTER AUTHORIZATION ON SCHEMA::[DB_DenyDataWriter] TO [ReallyReadOnly]

exec sp_addrolemember 'ReallyReadOnly',...

Thanks for this quick reply 🙂

I agree, it´s unnecessary to update with CU if there are no issues going on.

Does anybody know when SP1 will be released ( for...

Actually I think you need to add a line to the publisher side aswell

I found the solution on this site 🙂

http://www.sqlservercentral.com/Forums/Topic554399-149-1.aspx

After adding the server name to the host file on the subscriber side (2K8) I was able to connect.

I even now created the server with sp_addserver in every possible combination.

In Management Studio I can connect to the remote server, view all databases, users, tables,...

What do you mean exactly with having the alias also server side ? Do you mean where the publication is ?

SQL2K5 = Publication

SQL2K8 = Subscription

I created an alias called...

I believe I am doing that.

I create a Local publication on 2K5 and I´m trying to create a Local Subscription on the 2K8 server, isn´t that correct? :/

Two of the columns are almost never NULL, the other two are more 70% null-30% data.

[RequestWire] [text] NULL,

[Request] [text] NULL,

[Response] [text] NULL,

[ResponseWire] [text] NULL,

... actually contain xml data, which should compress rather nicely since there are alot of repetitions. Although the individual rows are not...

Didn´t make a difference :/

Thank you, that´s great advice 🙂

I´ll try it.

This is the code for the uncompressed version.

I then go through the sp_estimate_data_compression_savings procedure to see how much the table will compress.

This is the only index.

What I find odd is...

Here is the create script:

CREATE TABLE [dbo].[Table](

[ID] [bigint] IDENTITY(1,1) NOT NULL,

[MachineName] [varchar](50) NULL,

[Service] [varchar](100) NULL,

[WebMethod] [varchar](100) NULL,

[Session] [varchar](50) NULL,

[Name] [varchar](50) NOT NULL,

127.0.0.1 [varchar](50) NOT NULL,

[Time] [datetime] NOT NULL,

[Duration] [float] NOT...

Well the data compression was not turned on beforehand and I did run the estimates and it returned the same amount of compression, only 1 gb.

Most of the data is...

Ah that´s the case 🙂

I need to add a "WITH EXECUTE as..." clause in the trigger definition

Now it works, thanks 🙂