Realizing that this behaviour may also change in a future version of SQL Server, but is independent of the DATEFIRST setting, take a look at the date routines here: Some...

prash.dark (5/27/2009)

---

I have to use hudreds of select queries. So i can not create Synonyms for every table.

I tried creating a synonym for database object

i.e.

Create...

Roy Ernest (5/27/2009)

---

That is my point, You, Gail, Lynn,Steve and many others have been saying that this is not be done. These are the consequences. But the same person who...

Besides using Dynamic SQL as was also suggested, not really. I think...

You know what, table DDL, sample data (in a readily comsummable format), and expected results based on the sample data would really...

You know, we may hit 5,000 before May 31st!! :w00t:

Hey, I've used this: DBCC CheckDB ....REPAIR_ALLOW_DATA_LOSS, but it was on a development database, not a production database so the potential loss of data was immaterial. Plus I did...

This?

select top 10

*

from

dbo.SomeTable

order by

SomeDateTimeColumn desc

georgew (5/27/2009)

---

Apologies for any confusion, Lynn. I thought I had the week start day issue covered with "...you need to set the DATEFIRST property to change the first day of...

Both solutions work. Thanks for posting yours.

Is there an emoticon for sarcasm? looks like we really could use one. 😉

Roy Ernest (5/27/2009)

---

I was not talking about you at all Lynn.. 🙂 But I am talking about people who will give that solution as the first solution before anyone can...

Roy Ernest (5/27/2009)

---

I find it strange that every time there is a problem with Transaction log file size, everyone chips in with truncate of transaction log? These answers comes from...

I went back quite a ways to get questions answered. Took a bit of time and definitely tested my memory.

Here is some code to play with. Please notice how I have setup the data. this is how you should post your questions instead of relying on others...