By the way... if you believe in paper instead of code, please read the Microsoft article at the following link...

http://support.microsoft.com/kb/153441/EN-US/

See where it says "NOTE: This problem does not apply to...

Man, I really appreciate you watching out for me, Sergiy. I've learned a lot from you. Thanks...

Ok... like I've done before when this controversy of Select/Into has come...

Exact same principles apply... but, now the requirements sound like homework. Recommend you take a look at Books Online and do your own homework... 😉

Good luck.

Barry... nice blog! But why don't you write that stuff as articles on SSC? 😉

Ok... no error checking except for total number of rows. That also means, no primary key in this instance. You have to remove the primary key from the...

Heh... Barry's post wasn't there when I started typing my response.

I agree, Barry... I used to call variables such as these "accumulators" which is also probably more appropriate.

"Pseudo Cursors"? ...

bkDBA (9/19/2008)

---

Thanks. Good info. Have you actually tried it? Not trying to be a smart guy about this... I've heard that the auditing features of 2k8 are...

Ninja's_RGR'us (9/19/2008)

---

Jeff Moden (9/18/2008)

---

Heh... not exactly true...

SELECT *

INTO #MyHead

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...

Madhivanan (9/19/2008)

---

Jeff Moden (9/18/2008)

---

Heh... not exactly true...

SELECT *

INTO #MyHead

FROM OPENROWSET('SQLOLEDB','Server=(local);Trusted_Connection=Yes;Database=Master',

...

With error checking... broad subject... lemme start by asking what you want to do with the duplicate primay keys included in your sample file?

Wandrag (9/18/2008)

---

Whoa -this is cool....:)

Can you please explain how this works (Not the sp_refreshview part), but the fact that one don't have to loop through the view names to build...

Still, will that create a directory that doesn't already exist?

Heh... "These are not the droids you want... move along." 😛

Thanks, Jason... I misread your previous post a bit. I agree that these are...

Alvin Ramard (9/19/2008)

---

So how do fix this problem?

Should we work together to find a bunch of resources/white papers that we can present to management to should them what they're doing...