- that would be a table with +- 4,000,000,000 rows .... nice

- double check you have an index on that identity column

- Make sure you use the propper technique to...

set identity_insert is at session level !

So it will only be active with your session for your session !

Why are you trying to fill the gaps ?

Are you reaching the...

for sql2000 the current service pack is sp4. (and at least sp2 is required with win 2003).

for sql2005 the current service pack is sp3.

you could generate your drop statements using this query

Select *

from sysobjects

where xtype = 'u'

and category = 0 --(in sql2005 that would become is_ms_shipped = 0)

order by name

Doublecheck you...

isabel (7/13/2009)

---

My schedule for backup is already stable. Full backups every sunday night, and differential backups from Monday to Saturday nights.

Now I have problem with performing my regular restore...

With partitioned objects, I would avoid nonaligned indexes !

(because it may narrow down features and options to perform tasks.)

Unless you can prove performance is better with a nonaligned index to...

- 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:...