as the link details the workaround is to un install the mismatched features

i too, use the RSS tool. Easiest way to migrate

has this server been renamed at some point?

Check this link[/url]

download and read the whitepaper

yes, it is.

if they wont convert then yes!! Look at this way, your job should be safe for sometime 😉

Guys, you get the message 'Current SKU is invalid' because of the licence key.

When you get to the part of node 2 install where you see the licence key, delete...

Table\index partitioning is exactly what it says. Within this there are 2 methods of partitioning

Horizontal partitioning - rows are separated into partitions

Vertical partitioning - columns are separated out into partitions

if the database is in Simple recovery the log will truncate on checkpoint, also the alter index is minimally logged so this should not need log file modifications

to effectively shrink the log file you will need to back it up first

then the error wasnt network related or instance specific was...

varshachyk (4/24/2010)

---

Hi All,

on one of our server Re-build index job is failing with the below error. Please suggest.

Failed: (-1073548784) Executing the query "ALTER INDEX [PPS_USER_SESSION_COOKIE] ON [dbo].[abc] REBUILD WITH (...

if the database is in full recovery model then log backups are...

the following will work for sql2005 on

select...

Can you supply a little more info on the error. Check the SQL server and Windows event logs