It looks like your incoming file is setup for data in one column.

"col1, col2, col3"

"1,a,b"

"2,c,d"

Can you confirm that your csv file has the double-quotes around each line like I show...

I usually use Visio for this.  If you are MSDN subscriber, it is included, and has Reverse Engineer utility to import your current database.

Hope this helps

Surya;

I am not sure that you can have those parameters "in-line" like your code shows, or you need to have a SCHEMA.INI file (http://msdn2.microsoft.com/en-us/library/ms709353.aspx) in same directory as your...

Frank;

You are correct on the problems with log backups and recovery when having two separate full backups.  You are better off just having the SQL backups to disk files, then...

2 options:

Option 1, have your application construct a dynamic SQL statement, using Case constructs for each column for each store:

SELECT ArtID, Desc,
CASE StoreID WHEN 1000 THEN Status ELSE Null END...

I believe that some SQL Server editions do not provide the custom installation window to change the database path at installation.  If available, it should be under the Feature Selection...

Easiest way for you is to use FOR XML RAW and BINARY BASE64.  Example is from BOL:

USE AdventureWorksGOSELECT ProductPhotoID, ThumbNailPhotoFROM Production.ProductPhotoWHERE ProductPhotoID=1FOR XML RAW, BINARY BASE64 ;GO

produces

<row ProductModelID="1" ThumbNailPhoto="base64 encoded binary...

I found the topic in BOL on "Troubleshooting Routing and Message Delivery" to be helpful (see http://msdn2.microsoft.com/en-us/library/ms166044.aspx)

Also remember that if there is a problem with the SP in the...

...anyway i got a trigger (insert) as i want to insert in as400 tables the same data ...

Joel;

DON'T!!!  Do not put code in a trigger that depends on an external...

To use shared directory in a web farm (or web garden), you need to have the file directory mapped and permissions set for each web server and site to access...

What are you logging in from?  From your other recent posts here, I assume you are accessing SQL Server from Excel, then you must be using ADO or ODBC?  Then, check...

Actually, it is more than 8 connections when the workload governor kicks in.

Vy, you can check you server's Application Event Log, and see if there are any SQL Server 3629...

Well, that is true also, have to give that to you. 

The instance I have in mind is XML documents coming in through my web service from various business partners. ...

And that's why we design systems to minimize the risk of "gremlins", isn't it?

And, yes, unless I know the XML will never be too large for varchar, I would...

I don't know if changing to 90 would make a difference for you or not.  I would check that list in BOL that William tried to post in here and...