Thanks for the advice.

So to migrate I script out the DB objetcs, tables, SPs' etc and create on the new server with Latin1_general_CI_AS collation and then DTS the data...

So do you think it is best to set the collation code to SQL_Latin1_General_CP1_CI_AS on the new 2005 Server?

From my further reading it mentions that the current Collation code:

We currently have 2 SQL Servers that I would like to provide HA failover for.

Would I be correct in assuming that we could failover each server to one another in...

We would need the high availability option.

I had initially seen a product called NSI-Double Take but have decided against it as it seems a bit flaky.

I would possibly be looking...

My definition of a failover solution is if you have a live sql server and a failover server and the live server fails, the failover server would assume the role...

Cheers guys.

Sorry what I meant to ask is:

There have been no security patches between SP3a hotfix 878 and the latest SP4 hotfix?

Another question is:

If I have to roll back I will...

The database will autogrow when the database reaches its limit of 50MB, IF there is enough free space on the disk that the .mdf resides.

I normally set my DBS to...

As the user was a group I had to run the sp_revokedbaccess 'username'

regards

Carl

Sorry I forgot to include the search for type = 'U' for users tables:

create table #dbobjects (objectname varchar(500))

exec sp_msforeachdb 'insert into #dbobjects

select name as objectname

from [?].dbo.sysobjects

where name like ''%NewTable%''

and type...

Try the following against the master database:

create table #dbobjects (objectname varchar(500))

exec sp_msforeachdb 'insert into #dbobjects

select name as objectname

from [?].dbo.sysobjects

where name like ''%XXXX%'''

select objectname  from #dbobjects

drop table #dbobjects

Regards

Carl

Try using the sp_msforeachdb stored procedure and check the sysobjects table where name like 'XXXX%'

Regards

Carl

Jennifer,

Could you not script out one of the failed jobs and run the script to drop and create it and then see whether the job works after doing this?

The only...

Well you learn something new every day. 

I wasn't aware of the originating_server column in sysjobs.

thanks Andrew

Regards

Carl