You are - now get going...

Welsh Corgi (11/17/2011)

---

I'm glad that I remembered; I did not think I was...

Try this

Create proc dbo.someproc

That's a lot more simple than the expression I use. So easy thanks for posting back.

also, when executing have the user exec the proc using the dbo schema name

e.g.

exec dbo.proc

is the user logging in using the same account you granted to dbo?

Have you configured SSRS prior to this?

Are you just renaming the computer?

GilaMonster (11/17/2011)

---

Ola L Martins-329921 (11/17/2011)

---

The "AND" operator will check against the date-columns seperately - not simultaneously which in the case with "BETWEEN".

Using GREATER THAN and LESS THAN in the above...

Chad Crawford (11/17/2011)

---

Wahoo! Just passed the MS 70-453 test, making me a MCITP for SQL 2008 just in time for 2012 to come out. 😀

Very happy - Passing...

troubling and waiting

Ninja's_RGR'us (11/17/2011)

---

SQLRNNR (11/17/2011)

---

Jack Corbett (11/17/2011)

---

To get back to the original question, Jason and Remi :-P.

I think we need more information about what your job duties are supposed to be before...

septum

Jack Corbett (11/17/2011)

---

To get back to the original question, Jason and Remi :-P.

I think we need more information about what your job duties are supposed to be before anyone can...

Are you right clicking the instance in...