Forget my last statement. I think you were alone the right lines about multiple log files.

I have tried to attach the db to a test sql2000 box and noticed the...

Just restored the database, and found the mdf has a max file size set (which it was close to)

That explains one thing (I couldn't quite understand why a 10gb log...

Forgot to say. There is a large turnover of data loaded into that database (as you can see from the size of the log file).

Not a lot else on that...

Only one file for each the mdf and ldf.

The mdf is only around 200mb and the log file was over 10gb.

They are restoring the last backup for the time being...

One other email package I have used is aspemail (www.aspemail.com).

This email package is free (if you don't want to use the premium features), and needs a smtp server which doesn't...

I add alerts against the following error codes (in sql server agent), then add myself as the operator for the alert.

18454 Login succeeded for user '%ls'. Connection: Non-Trusted. (with the...

If you plan not to use the SA account, remember to put a password on it.

I don't use the SA account so just to be sure I have placed an...

Using SQL 2000 Transactional Replication I had added a new table to the article without breaking replication.

I had to rerun the snapshot which then generated the article for the one...

Never really had a problem with them.

The only thing I find you have to be careful with is the scheduling. Otherwise you find you get the job failing with...

sp_addlinkedsrvlogin [ @rmtsrvname = ] 'rmtsrvname'

[ , [ @useself = ] 'useself' ]

[ , [ @locallogin = ] 'locallogin' ]...

Use sp_addlinkedserver to create the linked server, then sp_addlinkedsrvlogin to add the login details.

EXEC sp_addlinkedserver

@server = '???',

@srvproduct = 'Oracle',

@provider =...

Thanks,

After playing I have worked things out in my head etc.

One for me to test I think.

I presume that if the extended stored procedure is placed on one of the shared drives, that when the instance changes modes it should...

No I don't have a problem at the moment. I am about to install a test A/A cluster with different db's on each node.

Hence I started wondering about if a...

As long as the two servers can talk to each other ie not blocked by firewalls etc. you can replicate between the two.

As for security you can state a sql...