Ian Massi (5/15/2014)

---

I doubt I'm the only one who read that metaphor and though, "Man, wouldn't it be great to have a software development project as clearly defined as a...

What's needed is a kind of SARBOX for the IT industry.

But I guess we haven't encountered a big enough scandal to motivate/justify this.

Thank Heaven? :hehe:

But you should get a dialog saying

Cannot find the

C:\Users\(youruserid)\Documents\WindowsPowerShell\Microsoft.PowerShell_profile.ps1 file.

Do you want to create a new file?

Instead what are you getting?

I thought this could all be done now with 3D printers.

Jokes aside, I recently saw a CNN special where they showed how to create a very sophisticated artificial limb...

Microsoft should think about the alternative - which is to bury this material.

Not a really cool idea at all.

Thus make it public.

There are no in-betweens.

I mixed up Express edition with Evaluation edition.

Nevertheless, has the OP ever gotten over this problem?

No problems installing multiple versions on W7Prof+SP1. Thus have SS2005, SS2008, SS2008R2 and SS2012.

The only thing I watch for is that they are all named instances, in fact, I'm using...

Have a go at creating an email account on yahoo using the name Ronald Reagan and variants to create an email address from this name. The number of email addresses...

I think my simple performance test may have a weakness due to the random data I throw at it using newid(). This very likely causes pwdcompare to exit very early....

OK, I understand now this use of replace. Thus you should separate out this kind of check from the rest since the string '_Replace_' will be used in only a...

Adam,

Just out of curiosity what exactly does this mean:

REPLACE(pc.[Password],'_Replace_',sl.name)

Also, how exactly will you login to 250 or so instances to run this and gather the data into a single table?

Why...

Thus are you referrring to CROSS APPLY here?

Regarding...

sqldriver,

You didn't understand my remark regarding removing one of the rows with cgm='5'.

If you do that your solution will now show even more incorrect results.

I understand what you are trying...

OK, just saw your use of LAG which means SS20012.

But you're making completely wrong use of it.

If you delete one of the rows with cgm='5' from your data and run...

sqldriver,

Could your data also contain a sequence like the following, i.e. cgm changes without one or more rows having cgm null in between:

('1', '2012-01-01 07:05', '5'),

('1', '2012-01-01 07:06', '5'),

('1', '2012-01-01...