Tara (4/9/2009)

---

GSquared

Your proc looks good but i get some errors as

Not all users can use select from sys.databases and so i want to exec proc as an id...

";WITH" sets up a "CTE" (Common Table Expression). I used that to put a Row value into the data, so I could query that in my Where and Join...

Did you forget the "escape" part in the actual query, or just in the forum?

Couple ways to do it. First, you could just add an "alias" to the query you already have. Do that by typing a name for it after the...

Please don't double-post.

Put square-brackets around the underscore in the Like statement.

There is a MUCH easier way to calculate business days between two dates. Create a calendar table, and pre-populate the data into it, then just select the rowcount between...

Something that might make all of this a little simpler to manage would be to modify the model database so that it has the necessary roles already created in it,...

Here's my take on it. Has some injection-proofing (might not be enough).

CREATE DATABASE DBA ;

go

USE DBA ;

go

CREATE PROC DBCreate (@DBName_in SYSNAME)

AS

SET nocount ON ;

...

You can't do precisely that, but you can have a join with conditional logic, or you could have an inline sub-query in a case statement if you just want one...

UB (4/9/2009)

---

GSquared,

Okay may be the code gives an incorrect view of the problem I am trying to convey. I want the INSERT transactions to be audited from any user.

My...

As mentioned in my first post on this thread,...

Whatever user name you have it running under isn't mapped to a security account in SQL. You need to do that. Go to the properties of the user...

Judging by what you set up and what you expected to happen, it looks like what you want to do is NOT audit when certain users add data to the...

Prioritize where that's clear, FIFO if priority isn't clear.

For...