All of you have been very helpful. I want to thank you all. Paul, Steve, David, and anyone else I forgot... Thank You.

I WILL NOT be using...

Thanks to all.

1. I will only use nulls where the value is unknown. middle name is a perfect example.

2. I use .net for a front...

Thanks for that. One less thing to worry about.

thank you

I'm aware of the error when trying to go to a table... I was just wondering if I can set something, so that when I try inserting too large a...

I see your point, but I got it.

I had to use windows scheduler to run at strartup, call a batch file that calls a powershell script that waits...

What I was trying to imply was that if I wanted to insert an identity that was an integer instead of a guid, I would have to use a cursor...

Thanks for all your help folks... I think fogbugz looks pretty good.  We have management in our organization.  I manage one side, and we have a non-programmer managing the other. ...

I would try dynamic sql... like the following... you should probably add another command to check for file existence, so you can handle failure correctly, but this works

>Im not sure...

Thanks everyone, I was being a dork.... not checking things thouroughly enough.  I didnt see enough output in qa and freaked.  I'm sending sql...

yes they can be run on one box,

reporting services comes with sql 2000 standard, so you dont need to worry about its license.  As far as processor, ram, that...