Have you added the SQL service account to have access to the policy?

I use a nasty cursor...

Run on the old server and copy the contents of the results panel to a query window on your new server. The script assumes the users...

In most cases Google is my friend for issues that occur when I dont know the solution...

After a quick bit of goooooogle'in I found...

http://www.tek-tips.com/threadminder.cfm?pid=401

First of all I would run the upgrade advisor (link below), once you have done this then test, test and more testing.

It should be straigth forward from a SQL point...

In addition to stats it could be

- indexes

- CPU/Mem

But I would lean toward stats...

Just check that the connection details are the same, I have has issues when thing...

Hi there are other occurance of this error and a reboot resolved it.

Hi

There are a few print screens on the link below may offer some assistance.

http://www.mssqltips.com/tip.asp?tip=1224

I would personally read a few books by Brain Knight so that you can get...

There is an excellent link that already has the information your require.

In SQL 2005 you can get it from the Help | About dialog.

Not 100% in 2008 though.

Rajesh

A good old saying is "it depends". Reason I say that is because different companies require different skills depending on their size/systems/applicaitons/budget.

If you wanted an answer from me I...

Here is the link you require.

http://go.microsoft.com/fwlink/?LinkId=129527

As previous post say the KB's tell you step by step what to do. The SP's are cluster aware.

Below are the steps from 2005 SP3 readme.

Note the following information before...

As prev post suggest in the link, it is possible that you are hitting an I/O issue.

Grant

Did you get any response on this one?

Thanks

JL

Jeff Moden (5/27/2010)

Curious... Other than the obvious purpose for partitioned tables documented in BOL or the one that Paul laid out...