I have seen this on VERY large tables, you might need to add a statistic, that has seemed to resolve a lot of my issues.

CEWII

Glad to hear it is all worked out.

CEWII

Koen Verbeeck (3/26/2012)

---

I don't really use the filesystem, as I like the pro's about SQL Server storage:

* packages are secured by SQL Server

* when MSDB is included in the backup...

Agreed, I'd like to know this as well..

CEWII

Good to know, best of luck..

CEWII

What is your criteria for whether the data is available?

CEWII

So it creates the sproc then executes it in SSIS? That is not what I would do. I agree, I'd rather it be in SQL in general.

CEWII

You're welcome.. I had to go back and see what I say since this post is so old.. Glad to be of help..

CEWII

eforta.it (3/22/2012)

---

rudy komacsar - Doctor "X" (3/22/2012)

---

is not necessarily correct ... unless 'threads' are are construed to mean 'logical CPUs'...

Any resources? All resources? One node? Both Nodes?

CEWII

I generally simply add the login as an AD user with no special rights.

At the server level if you change the permissions from the configuration mansger it should handle the...

I haven't used it in 2003 with SQL running so I can't be as 100% certain, but I'm like 98% certain. It doesn't take the colume offline, it updates...

True but depending on how you get that C# code called was my point.

CEWII

Lynn Pettis (3/22/2012)

---

The problem with doing backups across the network to a file server comes down to network issues. SQL backups do not handle network hiccups very well and...

I had this error under VMWare and VirtualBox..

After MUCH searching I found an article that at: http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/d96afca2-9cb7-4a5c-b8a9-9ee2d3fedef1/%5B/url%5D About half way down a response by Ryan_AU.

This was the...