- With aligned indexes, sql will take the most advantage of the mechanisme when querying partitioned objects. (because the indexes will basically have the same algorithm applied internally, so in...

Just some quotes out of the field :

- don't implement DRI, because that will only slow you down !

(Your application will have control anyway)

- Remove DRI, this way...

What extra info is given with your error number ?

I suggest to use the "regular" restore scenario.

Create a backup of the original db using

backup database xyz to disk=c:\temp\mybackup.bak' with...

There is a nice overview of features at MSDN http://msdn.microsoft.com/en-us/library/ms365247.aspx

this is one reason why we script all our jobs on a weekly basis :Whistling:

What you could do is : ( ON A test SERVER IF YOU CAN ! )

-...

(11 row(s) affected) (94 row(s) affected) (8 row(s) affected) (94 row(s) affected)

Msg 7726, Level 16, State 1, Line 38 Partition column 'RgValue' has data type varchar(36) which is different...

Just another thought: You are at the console, or are using a remote desktop solution to run SAC, right ?

We now only have SP3 instances with sql2005 and are not...

Try this:

SET @bcpCommand = 'bcp " select ' + @CTX_TRAILER +' " queryout "'

Why aren't you using the T-SQL "Backup database" command with a SQLCMD ?

Oh, you should !

Why ?

- bugs have been cleaned up

- new features have been added (SSB, logon triggers,..)

- performance optimisations

- SSMS menu items have been shifted around (SP2) :sick:...

What service pack is your sqlinstance on ?

Select Serverproperty( 'ComputerNamePhysicalNetBIOS' ) as ComputerNamePhysicalNetBIOS

, Serverproperty( 'Edition' ) as Edition

, Serverproperty( 'InstanceName' ) as InstanceName

, Serverproperty(...

Did you change the SAC connection from localhost to the logical server name of your sqlserver instance ?

e.g. mysqlserver\myinstance you should connect to mysqlserver.

Why do you want the dependancy of both pk columns?

- an identity column auto increments its value by the increment value. If not tampered with that definition, it will generate...

did you try this in SSMS:

EXEC sp_configure 'remote admin connections', 1;

GO

RECONFIGURE;

GO

With clustering stuff, many thing must be managed using cluster administrator!

What are you looking for ? (With regards to instance management)

Whenever possible indeed !

OP stated

I...