Remember that "Filtered indexes" are used only if the WHERE clause matches or is compatible with the filter.

View http://www.sqlservercentral.com/questions/T-SQL/105826/

marcia.j.wilson (3/18/2014)

---

I'm not sure I completely understand this.

Is this what's going on?

-The query initially adds a single row with a value of 1.

- The open query returns the deleted set...

About?

Hany Helmy (3/18/2014)

---

-1...

These queries demonstrate the two different connection:

select @@SPID

SELECT * FROM OPENQUERY(MyServer,'select @@SPID')

timwell (3/17/2014)

---

I have a question.

I got crossed up because the documentation says that sp_serveroption and openquery are for connecting to remote or linked servers. I was thinking the delete was...

Mikael Eriksson SE (3/17/2014)

---

Carlo Romagnano (3/17/2014)

---

Mikael Eriksson SE (3/17/2014)

---

I guess the reason for the rollback is that the output clause is not allowed when you do remote queries.

Using a query...

:-D:-D:-D:-D

Unbelievable, but true!

In this case, you haven't the DELETED.* resultset.

Mikael Eriksson SE (3/17/2014)

---

I guess the reason for the rollback is that the output clause is not allowed when you do remote queries.

Using a query like this will show the...

palotaiarpad (3/12/2014)

---

Hmmm.

According to BOL 'not.funny' should be treated as a failure:

[ @newname = ] 'new_name'

Is the new name for the specified object. new_name must be a one-part name and must...

"Schema cannot be named Not" ?????

"It could be said the table is not funny" ????

Bad wording?

+1

😉

From BOL:

The...

Hany Helmy (3/3/2014)

---

I guess there is something wrong with this question as it should be like follows:

SELECT X AS 'Except'

FROM A

EXCEPT

SELECT Y

FROM...