Have a look in BOL at FOR XML EXPLICIT.

Quite powerfull.

It allowes you to mix and match nodes with attributes.

Cheers,

Crispin

There is a utility called Mascon by Scibit (www.Scibit.com) which allows you to port the data/tables to text file.

You can then use DTS or BULK INSERT to load it into...

The way I do it and have yet to have a probem is quite simple.

Run your select, adding the results into a temp table (Rather create the table instead of...

Might be unrelated but SP 3 for 2K is out.

When viewing the execution plan, does it use indexes? Are there indexes?

Other than that, I can't be much help.

How big is...

🙂 What I'll do is next time I take leave (Ummm, might retire by then) I'll dialin and stop the service randomly. Blame it on the disks, old server etc......

To some people, two is one to many.

I am constantly fighting for more money for hardware. Our machines are getting old.

Peolpe think if it's working, don't touch it. Never...

I can understand that when the view is executed it would use the indexes.

In the proc, there are plenty where clauses that referr to the columns returned by the view....

If you ask a DBA, it should be more.

Ask the bean counters, DBA's are not required. The servers just work...

Cheers,

Crispin

I'll ask

He said no.

Cheers,

Crispin

quote:

---

Never mind, it's only a cap,

---

The last time I got something for free was when...

I just shot myself in the foot. I gave bogus info there! Dho!

Maybe I change it. Wonder if they will send it international?

Cheers,

Crispin

Thinking about it, I think it's a hoax. How will I get my geeky looking cap?

Cheers,

Crispin

Just completed it. Not sure what I got myself into.

Maybe now I will be getting emails asking if I am lonely...

Short survery and useless if you ask me.

Dunno...

Cheers,

Crispin

These guys have a nice app.

http://www.xpressapps.com

I have been using it on and off for a couple months now.

The version I have is still Beta but there are very few bugs....

After asking around I was told that you can't attach a DB to a file. Sorry about that 🙂

Did you get it right?

Cheers,

Crispin