I go into the advanced editor and change the datatype of the column

I hate raising threads from the dead but I got the same issue on an SQL Server 2008 R2.

last week I was asked to reschedule a daily job from 8:30...

Ok here's an example of the error I'm getting for the file,note that I post edited the names,now we see here is a truncation error now what's actually happening here...

ok 2 great answers

so the line I'm getting the error on is getting is something like this

''Rac ..... ''Rac company description ..... 251

Now what happens the next line instead of...

Ok tanks for the information I have passed this on,unfortunately it seems we can't do much about the big monster update queries until that app team responds to our request...

I did that,since last time I did try to install I did not get that error

But now after giving the product key

SQL Server Setup has encountered the following error:

File format...

Yeah,I was planning to do that but I'm getting the error

The following error has occurred:

Unable to open Windows Installer file 'G:\x64\setup\sql_engine_core_inst_msi\sql_engine_core_inst.msi'.

Windows Installer error message: The system cannot open the device...

I tried both,default as named install.

At this moment I don't have a working install cd/dvd present,but from I remember is there were no errors in the install only that after...

Ok I'll have this checked,so why are they showing an errorcode in decimal but not the hexadecimal number,that would would make it easier to track these things.

'Executed as user ... The step did not generate any output. The return value was unknown. The process exit code was -1073741502. The step failed.'

is the literal error message out...

indeed,well our team boss is quite angry today because of this 1 application team the go live of this project has been postponed by several weeks if not months

So I've...

Grant Fritchey (12/19/2013)

---

You can't create a view to a "dynamic source." You have to be able define a specific table or set of tables for a view. I'm not sure...

What you did results in the query being

select Chapter_Revenue GLDATE ...

And I think it should be

select 'Chapter_Revenue' GLDATE ...

Solution

SET @sql = 'SELECT ''' + @QUEUE + '''...

OK,this is I feared then.

The problem is that I'm not allowed to put on replication on the databases that actually contain the data,its both to business sensitive and volatile (and...

No the code Nevyn posted did what had to be done.

As for...