Hugo Kornelis (3/25/2010)

---

John Carlson-431129 (3/25/2010)

---

vk-kirov (3/25/2010)

---

This is very interesting...

vk-kirov (3/25/2010)

---

This is very interesting because [font="Courier New"]ISNUMERIC(' ')[/font]...

Hi, have there been any updates to this code to make it work in SQL 2005?

Thanks!

Thanks Gail, this actually sounds like a good workaround.

It takes about 30 seconds to recreate this index, so I will probably go with this workaround if it is accepted by...

Hi Gail,

You are correct. This looks like my exact problem.

I notice his table is named "Observances" (mine is ObservancesTest, but it is really Observances in the DB), and his...

What if you execute the 2nd insert statement by itself? (not in the procedure)

You may want to post the code so that we can get the entire context.

Thanks,

John

Scott Duncan (5/15/2008)

---

That's probably due to the account SQL Server is using having been logged in before the additional rights were granted. Same as when a user is logged...

I've made a modification of Hasan's code to use a UNION of Outer Joins instead of a cursor. I know this one example is small, so it really doesn't...

Solution found!

Stopping and restarting SQL Server has fixed the problem. I'm not sure why this was necessary, but it now works. (Are there security attributes that stay active...

Solution found!

Stopping and restarting SQL Server has fixed the problem. I'm not sure why this was necessary, but it now works. (Are there security attributes that stay active...

Yes, the sql account (PSSQL) has the sufficient permissions to...

Scott Duncan (5/13/2008)

---

Because the SQL Server service account does not have rights to stop services on that machine.

What rights does the SQL Server service account have on the machine where...

More information:

When running the command

exec xp_cmdshell 'whoami'

it gives me the domain\username of the sql service account that I was originally expecting.

So, I guess I'm back to my original question as...

ALZDBA

- Who is job owner ?

- make "sa" job owner so it uses the sqlagent service account to execute.

- better would even be to create a proxy account which...

I was not aware of that. Any...