OK, I think I did not make myself clear, I know that compressing a table in SQL Server will use less disk space at the end.
But my question is...

Thank you....

Got it, Appreciate your help......:-)

Thanks for your response, at this point we do not have WSFC, we just have FCI with those 3 nodes.

2 nodes have 3 primary databases(Node 1 = 1 database,...

Thank you everybody for your help.

I found by trying, that AlwaysOn can only be configured on a Failover Cluster Instances.

Thanks again

Jim, thank you for your reply, the step by step link is a great help.

But, at this point lets not talk about Availability Groups, just one server in Miami and...

Thank you for your help, it clarifies the process for me, now here a better questions:

Transactional replication is on....

1.- If I want to add a table that was not replicating...

Thank you for your help, it is always good to know that there are people that always will help you.... like this Forum...:-)

Thank you all for your help. The suggestion from Chris worked fine....:-)

Thank you Craig for your response.

What it puzzles me is that I can execute with no problems when I have it open the package in BIDS, it looks that it...

YES......

You are absolutely right, I am using SQL Server 2008, not SQL Server 2008 R2, and the bug is killing me!!!!!!.

I will ask my boss to upgrade to R2.

Great reasearch!!!!

Thanks...

WOWWWWWW....

Listen to this....

Yes I can not see the tables thru SSMS when I am logged in as U1,

BUT if I do a select on the tables with schema 'Common'... IT...

CORRECTION, sorry, the following is the last command, the grant is to the ROLE not to the User ID.

Still did not work..... 🙁

use [IMS_DIAGRAM]

GO

GRANT DELETE ON SCHEMA::[Common] TO [abc]

GO

use [IMS_DIAGRAM]

GO

GRANT...

Hi everybody:

Thank you for your time and responses, but let me explain what my specific problem is, maybe this way I can show what my problems is:

Now in SQL...

Hello, thanks for your help...... here is what I do:

Let me know if it works.....

CREATE DATABASE someDatabase

GO

USE someDatabase

GO

CREATE USER abc FROM LOGIN imstestuser<< this is also a SQL ID that...