Thanks everyone! How can I export the output to a csv file please? I tried the below export-csv -append -path but I don't see the servername and instancename columns being...

Can I use a script to find that info please? Thx

Yes, highlight only the rows if the values if col3 values are less than 500.

Thanks for the responses.

I will be doing the following steps, please let me know if I am missing anything in here:

1. Remove the SQL 2008R2 from Cluster1\Node1

2. Install SQL...

Can I do something like this:

The view is basically selecting columns from orders table.

For example in the publisher:

Create view dbo.Orders_View

as

Select col1,col2,col3,col4 from dbo.Orders

Then I...

Any ideas? Thanks.

The view is basically selecting columns from orders table.

For example in the publisher:

Create view dbo.Orders_View

as

Select col1,col2,col3,col4 from dbo.Orders

Then I want to replicate that view dbo.Orders_View from publisher to subscriber.

This replication...

The reason I want to replicate the data from a view is that only few columns can be copied over to the subscriber. I understand that we can also select...

Any idea?

SQL Server 2008 Enterprise edition

Any ideas? If I can get some article to refer to for doing this that will be great! Thanks.

I can see the oracle provider under the providers list and also I gave permission to the oracle folders to the sql service account and my account, even then I...

I am getting the below error:

TITLE: Distributor Properties

------------------------------

Oracle server instance 'Instance1' cannot be enabled as a Publisher because of the following error:

------------------------------

ADDITIONAL INFORMATION:

Unable to run SQL*PLUS. Make certain that a...

There is no difference in the data. I am very frustrated with this error.

Any body can help on this, I need this urgently. Thanks!!