In the past, i've changed it where i've circled it below under IPAll. that has been how i assigned a static port for my express isntance to listen to.

you must have a process that is harvesting the data off of the web site, right?

if the format of the data changed, that would throw off the import of the...

i'd code it with an EXISTS like this:

IF EXISTS(SELECT 1

FROM PARM

...

dave could that be mySQL that you pasted?

the syntax doesn't match SQL server;

the equivilent would be like this:

IF Object_id('StormHeader') IS NULL

CREATE TABLE StormHeader ( ...rest of definition

you can create an INSTEAD OF trigger on a view, and have that trigger do the DML to the desired underlying tables.

your code will then try to insert/update/delete fromt he...

lol i got two honorable mentions in there!

I gotta know, what is in that Lowell_used_columns file? i'm sure i have the same script saved, but I dunno what yours references!

Thanks...

ahh the by months things going to be tough...you can't just use the 87 days between them? you have to have it broken down my whatever number of months between?

do...

ahh, yeah zeroing out the log file ,...

are you are restoring a backup of the database as a new database?

I believe it can take time for the operating system to find 120 gig of as-contigous-as-possible space...

lets do some basic diagnostics;

does this return STARTED or something different?

EXECUTE msdb.dbo.sysmail_help_status_sp --STARTED?

try stopping and starting the mail service:

EXECUTE msdb.dbo.sysmail_stop_sp;

GO

EXECUTE msdb.dbo.sysmail_start_sp;

and finally, yes, you probably need to bouhce the SLQ...

make sure all your columns are NVARCHAR, and not VARCHAR....that should resolve the conversion issue, i think.

collation only decides how the strigns are sorted and ordered by...it does not decide...

my suggestion: don't store a total in the table. create a view which calculates the total on demand instead...that way it will always be accurate, and you don't need a...

if you only want to update where those three fields are not null, then the WHERE statement would be with AND isntead of OR:

...

WHERE A.lastname IS NOT NULL

...

here's an example of two different techniques that do the same thing:

/*ANewIDDiffID

0000012300000123

0000005600000056

0123456801234568

*/

With MySampleData (TheID)

AS

(SELECT 123 UNION ALL

SELECT 56 UNION ALL

SELECT 1234568 )

SELECT

...

i would simply handle each field with the ISNULL FUNCTION instead:

UPDATE A

SET fullname= RTRIM(LTRIM(ISNULL(A.lastname,'')))

+ ',...