You could disable the constraints, check the data, delete invalid rows and enable the constraints again.

That's what Pinal Dave seems to suggest.

I've never used it before.

You can enforce the hint using OPTION (ROBUST PLAN) the way you tried.

Check sys.dm_exec_query_stats, should give you the info you need.

Ah, my bad, I didn't check things properly.

Maybe this thread will help you:

http://social.msdn.microsoft.com/Forums/en/transactsql/thread/824140a5-0f2b-4254-a69a-6ecdbffe2bb5

Wit sample data I mean something readily consumable, like this:

SELECT *

FROM (

SELECT 'Systems Team Applications', ...

Weird, looks like an error you could get from a SQL Server 2000 database.

What compatibility level is your DB?

Can you please post some sample data and the expected output?

That would make things a lot easier for us.

SQL Server will use the credentials of the connected user to access the external resources, unless you explicitly impersonate a different user. In the case of a Windows Login, you...

You're welcome!

This article should help:

http://www.sqlservercentral.com/articles/Administration/monitoringdiskspaceandsendingalertswithtsql/1114/

INSERT INTO WestwoodReport SELECT * FROM OPENQUERY(LSCTLRDAT1, 'SELECT * FROM PMSPYP00 WHERE YP_EFFECTIVE_DATE >=1111001 AND YP_Account_No IN (7003303,7003050,7003055,7003013,7002928,8062604,7003306,7002945,7003019,7003006,7003014,7003018,7003307,7002936,8062091,7002897,7003061,8062736,7003064,8062946,7003012,7003057,7003029,7030003,7003314,7003315,7003020,7003017,7003311,7003056,7003329,7002999,7003062,7003024,7003319,7002934,7003063,7002992,7003078,7003323,7003309,7002898,7030010,7002998,2993-01,7003304,7003074,7003317,7003068,7003053,7003067,7003070,7003069,7003073,7003341,7003071,7003320,7003072,7003082,7003088,8062686,7003022,7003065,7002941,7003332,7003084,7030015,7003338,7003302,7003033,7003075,7003015,7003333,7003089,7003085,7003059,7003023,7003349,7003034,7003330,7030014,7003318,7003037,7030017,7003313,7003340,7002946,7003038,7003086,7003087,7003098,7003301,8063443,7003026,1014382,7030013,7030012,7003021,7030019,7030011,7003092,7003030,7003058,7003040,7003031,7003052,7003091,7003308,7003334,7003076,7003079,7003339,7003093,7003353,7003337,1014483,7003066,7003322,7003035,7003095,7030016,7003042,7003094,7003041,7003028,7003097,7003032,7003312,7003036,7003351,7003355,7003016,7003025,7003356,7003356)') AS DB2

I suppose 2005, since this is the 2005 forum.

This should do the trick:

http://www.sqlservercentral.com/Forums/FindPost986064.aspx

When referencing a table variable in a where / join predicate, you need to use an alias.

Powershell is the answer:

http://blogs.technet.com/b/heyscriptingguy/archive/2010/11/04/use-powershell-to-script-sql-database-objects.aspx

You don't need to be familiar with it, you just need to run it 🙂