I would love a copy as I am starting a new position and I think this would be a great starting point for me.

word_diva@hotmail.com

THanks,

Nancy

I ran the script and it does what you said it would. Very nice. I have used the BIDocumentor tool because it goes down to the column level,...

Thanks for responding. It is obviously SQL code, the problem is I cannot figure out who/what is call that particular code. It is not in any SQL script...

Thanks, didn't catch the SQL 2000 part.

Nancy

Not sure what you are referring to in step 2:

--2. Stop MSSQLSERVER service, replace created mdf file with original one

Nancy

Looks like I got it to work and oh goodness, it looks like it is going to be fun to play with!

Thanks for everything,

Nancy

I am having trouble getting the SSIS to work. I should mention I am using SS 2005 and VS 2005 and that I am a novice as SSIS and XML.

I...

Sorry about that, actually I was just thinking it would be another way to gets lists, but I can do that with regular queries. I just hadn't used...

Hugo, about your code:

SET @ComplaintList = ''

SELECT @ComplaintList = @ComplaintList+ UserComplaint+ char(13)

FROM ComplaintsTable

WHERE UserID=@UserID

..

Return @ComplaintList

I thought that might be something I could use for various things, but I...