Thank you, I will try this. 🙂

Unfortunately I had to set this project aside because:

1. I am the only one in the company who works with computing other than...

The other person who works in this data base does not see this when she opens the procs. I think I may have changed something on my workstation in SQL...

On demand run by the user? I hope someone hops in here with an idea, I'd like to learn it too.

I hope I'm not off topic because you did mention needing to use UNIX, but if you want it to run at certain times you can put a job in...

Copying the data in without the headers seems to be the answer, since there was a text field immediately above the pasted data. The odd thing is that I can...

That's interesting, the column before that is the column header from the query and contains the field name. Tomorrow morning I will copy the data without the headers and follow...

Hi, Thank you for your interest.

I should have explained that I've all ready tried that. In the SQL query I created a field called ProdText by concatenating a single...

I'm glad I found this thread explaining why I can't find the save post feature when I edit a post!

Thank you for your questions, you got me part of the way to resolution!

To your first question, I do use exec msdb.dbo.sp_send_dbmail @profile_name = 'Send Mail'

a lot in SQL server...

I apologize for not posting the code in accepted format. I remember now that when I try to edit a topic I set up, I can get into edit mode,...

That points us in the right direction. Thank you!

We're going to try putting up the linked server using the GUI tomorrow morning.

I checked with the company that installed the server. He says " the server has two instances of SQL, one database in each."

I hope that is a good clue...

Also, I apologize for posting this in the wrong (2005) forum. Is there a way I can move it to 2008 R2?

Thank you for your response. That's what I'm using but it doesn't work. I could do it on the servers at my previous job, but not here. I will double...

Hi Erin,

I am supposed to have access to SSIS but don't know how to find it, or get it installed, or whatever. Not opposed to learning something new.

As...