Google DNS aliasing (or something like that). You can create a DNS alias that points the old server name to the new server. As you deploy new systems...

Can you provide more information on these backup files? What types of backups are they?

Here is what I came up with. Please look at my setup as this is what you should provide instead having us guess at your table structure and data...

Assuming a consistent format for the string:

declare @TestStr varchar(64) = '[N] 18. Is the C.B. removed from the panel? [Yes / No]';

select

patindex('%]%', ltrim(@TestStr)), patindex('% [[]%', @TestStr),

...

It would help to have the DDL for the tables involved, some sample data for the tables and the expected results when the processing is completed.

Luis Cazares (6/3/2013)

---

Would it be something like this?

CREATE TABLE #TEST

(

COL1 VARCHAR(10),

COL2 VARCHAR(20)

)

INSERT INTO #TEST (COL1, COL2) VALUES ('Bed+Vat', 'Vat')

INSERT INTO #TEST (COL1, COL2) VALUES ('Bed+Vat', 'Cess')

INSERT INTO #TEST (COL1, COL2)...

Been watching long enough and I have to ask, if it does not parse what (if anything) is the error message you are getting?

Jeff Moden (6/4/2013)

---

Brandie Tarvin (6/4/2013)

---

My Recovery Plan

1) SCREAM really loudly so everyone knows there is a problem.

2) Run out of the building as fast as possible.

3) Update my resume.

4) Job...

MyDoggieJessie (6/4/2013)

---

Thanks Lynn, yes I was aware of this occurring when you do it via SSMS but I was more curious as to why the same thing doesn't happen when...

Temporary fix, right click on the server instance in Object Explorer, select properties. Go to the Advanced page and change Two Digit Year Cutoff from 2049 to 2020. ...

Actually, it should have cost you additional licensing to install SSIS on a separate server. The licensing for SQL Server does not allow installing different components on different servers...

What about permissions on the share (not just the actual directories).

And what is the error message you are getting?

Looks like the procedure was created in the users default schema and permissions to other users has not been granted to this...

[snarky reply]

One runs on 32 bit hardware the other on 64 bit hardware

[/snarky reply]

Actually, not much. You can move databases between both environments without any changes. What exactly...

Not sure if I missed anything, not really enough test data to be sure.