My dream birthday present? I live in a small town in western Kentucky and I dream for the day that I can get a job doing what I do now...

Actually, I have figured out the scripting of the indexes but I have one last question (procedure-wise). We use Source Gear for version control of tables, stored procs, etc... does...

I'm convinced that scripting is the way to go with this. Now my question is how to do this. (Not how to do it from scratch, but a specific question...

Steve... nice to see a fellow Jack Reacher fan 🙂

We found the (an) answer... maybe this will help someone else along the way...

We had "n/a" in several fields on the table. I think that maybe the query was doing...

Thanks Jeff,

When I run this sql to create the data, I get the following errors...

Server: Msg 208, Level 16, State 1, Line 7

Invalid object name 'Master.dbo.SysColumns'.

Server: Msg 208, Level 16,...

Susantha,

This worked.... thanks very much! (My book was not that detailed when only adding a filegroup to an existing database)

Bob

Jeff,

You got me on the right track... the problem is in the "SET @col" statement. I had

SET @col = 'Part2.Part1'

What I didn't realize is that the "Part2" and "Part1"...

I've got a problem that I can't figure out... I'm using the following as suggested to get the data to the right of the delimiter...

(SELECT STUFF(GL_SWT,1,CHARINDEX('.', @col+'.'),'')

It works fine when...

Jeff,

This is exactly what I needed. Thanks very much!

Bob

It is a char(35) fieldtype

Thanks for the reply but we found the issue. It had to do with a home-grown workaround that we had in place. One of our developers fixed it for me.

Bob

In my "real" statement, there are 7-8 tables involved, but I am testing this in only one table. If I can get that to work, I can extrapolate the logic...

Thanks Michael!

A followup... I want to install the SQL2000 client tools on my machine where I already have the 2005 client tools. Do I need to apply the SQL service pack...