You need to make just a single change per ALTER DATABASE, and in your case you are changing both the SIZE and the FILEGROWTH. Break those out into two ALTER...

I'm guessing that your data source differentiates between the two by having nothing between field delimiters for a NULL, and an empty string ("") between field delimiters for zero-length character...

cl, my code handles that issue if you want to use it. It's the same concept as PW's, but I noticed that you had two records with the same starting...

Sorry for the dupe answer. PW's post wasn't there when I read the OP. Mine also ended up with a nasty smiley where the close parenthese should be.

See if this (untested, unoptimized) works for your purposes.

SELECT

 y.ProjectNo

 ,IssueNo = Min(x.IssueNo)

 ,y.DateStarted

FROM

 dbo.Projects AS x

 INNER JOIN

 (

 SELECT

  ProjectNo

  ,DateStarted = Min(DateStarted)

 FROM

  Projects

 GROUP BY

  ProjectNo

&nbsp AS y ON

  x.ProjectNo = y.ProjectNo

  AND x.DateStarted =...

What do you want "field role" to be set at if the name shows up in "fname" in one place and "sname" in another?

Also, is "gid" always equal to "1"?

There is no direct equivalent in T-SQL, but you can accomplish the same thing usually, depending on what you want to do. Could you clarify a bit what it is...

If memory serves, most versions of FoxPro can import CSV files, so you could BCP out to one of those. I also seem to remember that it required quotes around...

I don't know of any bug in the editor that would cause the behavior you're having. Since Notepad is a pure text editor, while word pad is a mini-word processor,...

Untested, since there's no server handy, but this should do the trick:

SELECT

    EmployeeName = e.EmployeeName

    ,ManagerName = m.EmployeeName

FROM

    dbo.Employee AS e

    LEFT OUTER JOIN dbo.Employee AS m ON

        e.ManagerID =...

This might do the trick for you, depending on your exact needs.

The fact that it works from DTS and not from a stored proc gives us another possibility. It's possible that the SQLServer service and the SQLServer Agent service have different...

Lots of possible issues, but as an initial test, I always try to send a regular e-mail through Outlook from the server.

You can't use the IF inline like that. Replace that line with:

CASE WHEN BillFormats.BillFormatDescription IS NULL THEN (Select BillFormats1.BillFormatDescription

FROM RptBilling RptBilling1 INNER JOIN BillPatients BillPatients1

ON RptBilling1.BillPatientID = BillPatients1.BillPatientID...

You really might want to rethink whether to post that query or not, even if you need to change column names for some reason. I'm guessing you have something in...