Graeme100 (10/16/2007)

---

Yes just to confirm

Merge replication manages it's own identities, and very well. It uses a stepped identity approach. Table A on Server A will have identity range of 1-1000,...

Thanks John, i will give that a go in dev and see what i can get from it, i kinda went down this route first and then decided there must...

Disk space? although i think thats error 112. Do you have a Tran Log backup on a database that has been changed to simple mode? Do you...

Done some more digging and got a work around..

The direct answer is no, there is no altercolumn Sp. However the script below does the job. Please note that...

you mention you uninstalled sql 2005 and then reinstalled 2000, are you sure the databases have not been backed up from a 2005 instance? if that is the case...

one thing i would say to check is that the file extension is correct, make sure you have bak and not .bak.

Cheers guys, a reseed was the answer! thanks

John

Yes we are planning on moving to 2005 before xmas, although i have advised the company (i only started here last week) that we should wait for 2k8 in Feb....

Ignore me, the scale i have realised is purely for viewing on the graph, and that the figures shown are the actual figures to be used

Thanks Noel, i guess i will just use a bit of trial and error (although hopefully the main server wont go down too much!!). I'm thinking as i...

Hi Graeme,

Thanks for the response. The reason for the "serverB" is reporting and like you say if serverA does encounter problems bringing serverB online isnt an issue. My...

Thanks to both of you for your replys, i was after something which told me if data had been read, or modified but it seems SQL doesnt provide this, not...

Hi Jim,

Thanks for the reply.  I have tried running a one off import using the old 2000 exe without issue, but i was wondering if there is a way so...

Thanks for the reply.

i tried dropping the view, recreating with schemabinding, reassigned my permissions and still get the same error

For the first reply...

The only other thing i used was measureUp, that was purely just question and answers with explanations which was useful as well. The only thing the Exam Cram book...