Thats where NTFS comes in. No need for a user to have direct access to the mdf's.

Andy

Then you should look at approles - perfect for the situation you describe. Kudo's to Brian K for asking the right question!

Andy

CDO does support this from what I can find on MSDN using a configuration object. Have to admit Im not entirely clear on the differences between CDO and CDONTS! Still,...

Restricting access using NTFS permissions is important too. They should not have direct access, only via the db engine.

Andy

Click Tools, Options, then the results tab. Use the 'Results Output Format' dropdown. The default is column aligned, but you can change to tab delimited.

Andy

Backup/restore is a good plan, log shipping more trouble than its worth for this change (and it essentially does the same thing anyway). The key is that you're going to...

Im definitely against any data type desc in the column name. Where I work, we have an app that uses "foreignkey" for all the foreignkey cols. Guess what it calls...

Not directly. The only way to keep them out would be to set the db to either dbo only or single user mode, or you could temporarily change their permissions...

Connection pooling and/or object pooling may be the issue here. I havent had any problems with @@rowcount (have you checked MSDN to be sure though?). I would suggest you test...

Do you know the stored proc is executing for sure? How about adding some logging to the proc so you can see if it's running and what value was passed?

Andy

...

Couple questions. How do you get an int to hold that value? The max value is 2,147,483,648 (or (214) 748-3648 as a phone number!) Another question is why did you...

Easiest way would be to run Profiler while you create the package, that should give you the list without too much work!

Andy

Honestly I dont know:-) I think the package will run ok, the question is how will the data look. You might want to pull some data out of the db...

Im not sure I agree with a separate drive for the pagefile. I know it's recommended, but if you're even close to properly configured, you shouldnt be hitting the page...

They should all execute independently, assuming that running one doesn't cause another to be blocked by locking of the data. Not impossible, but I think 1000 at once would be...