So, that last solution works fine when you're talking about a sequential hierarchyID, but if there are elements in the tree missing, or you are dealing with a query where...

Could be mistaken, but I'm fairly sure that when you execute an ALTER DATABASE SET OFFLINE, it will automatically wait until all processes are finished running before it takes the...

I think what you're looking for is the ROW_NUMBER() windowing function. Try this:

WITH cte AS

(

SELECT

FirstName,

LastName,

MoveDate,

StreetAddress,

Suite,

CityName,

StateName,

PostalCode,

ROW_NUMBER() OVER (PARTITION BY MemberID ORDER BY MoveDate) AS rowNum

FROM @Members

LEFT JOIN @MemberAddress ON MemberID...

Alright, I guess I found an answer ... doesn't really seem like the intended way of doing it, but this works:

-- Get the current hierarchy number at the level in...

Did you try changing your query to get the columns instead of using SELECT *? Probably a good idea in general, since it means you won't risk having columns which...

Server utilization spikes for that one second, since all those jobs run at the same time. I wonder if it might have something to do with that. I've tried simply...

Nothing really of value in the server application logs either...

Just some jobs, I'm trying to isolate which ones, but there doesn't seem to be anything in common between them. I'll check the server logs and see if I can...

Incidentally, I recently got an alert from Azure - they are retiring this pricing model, and moving towards a new one that features a virtual server hosting Reporting Services instead....

Hi Jason,

Thanks a ton for that piece of advice - was exactly what was causing my problem.

You can use the command -accepteula to avoid this problem from arriving.

Hey Phil,

Thanks for the advice - you definitely started me off on the right track. It was indeed an issue with the 32 bit vs 64 bit environment, but what...

Hey - I know this is a very old post, but I must have spent *hours* searching for the solution, and this was *exactly* what I needed.

Thanks a ton...

Problem with using that approach is that, if you choose to not save sensitive data, then you will have to specify all parameters that are sensitive each time you run...

Alrighty, never mind! Bit more searching turned up the following result:

http://www.sqlservercentral.com/articles/Development/2824/

Kinda unfortunate that it is not supported by default from SQL Server 2005 Standard :/

Stores may not have been the best example to use 😛 How bout, let's say, information about a client - the client's home address, name, etc...

The only reason I'm considering...