Yeah I changed all the objects that had the incorrect owner using sp_changeobjectowner but these were left. Tried your suggestions but to no avail.

Looks like I will have to...

If nothing is passed to it then I do not want it to search for everything, i.e. '%%'

So if they only entered a DocumentNo value but no Desc value then...

Weird - I had it like that before but it wasn't working. Have been messing around with it so much I didn't think to revert back to it!

Thanks 🙂

While...

GilaMonster (8/26/2008)

---

What parameters are you using?

One problem with using the yyyy/mm/dd format is that it's ambiguous. If I write 2008/04/10 does that mean the 10th of April or the 4th...

I get the following error:

Msg 8114, Level 16, State 5, Procedure usp_ECL_Stock_Receipts, Line 0

Error converting data type varchar to datetime.

Thanks for your help so far!

GilaMonster (8/26/2008)

---

Bear in mind that datetimes are just that. Dates and Times.

If a user passes 2008/08/18 to your...

Thanks Arjun, that is useful but I perhaps should have been more thorough with my detailing.

The stored procedure will be executed by a report. The user will pass two...

Sorry, my bad, did not see the ^ symbol.

Works great now - thanks!

Thanks Ryan - That returns all alphanumeric values but I want the opposite. Tried the same as far as...

788 - what is the maximum?

I'm going to give my brain a rest for the moment before I take any more 🙂

Hi guys,

I have just got back home having passed 70-431 🙂

Very pleased to gain my first MS certification!

Richard

Thats exactly what I did 😉

Cheers

Ramesh - spot on 🙂

Resolved this yesterday by installing IE6. The problem was that the server was in a workgroup without internet access so I had to download the...

I assume the £4.99 doesn't include Transcender? I can't access eBay at work so can't see 🙂

I'm having problems with this too. Installed Database Services and Books Online from CD1 and when running the setup from CD2, I am not presented with an option for...