I'm just saying that the current-most SQL Agent log file's ...err ... create date(?) doesn't coincide with the most recent restart of the database instance. Up until now, across all...

Awesome. I look forward to seeing your iTVF code example. Learning ... gooood 🙂

--=cf

I'm not familiar with the iTVF's, so I'm following my original thread, and the guru's can correct me ...

Inside your function, you can just write T-SQL code, as the SQL...

I would just write a function which returns the string you're interested in:

SELECT serial_number,

fn_error_code(serial_number) as err

FROM t

WHERE fn_error_code(serial_number) is not...

Andrew,

We don't always control INS/UPD/DEL through stored procs. So these users will have those DML rights against tables (and we don't have the staff to change everything over to sp's...

No offence taken, as I've been struggling with choosing the best approach for awhile now. If this problem can be solved AND we could use AD accounts, then I'm all...

Using this methodology, I'm still not clear on how you're supposed to limit a user's access to the underlying data, where they can just use an alternative, ODBC-compliant tool, (like...

This is really embarrassing....

Never mind, there was a Script Task off of the screen at the top of the control flow.

Ugh,

--=Chuck

OK, good to know that I still can't modify the code behind a typical object from the toolbox. And in this case, I'm not trying to alter the code, just...

Thanks Hugo. Luckily, there were no objects within those schemas. Just an ex-employee listed as their owner. Unfortunately he's not here to ask why he was setup in that manner.

--=Chuck

In this case, I was just creating a new account to access these procedures. When the Developer was testing the new account, these errors arose. The original creation of the...

So, what I initially thought was a permissions issue at the database level (some problem granting EXECUTE on all procedures), still turned out to be a permissions issue. Had I...

Just as a follow up, I tried to create some sample code so that this could be reproducible, and using the following

create table junk (pk integer);

insert into junk values (1);

go

create...

Would you mind clarifying your last sentence there? Currently, the data in both of these databases are unrelated. The data which was sequestered on an instance unavailable to the webserver,...

"Audit Login Failed" worked, but there's not much more information than I received in the actual error message. I did at least find that whatever this is, is using the...