irobertson (10/19/2010)

---

I don't think so. Because SQL can't know the content of the two fields in your computed column until it computes them, the expression will always be non-deterministic, persisted...

irobertson (10/19/2010)

---

Hi,

This is probably due to your use of a computed column. From BOL:

Your computed column is non-deterministic (even though it's...

please post the entire query, and if possible some sample data

I was hoping I would be able to pull something with event notification but I can only create it with server-wide scope, which is a no-go. I'll study further the...

Derrick Smith (10/4/2010)

---

Tracing to a file sounds like the best option then.

I take it there's no way for you to just explicitly deny select on any tables you don't want...

GilaMonster (10/4/2010)

---

dant12 (10/4/2010)

---

No, you absolutely do not. Not unless you want to cripple performance. Tracing to...

Craig Farrell (10/4/2010)

---

dant12 (10/4/2010)

---

@Craig

Our application database is usually managed by us.

This new client doesn't want us managing the database and we don't want him running any selects around....

Derrick Smith (10/4/2010)

---

Why can't you save the results to a table, out of curiosity?

Would saving it to a file be a better option?

Literally your only option here is to run...

Craig Farrell (10/4/2010)

---

Easiest? ...

Jeff Moden (9/15/2010)

---

Jeff Moden (8/3/2010)

---

dant12 (8/2/2010)

---

yeah sure ill send you a .csv if your willing to play with it, but i wouldnt bother so much. you already gave me lots...

HowardW (8/31/2010)

---

Assuming these are varchar/nvarchar fields, then if there's no data in that substring range (e.g. the field length is shorter than 613 chars) then it will return a blank...

heres the VB code

<Microsoft.SqlServer.Server.SqlFunction(Name:="UF_DAYS", _

SystemDataAccess:=SystemDataAccessKind.Read, DataAccess:=SystemDataAccessKind.Read)> _

Public Shared Function FRAMINGDAYS(ByVal ID As Integer, <SqlFacet(maxsize:=500)>...

i agree the design is flawed but its one of those things that has always been there (way before i entered the company) and too much has been built on...

we have a table that stores a formula in T-SQL form in a column and that needs to enter in a T-SQL query, the only way to it on T-SQL...

actually that is the expected output, you can try setting it all to upper and adding extra spaces, dots