Hi, SqlServer has inbuilt version control for DTS packages, but for other software I'm not sure !?!. Regards, j.

Hi Tomtom, have you gone straight to the source and asked Microsoft what their opinion is of running this many Db's ?, i.e is it technically feasible or even...

Or get a white marker pen !

Yeah, post-its are generally not a good idea as they tend to fall off over time or when the cleaners are in, instead I find writing them around the border...

Hi,

It's much easier when your migrating to the same server/instance of Sql as the 'link server & some other objects' already exist, & by some other objects I was referring...

hi sdidomenico,

all of your options will work, but you have to be aware of some caveats !, i.e if you use your option 1) DTS, then your tables, data, logins,...

Hi,

Ok, we've fixed the error now, thanks for pointing me in the right direction. I shall try to summarise for you;

Originally our first error was a failure when users...

hi crab7,

we applied sp3a to our servers in the hope that it would fix the issue ( as reported on the Microsoft website ) but it did nothing to solve...

Hi crab7,

Have you run 'dbcc checkdb' on all your db's ?, as I had a similar problem on our production servers recently that produced exactly the same scheduler errors you...

Hi racosta,

Can't run repair_rebuild at the moment as we have users in the system, so i will have to wait until later for that.

Original cause is not known but we...

Hi racosta,

yep, ran checkdb and got this;

Server: Msg 8966, Level 16, State 1, Line 1

Could not read and latch page (1:1490) with latch type SH. sysindexes failed.

DBCC execution completed.

And we...

All,

Ok, we've traced the problem to the fact that the servers system date format changed when it was shutdown & restarted, i.e was 'dd/mm/yy' prior to shutdown and 'mm/dd/yy' after...

Philip,

Your approach sounds like a very good solution to our problems, I think we'll attempt to do the something similar here.

Thanks.

j

Ferguson,

Thanks for the reply, have you had any complications ( other than not being able to show dependencies/impact analysis ) from storing the DTS packages as structured storage files in...

As a DBA, I would prefer to be over-informed ( i.e attend all the meetings ) rather than under-informed, at least then I can take informed decisions as opposed to...