It's possible SQLdm is getting it's information from DMVs (if that counter is even available through the DMVs) which are not guaranteed to be exactly the same reading as what...

T-SQL supports all your common comparison operators, e.g.

=

<

>

!= or <>

Comparisons involving two rows might imply the comparison would take place in a WHERE-clause. If you provide table definitions...

The issue is that Office...

shreyanshbhatt (2/5/2013)

---

I ran that on the Remote PC. But after your comment when I ran it on the main PC I am getting same result FILTERED.

Is it something to do...

When you say "run using the same account" do you mean the jobs have the same owner?

Are there any job steps that use proxies?

opc.three (2/1/2013)

---

The tradeoff I am seeing is that while you're reducing the size of the claim you may be adding a JOIN into your batch process and reports to bring...

Remote DAC connections are disabled by default so no worries there, just leave them disabled if you're concerned.

SELECT *

FROM sys.configurations

WHERE name = 'remote...

Filtered means no response was received. Just to confirm, did you run the command on mainpc or from a different machine, i.e. the remote client? Make sure there are no...

No, Table name or view name variable.

You can decide that in the Expression of the Variable that determines which table name your OLE DB Destination points to.

ratheesh4sql (2/1/2013)

---

Hi,

Any one help me how can to Change default SQL port from 1433/1434 to 9877/9878, if i change is that portt will be changing in Cluster listener in Always...

If the error number is 13,000 or greater and the severity is 18 or lower then it could have been either the database engine or a user. Users cannot explicitly...

There are a lot of rules around creating an updatable partitioned view.

Modifying Data in Partitioned Views

You can always fall back on implementing an INSTEAD OF TRIGGER.

sathiyan00 (2/1/2013)

---

Hi all,

I think this may be a basic question.But still i'm not clear about this..

If i'm using Master Data Services(MDS) for master data...

It is a lot of work to do this in SSIS. Do you have to use SSIS? You could do this with a single line of PowerShell too.