I once read

"Documentation is like sex. When it is bad, it is still better than none at all.:D"

Just occurred to me, maybe I could use column_id in sys.columns.

Thanks for the reply.

But I want to return a specific column, say column 2 from a table.

In other words I want to use the table as a sort of multi...

Sorry, I didn't mean to be so vaugue, I just didn't consider that the actual code would be relevant to varying speeds (I can be a bit dim at times)....

Right there is your problem then. You cannot connnect to sql 2005 instance via Enterprise Manager.

You will either need to create a 2000 version of your db, or work...

Which vresion of SQL server are you running? Are you perhaps trying to connect to a SQL 2005 or 2008 version in Enterprise Manager?

Many thanks for your replies. Lots of good advice. Never thought about restoring for different customers!!

I agree with Steve, I think it's called collective responsibility. You wouldn't believe the number of people who whinge about why should their taxes pay for education, when...

Council housing is not a welfare benefit. It is council owned rented accomodation. Many people in council housing work and pay rent. You are talking about those...

tedo (7/30/2008)

---

you really have to ask yourself why are they underprivileged, most of them don't go to school, we have a free education system in the uk you don't...

Oi!

Not all English girls are chavs!!!

Blimey!!! I was surprised to see this thread 6 years after posting!:w00t:

Well, I took the DBA postition, and I learned loads! It was a great experience, and I...

Steve, thanks for the editorial.

Why do you think that the show attracted a lower number this year? Any ideas?

Not here either.

Although the 'boys and their toys' theory could be right. Many DBA's and other IT people I know ride motorbikes, and even have pictures of...

No, I'm English. But at a friends house in Texas, a large box of doughnuts was presented proudly to me and mine for breakfast. Needless to say the...