Why not consider this.   Post your pictures on your webserver, and put the path and filename in the SQL Server.   With your web page, your users can go to a...

the dos command is TRACERT followed by the ip address.

We have had the alot of problems with DTS jobs creating Excel files.   We finally went the other way.  Using a FILEDSN built into the spreadsheet and creating a button...

There are no dups in the data, I just cut and pasted one record too many.   I have 300,000 records in this table.   Sorry about that.

The table is indexed in...

Rockmoose,  The subquery returns more than one record which causes it to fail.

I have spent many hours on this already and the the self join is the only way to...

Steve,

That did not quite work.  All the data got pushed down one record.

the records with a timestamp of 13:09 should have data, but they did not, instead the data that...

I monitor 127 jobs that are run daily, and so far the best way has been created BEGIN job step that stamps a table, and a END job step.  I...

This has happened to me serveral times.   CHANGING and existing job does not work that well.  Many times I have deleted the step, saved the DTS Job, reopened it, and...

thank you for your help.  I just could not remember syntax for this.  Daylight saving time is taking its toll on me this morning

OK, I made this hard than I should have. 

My solution was to create temp table with distinct CONTDIR, and ORG where ORG is not null and them run a...

Thanks, After I posted I remembered the BOL, but I think I got too literal with the syntex in the BOL.

Thanks again!

I have tried

ALTER TABLE TEST ALTER COLUMN TESTX VARCHAR(50) NULL ADD ROWGUIDCOL

I am getting an error : Incorrect syntax near the keyword 'ADD'.

Jonathan,

Can you provide me with an example? I dont have my SQL book here today

do you have carridge return and linefeeds in the file?

I using it to process a single months data in DTS package. I get my data from a mainframe, I create the table, run a series of SQL statements...