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-2

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. It is...

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