Steve

Sorry - would have quoted but the forum was insistent on quoting another post when I clicked quote 😀

I would put money on the fact that when you used SET...

Heh

http://lmgtfy.com/?q=sample+tally+table+t-sql

and

http://lmgtfy.com/?q=create+scalar+function+t-sql

Sorry - i'm more of a 'give a man a fishing rod' kind of guy 😀

My guess (place your bets now people) is that in your UDF you are calling DateTime.Parse(). If that's the case, use DateTime.ParseExact(). Pass in null for the IFormatProvider.

I've got to...

Can I just say - if you're on 2008 (i know this...

singhster (9/15/2009)

---

Glad to be of service.

Can I offer you one bit...

Nice one Lynn 🙂

I've found that for deleting a sub-section of data from a much larger table (for example - can we delete history from transactions table that is over...

Paul White (9/14/2009)

---

George, I do see your point, but remember that non-schema-bound views have always worked this way - it's not a special new thing. Metadata changes can affect...

Reading the thread? 😀

sp_rename is your friend for this one...

Write a scalar UDF that returns you a MAC address based on an int, then use a commonly documented tally table method to generate the MAC addresses based on your...

I have a feeling you might have misunderstood triggers on views... A trigger on a view will fire when rows on the view are updated/inserted/deleted from - not when one...

kiran.hegde (9/7/2009)

---

However the same stored procedure invoked directly from SQL Management studio, throws up an error stating that the login 'abc\0\0\0\0' could not be found(Remember the login abc is actually...

Nope, it's not. But that's how it is...

As for...

Doh. In 2000 sys.sql_dependencies is sysdepends - and it exhibits the same broken behaviour. But then on 2000 you're...

No, not when the knights who say ni are no longer the knights who say ni, but the knights who say 'ekki-ekki-ekki-pitang-zoom-boing'. 🙂