Thanks.

I would like to delete the rows where this column is completely populated with the underscores. There are rows that have underscores in this column along with other meaningful...

Thanks for your help. I finally got it through my feeble mind how to do this.

Thanks again. I need to look into a few things and will see where we are here. Our organization is different (than most organizations ). I did not...

Thanks for the question. The answer is Yes and No. The service is running. I can not connect to it. I did not do the actual...

I am not really sure why one worked and the others did not. I suspect my playing with it was that I set the parameter prior to realizing I...

My thanks to all for your contributions. I found the solution and it was to (1) download the 32 bit driver and then (2) indicate "Use 32 bit runtime"...

We moved to a new (virtual) box. We have downloaded the ODBC Driver for 32 bit Access (Microsoft.ACE.OLEDB.12.0) per the Microsoft Website and installed it. This was the...

Thanks for the ideas about scripting out the jobs. Would I be able to do the same for logins, Linked Servers and other objects that are not database oriented?

I was wondering about the restore of the master/msdb (msdb mostly). Would I need to regenerate the Agent jobs and SSIS packages loaded from SSIS for the 2008 version?...

Thanks for your answers. We are moving enterprise to enterprise. However, the current server actually uses little other than what would be considered standard.

I suppose that explains why it does not work.

Thanks for the informaton.:-)

Thanks for the suggestion. I had tried this before, but the main issue is the "Connect to Server" form that has the "Options" opens for only a split second...

Thanks. I have never used the CROSS APPLY, but will learn.

Jeff,

You responded earlier to my question by pointing me to these articles. They are very helpful and I really appreciate it.

I have tried varchar(max) in the subject query and get the same result.

The problem is not the actual storage (I have built a process to pull 8,000 charachters at a...