BTW here is another point of difference between Oracle & SQL Server. The definition of rewrite.

Oracle:

Query rewrite, which transforms a SQL statement expressed in terms of tables or views into...

PaulB-TheOneAndOnly (12/21/2011)

---

Elliott Whitlow (12/20/2011)

---

Although the phrase Materialized views is not used often with MS SQL the Indexed views are the equivalent. As they must be materialized and stored very...

OR

SELECT *

FROM OPENDATASOURCE('SQLNCLI',

'Data Source=London\Payroll;Integrated Security=SSPI')

.AdventureWorks2008R2.HumanResources.Employee

http://msdn.microsoft.com/en-us/library/ms179856.aspx

Then link the Server at runtime 😉

SELECT a.*

FROM OPENROWSET('SQLNCLI', 'Server=Seattle1;Trusted_Connection=yes;',

'SELECT GroupName, Name, DepartmentID

FROM AdventureWorks2008R2.HumanResources.Department

...

I find excuses...

This problem can occur when the password of the inter-domain trust account is not synchronized on both sides of the trust relationship.

Following KB articles might help you.

http://support.microsoft.com/kb/816577

http://support.microsoft.com/kb/892426

bwoulfe (12/21/2011)

---

Dev (12/21/2011)

---

bwoulfe (12/21/2011)

---

I'm familiar with the apply operator. I'll admit I don't use it too often though. I was just asking if the apply acts...

SQL Guy 1 (12/21/2011)

---

I was interviewed today, and one of the questions was : What configuration setting should you setup for new installation of SQL Server 2008?

I could...

bwoulfe (12/21/2011)

---

I'm familiar with the apply operator. I'll admit I don't use it too often though. I was just asking if the apply acts as an inner join...

ON Customers.dbo.Lead.Last_Evaluation_Product__c = Customers.dbo.Product.Name -- the culprit.

Please resolve collation conflict with COLLATE clause.

COLLATE (Transact-SQL)

http://msdn.microsoft.com/en-us/library/ms184391.aspx

Are you using SSMS or trying to connect via some application (third party/own)?

SQL Server Agent Mail

http://msdn.microsoft.com/en-us/library/ms188235.aspx

Using Database Mail with SQL Server Agent

http://msdn.microsoft.com/en-us/library/ms190606.aspx

engrshafiq4 (12/21/2011)

---

Dev (12/21/2011)

---

Koen Verbeeck (12/21/2011)

---

Tsk tsk tsk, Hall Of Fame, is that the christmas...

Try *r*n or *n.

Note: SSC removes back-slash(\)n from the post so replacing '\' with '*'

It might not...