I'm afraid you can't.

I checked the event viewer and sqlagent.out, but there's no user info there.

If the db is not there, sdd the user to the db_creator server role, so that he can create the database and be its owner.

If the db is already there,...

We don't need many of them, just enough to show us the expected results.

Pain In The A$$. I didn't want to write it fully, I though the acronym would have been enough.

2. How it can be possible with single...

Undocumented and unsupported, but should work.

EXEC sp_msForEachTable 'ALTER TABLE [?] ADD newColumn int NULL'

Probably because they're not aware of the single privileges that they have to be granted instead of sysadmin.

If they started...

This could be a starting point:

http://www.sqlteam.com/article/monitoring-sql-server-agent-with-powershell

Hope this helps

Gianluca

I suspect you're not running the same exact statements. Maybe you're running the statement providing parameters in a slightly different way than the app does. Could definitely be parameter sniffing.

When...

Agreed. It's not always a matter of tools. Appropriate communication an cooperation can do more than...

I would like to help you, but we need more information. The T-SQL batch is not enough.

We need:

1) Table scripts (CREATE TABLE + CREATE INDEX)

2) Sample data

3) Expected results and...

GSquared (9/21/2011)

---

I don't know. Maybe I could trade Larry Ellison your house for his company. Works for me!...

Ninja's_RGR'us (9/21/2011)

---

Gianluca Sartori (9/21/2011)

---

Stefan Krzywicki (9/21/2011)

---

That sounds pretty funny. I'd think if it were really the best, the consultant would be able to say "Oh, you just have this configured...

Stefan Krzywicki (9/21/2011)

---

That sounds pretty funny. I'd think if it were really the best, the consultant would be able to say "Oh, you just have this configured wrong, let me...

Stefan Krzywicki (9/21/2011)

---

Ninja's_RGR'us (9/21/2011)

---

Stefan Krzywicki (9/21/2011)

---

Gianluca Sartori (9/21/2011)

---

Stefan Krzywicki (9/21/2011)

---

I know a few people here have used Oracle quite a bit over the last year or so. I'm having trouble...

Stefan Krzywicki (9/21/2011)

---

I know a few people here have used Oracle quite a bit over the last year or so. I'm having trouble creating a linked server connection to an...