What has been asked can be done without a cursor or while loop. What we are looking for is why this needs to be done in the database. ...

Looking at BOL, NULL is returned on error or if a caller does not have permission to view the object.

That makes permissions another area to consider, depending on what user...

I ran your code on my development server, and it worked fine. I have to ask the question, are you sure all the databases were started? That is...

Satisfaction brought him back...

I've been fighting that fight here. How about:

1) Off-site storage costs too...

Let's up the numbers. I'm curious as to why you need to do this as well.

I noticed this is cross posted here.

Is this a SQL Server 2005 or SQL Server 2000 problem?

Edit: Additional info has been posted on the other thread. Please direct...

I don't really know. I get the...

Just noticed that this is double posted here.

Is this a SQL Server 2000 or SQL Server 2005 question?

GSquared (3/2/2009)

---

Something like this:

declare @Date datetime;

select @Date = '3/5/09';

select

case datepart(weekday, @Date)

when 2 then dateadd(week, -1, @Date)

else dateadd(day, -1 * datepart(weekday, @Date), @Date) + 2

end as SDate,

case datepart(weekday, @Date)

when 2...

Can you provide the code you were working with?

What is the value returned by the following query on your system?

select @@datefirst

More laws aren't the answer, unfortunately. It seems we have a hard enough time enforcing the ones we already have on the books.

What is needed is more people with...

I'm...

Give this a try:

select serverproperty('LicenseType')