Because I don't know what you've done on that webpage thus far I do have to ask, did you follow that guys deployment instructions before trying to run the script...

Thank you. I went with your suggestion and my install is running.

Nevermind, I changed the recovery model to Simple and did a shrinkfile and it shrank it down to 1MB.

Thank you. I appreciate your assistance.

I do have one more question.... if the transaction log is set to auto grow, would you still set the size to 100MB on...

Yes, I want to shrink the file.

I know why it got that big.....kind of a long story to type out. Bottom line is backups weren't being done for over...

Sorry but in the interest of getting all information posted, see my full script below which includes the latest suggestion.

Disclaimer: I'm self taught so don't get too rough with me...

Thank you. That TOP 1 part worked when I use it on one account at a time. I figured I could take that same idea and apply it...

That did the trick.

Thank you.

That may have worked. I'll check it for sure tomorrow. I just didn't get why copying previous code that worked doesn't work....I'm not looking for an answer why...

I will check with the vendor and the agreement. I just figured if I didn't "break" the db in the process I was good. Before the last upgrade,...

Thank you...that is what I needed to know. I guess that shows I haven't spent much time exploring other areas of QA and EM.

Thanks again!

I want numbers summed up that have the same visit_id and if > 0, I'd like it listed. I'll try HAVING. Thanks.

I've tried method #1 and it gives the exact same results as my example in my previous post. I'll try method #2.

I guess I'm so new to sql, I don't know how to phrase the question.

The script I've written so far is returning something like...

visit_id ...

Thanks for the reply Ben.

That script worked great after I changed CICP from upper case to lower case.

Please excuse my ignorance on this question....

What does the N do in...

IF OBJECT_ID(N'dbo.NewShippers')...