I actually built a solution similar to what you're describing using Bulk Load from the SQLXML.  I'm actually processing large FIXML (Financial Information eXchange) files with size in the 50+ MB.  Here are...

Thank you so much guys.  Plenty of ideas of how I can organize my T-SQL scripts.

How exactly do I help you out? Is there a survey or a form to fill out or just by downloading the free PDF you'll get the demographics that you're...

The server has 2.5GIG of memory and SQL grows to 1.8GIG.  It makes sense when you say "QA and EM don't affect the memory uses themselves. Only queries on the...

I have the same problem but I've tried by creating a new account with owner rights to all databases and I still get the following error when connecting with query...

I'll start by looking for "sp_detach_db" in the documentation that came with SQL Server. At the bottom of the documentation for the "sp_detach_db" you should be able to see...