Are you using Enterprise Edition or Standard? If Enterprise, you might be able to set up a snapshot you can use. I've heard of that being used with...

Have you tried moving the insert statement into the command string?

*** Build the command ******

SET @SQLString4 = 'INSERT INTO DBNames([SQL Instance], [DB Name], [DB Owner], [compatibility_level], [create_date])

Select DISTINCT [SQL Instance],...

Is that a local drive, a SAN, a network drive, something else?

dma-669038 (7/19/2011)

---

You west coasters are a different league!! BTW am an indian lady too, i'd appreciate some casual western garb atleast occasionally (jeans, shorts in summer) let alone colorful indian...

For that kind of volume, I'd go with Enterprise. Might need Datacenter if you need any of the specialized capabilities in there, but that's got more to do with...

It usually takes me about a week to find my niche in a group. Sometimes less.

In a really complex group, it might take as much as two weeks. ...

Any solution that depends on row-sequence like that is going to end up being some form of cursor or another.

So, either use a real cursor (static should perform well on...

Freddie-304292 (7/19/2011)

---

I think it's a bit unfair to say that people out of work for a year are bad DBAs. They may be great DBAs, but bad at job-hunting,...

I haven't tried XP 64-bit either. Not sure it would actually matter, but might be interesting for curiosity purposes.

Stefan Krzywicki (7/18/2011)

---

GSquared (7/18/2011)

---

I've had two different people from South Africa try to convince me that Afrikaans is "more original". They didn't seem to be trying to pull my...

Windows 7 isn't using Win32 as its core any more. That's the whole point.

Have you tried on a 64-bit Windows XP system?

David Portas (7/18/2011)

---

As a general rule aim to be in at least Boyce-Codd / 5th Normal Form unless and until you find good reasons to do otherwise. That's the best...

I've had two different people from South Africa try to convince me that Afrikaans is "more original". They didn't seem to be trying to pull my leg, but you...

4 Gig is the cut-off that 32-bit can address without help. AWE is necessary beyond that. Or go 64-bit and ignore the whole thing. The first DBA...

bopeavy (7/18/2011)

---

GSquared (7/18/2011)

---

bopeavy (7/18/2011)

--------------------------------------------------------------------------------

Nadrek (7/18/2011)

--------------------------------------------------------------------------------

Nobody who's an idiot, perhaps. Steal laptop, remove drive, image drive to your own storage medium for offline analysis and selling/publishing proprietary data....