SQLRNNR (6/21/2011)

---

Sumanta Roy (6/21/2011)

---

Hi grant,

As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to SQL...

I gave you a way.

If procA refers to procB and you only compile procA in the database then this query will show you that procA refers to procB:

SELECT ...

Direct replies here: http://www.sqlservercentral.com/Forums/Topic1128842-147-1.aspx

Grant Fritchey (6/21/2011)

---

Sumanta Roy (6/21/2011)

---

Hi grant,

As you said ANSI 89 outer joins are no longer supported in 2008, I have one doubt. If we change the database compatiblity level to...

Ha! Next time say which file it could not find 😉 Happy you got it sorted 🙂

You're very welcome 🙂

Try converting to DT_WSTR if the max length of your string is 4000 or less. If more then use DT_NTEXT.

b.lam (6/20/2011)

---

@opc.three:

Thanks for the suggestion.

The CTE will actually have to be flipped to include the CONTAINs predicate.

The reason being that the CONTAINs predicate cannot be applied to a table that...

Jeff Moden (6/20/2011)

opc.three (6/20/2011)Having an SSIS package "watch" a directory awaiting the arrival of a file is a trivial task and IMHO should not be a reason to implement xp_cmdshell....

I think the problem is happening with the FTS CONTAINS function.

Here is the parameter list for the TOP 2 query and you can see its using a "map":

Scalar Operator((1)), Scalar...

Two things I would confirm:

> Is your LDAP string is correct? See this post.

> Do you have permission to query that data in Active Directory?

The initial difference I notice is that the TVF in the TOP 1 query is delivering 213,364 rows and the TVF in the TOP 2 query is only delivering 2...

What version is the OS is running on the remote server? What version is the database instance?

I do not know of a tool that will piece that together for you.

If you know specifically what you're looking for you could search the definitions of the all sql...

Selvaraju (6/20/2011)

---

23 million table is completed in 20 mins but yet to start the 3.8 Billion record count table script. I am wondering whether there will be failure after 5...