djj provided the link above. I'm looking into it now...

My bad, I guess I didn't go into enough detail in the OP.

I am aware of the dangers of xp_cmdshell, and I use it a) sparingly and b) carefully -...

Hi Jeff,

To be clear, it's not her account that has privs on xp_cmdshell. And she is a trusted user.

Moreover, the sproc she's executing that's calling xp_cmdshell take no parameters....

OK, but that account already owns quite a few DBs, while not having a "personal" login. So I wondered if there was a way.

Thanks Gary.

Exception calling "SetOwner" with "1" argument(s): "Set owner failed for Database DB"

+ $db.SetOwner("[Domain\User]")

If memory serves -- and it's been a loooong time -- the detach-attach functionality only arrived with SQL 7.

So you're stuck with Restore Database.

First, create an new, empty db.

I think...

Here's a slightly different approach: start with the the matching groups, so you don't process users that aren't members of any of those groups.

Then count the groups for each of...

Hi Erland,

They only need to be able to create a new schedule for an existing job. Essentially, I want them to be able to call a stored proc at the...

Hi Chris,

Yep, that was my conclusion too. However, since query fails, I couldn't see the execution plan. Unless there's a way?

And, the iTVF would probably neatly obviate the original...

So it turns out that in the 2 failing scenarios, the function is going through the full table before applying the WHERE clause, and failing on a row where first...

FWIW, Thinking it might have been generating an n x 1 CROSS JOIN, I moved the JOIN dbo.lookup out of the select statement in the function, since it wasn't actually...

Now, when I change the definition of that column in the table function to allow NULLs, it works!

And the last 2 versions which previously threw the error do NOT...

Once again, that's not the problem: call that function directly with the single value -- and there is only one single value in this example -- and it works just...

That's not the problem, HanShi. The first name and last names are not null in this instance, and if you look at the original post, you'll note the code works...

Function code below.

Specifically, the error thrown is:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'Clientname', table '@tRS'; column does not allow nulls. INSERT fails.

The...