Just guessing, since I have not actually used either SQLXMLBulkLoad or Merge Replication, but....

Since Merge Replication depends on triggers to log changes, could the trigger somehow be bypassed.  Is the...

Another security reason for a separate instances would be to disable networking protocols for that instance.  Having developed some of those "vendor apps" that require separate instance, we have designed the applications...

There is a limit, but I think it is 255 fields.  Are you sure there isn't a problem with that field?  Is field size <= 255? Is field name a...

Yes.  If you choose per-user licensing, and the website is intranet, or otherwise you will have authenticated users, you will need CALs for each user.  CALs are not for each...

Also, you can use Bulk Export/Import queries on each table and reload all the data.  It's amazing how fast bulk operations are.

Yes, you can use CALs for accessing SQL Server from MTS components.  The same rules apply, you need a CAL for each user/device that will access the MTS component that...

Also related to this topic is the subject of defragging database files.  Especially for a database that has been allowed to grow and shrink often, it can get extremely fragmented...

Often.  Could be major rewrite to extend the application or bring it "up to date".  Could be platform upgrade (client/server to intranet).  Could be just a large refactoring effort.  In...

I'm not sure that these items would cause the query to take 5 hours, but you might want to check these.  1) Are there any triggers or default values on...

quote:

---

Is there a better approach I just don't know about.

---

Develop the "business...

I ran into the same problem where I could not use (local)\instancename, only when trying to connect to MSDE using Shared Memory protocol. I did find that using the...

How about using ExecuteImmediate instead? I have an application that creates a local database based on the SQL created from a ScriptTransfer method. It has the GO statements...

Let me add another vote for isolating the data access through DLLs. Do not let any ASP code (or any client application) ever touch the database directly. Doing...

Or sp_help <tablename> (easier to type)

quote:

---

Ok could this be cleared up a bit. The note doesn't state that the other applications are on other machines thus leaving...