Also, SQL Server will return the error you are getting if even 1 row returns an invalid argument for the substring. So, if one of your strings does not...

I'm not sure that you understand a union in SQL. You...

DBAgal (10/3/2011)

---

MyDoggieJessie (10/3/2011)

---

I don't believe the length of it matters. I used your code and made up a string of nearly 6400 characters and it still ran just...

Did you go into the ReportServer Configuration Manager to do this, or did you just try running a report?

Thanks,

Jared

What did you do to the first one? I was under the impression that you were simply setting up a third server with a new version and that you did...

Hmm... You may have to create another instance on that server for the new report server databases and then you can migrate data.

Thanks,

Jared

Going along with Perry... When you say that Node B hs the reporting data, do you mean the ReportServer databases, or simply the data from some application or warehouse that...

Since your nested SPs are returning result sets, they are going to be returned by your main SP. You will have to go to each individual nested SP and...

Just a note: If the servers are on 2 different domains, you will not be able to use a domain account because one will never authenticate to the other. ...

My guess is that you are seeing a combination of things.

1. Ghost records growing (plus if your data is growing at a rate of 2% that means that the ghost...

Well, you either have to change your purge to fix this, or enhance it. Look at this and surely test it first:

http://serverfault.com/questions/23446/ghost-cleanup

Thanks,

Jared

How are you doing your purges? Maybe a different method than what you are doing will help? For example, we use partitioning. We then switch the partition to...

Great thought! Try running...

Hmm... Have you tried restarting the SQL Server service? If you did not notice until yesterday, something had to happen between Friday and Monday. Someone HAD to make a...

Another thought is your clustered index. As the values in the composite columns get greater, so does the storage space required by the index. Also, as I understand it,...