One other thing, you may want to check the "Scale-Out Deployment" page in the Reporting Services Configuration Manager after doing this. I noticed that my old server was added...

That link doesn't work any more, but ultimately you can find the download from here: http://sqlserverfinebuild.codeplex.com/wikipage?title=Install%20Reporting%20Services%20Scripter

I had an error when trying to run the exe file.

I did have...

Thanks everyone for leaving me on my own to figure this out. 😛

The solution here is that if you want to use a BULK IMPORT function in the SQL Agent,...

I guess no one else can replicate the problem?

BULK INSERT tempTable_test

FROM '\\<server>\<folderpath>\<csv file>.csv'

WITH

(

FIRSTROW =...

Ok this is an attempt at the abbreviated version of the code because the rest won't post (just a bulk load statement).

CREATE TABLE tempTable_test

(

column1 VARCHAR(50),

column2 VARCHAR(50),

column3 VARCHAR(50),

)

Here is the sample...

I can't seem to post the code after many tries. I wanted to make it easier for someone to replicate the problem.

You can be a pesky Kiwi. I can't fix the other statement I don't think because it has...

PaulB-TheOneAndOnly (6/11/2010)

No doubt documentation can always be better but in general terms I do like Microsoft documentation - main problem is to find the right document.

In regards to compatibility levels...

Is it just me or does Microsoft documentation just not explain compatibility levels very well? Usually the documentation just tells which options you can use, but does not explain...

Hi Paul,

Thanks for pointing out the inefficient SQL code. I copied the statement from another place in the code and replaced a column with GETDATE().

If you are interested in...

Those webpages were created by salesman. I think we are looking for technical reference documents.

Thank you, Paul, for your time and your response. You cleared up my confusion about compatibility levels. If nothing I wanted this topic to be discussed and should...

PaulB-TheOneAndOnly (6/4/2010)

Shall I understand that with or without that index exec plan was the same? :blink: and, after creating the "missing" index peformance got better? ... with the...