Thanks, Michael.

This is the same thing that I just went through... I thought for sure that my latest article was on something very obvious. It turns out that it's not...

Michael,

You have a line of code that looks like the following...

else if @s2>=@s1 and @s2 @f1

What is the missing operator after AND @s2?

Spot on... 😛

Do you mean N number of Locations?

I agree with Sergiy... however, sometimes you gotta do what ya gotta do.

Post your code so we can try things out...

Would "context switching" work for you? Here's the example from Books Online...

-- Switch execution context to the dan1 user account.

EXECUTE AS USER = 'dan1';

-- Execute the DBCC statement.

DBCC CHECKDB...

HENRY DAVIS (5/9/2008)

---

Strange scenario: sysobjects has a record of a user table, however that table does not exist.

select * from SYSOBJECTS where name = 'table_name'

--(1 row(s) affected)

select * from dbo.table_name

--Server:...

Just a recommendation... Like you said, use ISNULL... don't mess with the default server settings on this...

There's a couple of chances this might work... "Slim and None"... and Slim just left 😛

Things like that can be real tough to determine... thanks for the feedback! I'll have to remember that.

Jon Russell (5/9/2008)

---

Great article, Jeff. This is must-read for all database developers. I have inherited a few databases created by application developers who think in terms of loops,...

ALZDBA (5/9/2008)

---

Jeff Moden (5/8/2008)

---

It's a 1995 Honda NTV650. (The little brother of the Pan European)

It's current evolution is known as "Deauville".

Quit...

srienstr (5/9/2008)

---

Would using sp_MSdependencies provide a way for managing that? (I don't see a way to handle it without iterative processing, though it can at least be done using...

I agree... just not if the solution requires a cursor...