The regex won if the pattern had text in between separate numbers, and you wanted that simply removed, the last function I proposed won if not.

The example I used was...

Access forms can directly connect to a table-value function. You don't need the view in between. You can even put the input parameters in the form definition.

In the...

Roy Ernest (4/21/2008)

---

I would suggest you to use a Case statement over an OR clause.

SELECT blah

FROM blah

WHERE IsValid = 1

...

IDs will work well here. PersonID and TownID should be "int identity" data type, and should be the primary keys for those two tables.

(By the way, what Sam is...

I might be missing something, but why have single-quotes around the column names in your insert statement?

I copy-and-pasted your code in Management Studio (I don't have a copy of Query...

Since an indexed view is, fundamentally, a separate table, that would work. I'd go with a...

Oberion (4/18/2008)

---

it is a viable solution and it doesn't take a lot of work. If the users aren't in the approval list, then when their long running query hit...

itsme_dev08 (4/21/2008)

---

Hi,

I tried out the example to create a recursive query(Sample 1)...i get the following error when I run the script :

Msg 156, Level 15, State 1, Line 1

Incorrect...

Ryan's query should get you what you need.

If I'm not mistaken, openrowset can write to a file as well as read from it.

david.tyler (4/18/2008)

---

Thanks for your reply. I don't have control over the procedure being called, only the parameters being passed. I can pass as many @withmove parameters as I have data...

First, there are questions to be asked about the purpose of the auditing. How will it be used?

If it's meant to provide legally defensible audit trails, which might end...

Not sure what you mean. What are you looking at doing with the historical view?

Can't help you on that one. I didn't know there were different versions of the Options module for different versions of Management Studio. Maybe someone else can point...

Oberion (4/18/2008)

---

why not do the following:

write a code to check for duration of a query and if it doesn't match a certain group of users, that spid is killed. ...