What account owns the object? The dev must have Impersonate permissions on that login, per Books Online, in the chapter on "Execute As". That's most likely what's missing.

Sergiy (6/5/2009)

---

Not any part.

It will fail...

Jeff Moden (6/5/2009)

---

Heh...

What I have found is that whatever managment thinks is "sexy" will get the dollars. That usually means GUI dev tools or some chunk of hardware...

Okay, Steve. Normally I back you up when you have typos in articles and someone calls...

Jeff Moden (6/5/2009)

---

Gianluca Sartori (6/5/2009)

---

I won't blame Jeff if some day it stops working, I will just restore the old procedure and tell the users they have to wait 90...

It has to be configured. Check the options in Enterprise Manager under Management.

declare @Test datetime;

--

select @Test = '6/5/09 1:12 pm';

--

select dateadd(hour, datediff(hour, 0, @Test), 0);

You can use that dateadd(datediff()) method for taking any part of a datetime off. Works very well,...

James Rochez (6/5/2009)

---

GSquared (6/5/2009)

---

David Fulton (6/5/2009)

---

I am relatively new to IT, so my opinion is more from other areas and you may want to take it with a grain of...

blandry (6/5/2009)

---

Reading the posts in response to this question is interesting - everyone is talking about developers and admins, but I didn't see anyone talking about the sales guys!

...

But...

I picked nchar(1) for the same reasons many others did.

Question is too vague. Define "best".

Varchar is definitely not the best, since it will actually take more space than char...

Gift Peddie (6/5/2009)

---

The tendency I see, regardless of the size of the company, is that devs are more visible and their tools do have a more immediate and visible return-on-investment,...

george sibbald (6/5/2009)

---

GSquared (6/5/2009)

---

The tendency I see, regardless of the size of the company, is that devs are more visible and their tools do have a more immediate and visible...

It's a known issue. Order By sometimes messes up the concat.

The tendency I see, regardless of the size of the company, is that devs are more visible and their tools do have a more immediate and visible return-on-investment, while admins...

David Fulton (6/5/2009)

---

I am relatively new to IT, so my opinion is more from other areas and you may want to take it with a grain of salt. However,...