Okay, I think I can write the original code as an iTVF:

create function dbo.fn_test(@TestCol int)

returns table

as

return(select case when @TestCol = 1 then 'Abc'

...

Intellisense in SSMS 2008 only works when connected to SQL Server 2008. It is not backward compatible.

There are differences between Oracles SQL and Microsofts SQL Servers T-SQL. If your organization is going to purchase a database system, moving to Oracle is going to require a...

Have you tried putting the results of the query using just the contains predicate into a temporary table (not a table variable), and then query the results? You may...

As several have already told you, unless you take the time to provide us with the CREATE TABLE statement(s) for each table, sample data for each table as a series...

If you can still log in with sys admin privs (or at least security admin privs), then yes. I would not spend any more time trying to recover the...

Craig Farrell (6/20/2011)

---

SQLRNNR (6/20/2011)

---

Lynn Pettis (6/20/2011)

---

Craig Farrell (6/20/2011)

---

Lynn Pettis (6/20/2011)

---

Craig,

Is this a mandatory butts-in-chair position or is it something that could actually be done remotely (even during evening and weekend...

I came up with a similar query:

with FTSearch ( -- Find all Items Id's where contains return true

ItemId

) as (

select

s.ItemId

from

...

Craig Farrell (6/20/2011)

---

Lynn Pettis (6/20/2011)

---

Craig,

Is this a mandatory butts-in-chair position or is it something that could actually be done remotely (even during evening and weekend hours)? There may be...

Would still like to see the code for the TVF and the code that is calling it.

Craig Farrell (6/20/2011)

---

[rant]

AAARRRGGGHHH....

One more person, just one more, who applies for an SSIS position (it's specifically advertised as an SSIS position) who's done nothing more than use it as a...

Could you post two more things at this time? The code for the TVF and the code calling the TVF.

GabyYYZ (6/20/2011)

---

I took a quick look at some...

This won't help recover a lost SA password, but at a previous employer I was the only DBA that had the SA password. It was a strong password (actually...

You can also look at setting up a light weight server side trace that logs delete actions against the table(s) involved.