Hi Sue, 
It does look like the solution will work very well if 
1. The data has a fixed small length. 
2. The table is fairly small. 

In my...

Hi Perry, 
I couldn't figure out how to post formatted code alongside my question. Thanks for helping me reformat the code.
What do you think I am missing in the...

Yes, exactly. I couldn't think of a way to bind them together. I mean the method you proposed certainly works but it's that manual work of typing the value...

Hi Jason,

The raw data excel has the actual data as it is now.

The desiredformat.xlxs shows how I want to capture the data although the data is not actually real....

Hi,

Thanks for trying to help but I do not think I made the problem very clear. The data that I presented is just a small chunk of the data...

1. Service master key is the instance level and master key can be database level. I do not see the need to backup the master key as you can't delete...

I found out that there are two ways to make sure the subscriber is only read only. The first way is to change the job step for the SQL agent...

yes, but only merge replication allows web synchronization. I need to be replicating data over the internet between two data centers in the future and I found this is the...

No,I only require that the changes made on the publisher be made on all the subscribers.

I understand. There is no pressure 😀

Hi Lynn,

I have a question that you might know the answer to. I have the ODBC logging set up and working for an smtp server. It seems every successful...

Thanks for you help,

I was finally able to find out the issue. It is very strange but the ODBC source was trying to login using the service account for...

Hi Brandie,

I created a system DSN and the OS is running on Windows 2008r2. The problem is that I couldn't find a lot of information online regarding how to...

I am fully aware of that Perry. However, we have limited number of Entperprise licenses and I want to know how many licenses we need for the cluster before I...

the excel file that I attached is actually the data that exported from the table that I need to load into. Sorry, the table that I was working with was...